HomeworkLib
Question

1. (10pt) Write SQL statement to insert a new record (66, Python) for columns CustomerID and CustomerName, into the Cu

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Answer:

INSERT INTO Customers (CustomerID, CustomerName) VALUES ('6', 'Python');
0 0
Add a comment
Know the answer?
Add Answer to:
1. (10pt) Write SQL statement to insert a new record (66", "Python") for columns "CustomerID" and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • solve: Write a single SQL statement to create a new table named Login with five columns:...

    solve: Write a single SQL statement to create a new table named Login with five columns: User(Text), Password (Text), Update (Date), Status (Text) and CustomerID (Integer) Set the default value of LastUpdate to the current date and time ( time) Define a check on Status to make sure the value could either be 'active' or 'inactive' and Write a single SQL statement to list all the tracks that have the exact word 'hello' (including both upper and lower cases) as...

  • 1) Write or select the correct SQL statement that satisfies the following case: Change record with...

    1) Write or select the correct SQL statement that satisfies the following case: Change record with value 'Nick' to 'Cuba' for the 'Last Name' attribute in the table 'Vendors' A. UPDATE VENDORS SET LAST_NAME='CUBA' WHERE LAST_NAME=NICK B.INSERT INTO LAST_NAME VALUES("NICK"); C.INSERT INTO 'NICK' VALUES('VENDORS'); D. INSERT INTO VENDORS WHERE LAST_NAME="NICK" 2) Write or select the correct SQL statement that satisfies the following case: Change record with value 'Gary' to 'Jada' for the 'Style' attribute in the table 'Invoice_Line' A. INSERT...

  • please answer Add the ability to insert a customer. Assume the Customer Table has the fields...

    please answer Add the ability to insert a customer. Assume the Customer Table has the fields CustomerName, CustomerAddress, CustomerState, Customerid. You can google the format of a SQL INSERT statement if necessary. SqlCommand updcmd; updcmd = new SqlCommando; updcmd.Connection = myconn; updcmd.CommandText = "Update Customer_T set Customer State - @customerstate+'Where Customer @customerid and" + " CustomerVersion = @version"; updcmd.Parameters.Add("@version", SqlDbType.Binary, 50,"CustomerVersion"); updcmd.Parameters.Add("@customerstate", SqlDbType.NVarChar, 50,"CustomerState"); updcmd.Parameters.Add("@customerid", SqlDbType.int, 50,"CustomerID"); SqlDataAdapter myadapter = new SqlDataAdapter(); myadapter.UpdateCommand = updcmd; Smyadapter.ContinueUpdateOnError = true; YOUR CODE...

  • WRITE A SQL QUERY SQL SERVER Write a SELECT statement that returns one column from the...

    WRITE A SQL QUERY SQL SERVER Write a SELECT statement that returns one column from the Customers table named FullName that joins the LastName and FirstName columns. --       Format this column with the last name, a comma, a space, and the first name like this: --       Doe, John --       Sort the result set by last name in ascending sequence. --       Return only the contacts whose last name begins with a letter from M to Z. --  ...

  • 5. (3 pts) Write a SQL command that will insert a record into the “appts” table...

    5. (3 pts) Write a SQL command that will insert a record into the “appts” table above for a student named “Kelly”, where the advisor is “JSR”, and the room number is 5. 6. (3 pts) Write a SQL command that will display the name of students that are associated with the advisor named “JSR”. 7. (7 pts) Use the FRIENDS table to answer the following questions. LASTNAME        FIRSTNAME        AREACODE PHONE    ST ZIP --------------- ---------------- -------- -------- -- ------ BUNDY          ...

  • SQL Homework exercises: 1. Write INSERT statements that add two rows to the Members table for...

    SQL Homework exercises: 1. Write INSERT statements that add two rows to the Members table for member IDs 1 and 2, two rows to the Groups table for group IDs 1 and 2, and three rows to the Group_Membership table: one row for member 1 and group 2; one for member 2 and group 1; and one for member 2 and group 2. Then, write a SELECT statement that joins the three tables and retrieves the group name, member last...

  • Telu 31 Using SQL, how can you insert the new record "Tom Lopez in a) INSERT...

    Telu 31 Using SQL, how can you insert the new record "Tom Lopez in a) INSERT INTO Members VALUES ('Tom', 'Lopez') b) INSERT VALUES ('Tom', 'Lopez') INTO Members c) INSERT ('Tom', 'Lopez') INTO Members d) INSERT VALUES INTO Members ('Tom', 'Lopez') 32 Using SQL, how can you insert "Flanders" as a "LastName" in the "Members" table? a) INSERT VALUE ('Flanders') INTO Members (LastName) b) INSERT NEW VALUE Members ('Flanders') INTO LastName c) INSERT ('Flanders') INTO Members (LastName) d) INSERT INTO...

  • Q12. (12 pts) Write SQL statements to insert the following 3 cities as well as your...

    Q12. (12 pts) Write SQL statements to insert the following 3 cities as well as your home city into the city table. If your home city is already listed, then add a different city you have visited. Leave the Population column of the last city empty. If your home country is not listed in the country table, you may also leave the Country column empty and add a comment in your SQL script file to explain this. Then write a...

  • #6 Write a SELECT statement that returns these columns: The count of the number of orders...

    #6 Write a SELECT statement that returns these columns: The count of the number of orders in the Orders table The sum of the tax_amount columns in the Orders table Write a SELECT statement that returns one row for each category that has products with these columns: The category_name column from the Categories table The count of the products in the Products table The list price of the most expensive product in the Products table Sort the result set so...

  • Customer (CustomerId, CustomerName) Employee (EmployeeId, EmployeeName, Salary, SupervisorId) Product(ProductId, ProductName, ListPrice) Orders (OrderId, OrderDate, CustomerId, EmployeeId,...

    Customer (CustomerId, CustomerName) Employee (EmployeeId, EmployeeName, Salary, SupervisorId) Product(ProductId, ProductName, ListPrice) Orders (OrderId, OrderDate, CustomerId, EmployeeId, Total) OrderedProduct (OrderId, ProductId, Quantity, Price) Write the code to complete the methods in OrderJDBC.java (look for TODO items). <---**IN BOLD** throughout code. /* OrderJDBC.java - A JDBC program for accessing and updating an order database on MySQL. */ import java.io.File; import java.math.BigDecimal; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; import java.util.Scanner; /** * An application for...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT