Home /
Expert Answers /
Operations Management /
nbsp-come-up-with-a-database-table-and-insert-the-data-into-the-table-customers-orderid-1-2-3-4-pa703
(Solved): come up with a database, table and insert the data into the table . Customers OrderID 1 2 3 4 ...
come up with a database, table and insert the data into the table .
Customers OrderID 1 2 3 4 5 6 Customer CustomerID name 1 Joe 2 Jim 3 Carl 4 Sam 5 Harry Orders CustomerID 2 2 4 4 4 5 Order Total 50 475 50 75 100 535
Expert Answer
Solution: mysql> Table1: CREATE TABLE Customers (CustomerID INT, Customer name VARCHAR(20)); INSERT IGNORE INTO Customers (CustomerID,Customer name) VALUES(1,"Joe"); INSERT IGNORE INTO Customers (CustomerID,Customer name) VALUES(2,"