Question

Mike has created the small database to store the tools for homes, you need to INSERT some test data into 3 tables.

Please write at least 2 rows into each of the 3 tables. Provide insert example code only

Answer 1

In SQL, INSERT command is used to insert the required fields in the given table. To insert an valu in a table, we use the command or keywork: INSERT INTO followed by the name of the table and the n follwed by VALUES.

One this part is done, we start the parenthesis and start giving the values as per the table values.

Example - INSERT INTO tablename VALUEE( 100, 'valuename')

As in your case, I have create a simple sql command to insert values into a table.

As per question, I have given 2 rows for each table and then printed the result with the command SELECT * FROM tablename; which prints the contents of the table.

Here is the sample code example:

I.lt Result 1 $sqlite3 database.sdb <main.sql 4. 100 driller1 200 driller2 150 Hammer1 250 Hammer2 350 Wrenchi 450 Wrenchr2 8 Execute > Share main.sql STDIN /* Create a table called NAMES */ 2 CREATE TABLE Drillers(cost int, driller name varchar); 3 CREATE TABLE Hammers(cost int, hammername varchar); CREATE TABLE Wrench(cost int, Wrenchname varchar); 5 6 /* Create few records in this table */ 7 INSERT INTO Drillers VALUES(100, 'driller 1"); INSERT INTO Drillers VALUES(200, 'driller2'); 9 10 INSERT INTO Hammers VALUES(150, 'Hammer 1'); 11 INSERT INTO Hammers VALUES(250, 'Hammer2'); 12 13 INSERT INTO Wrench VALUES(350, 'Wrench1'); 14 INSERT INTO Wrench VALUES(450, 'Wrenchr2'); 15 16 /* Display all the records from the table */ 18 SELECT * FROM Drillers; 19 SELECT * FROM Hammers; 20 SELECT * FROM Wrench; 2 17 N E

• CREATE TABLE Drillers(cost int, drillername varchar); is used to create a table with name Drillers.
• int specifies the value to be an integer.
• varchar specifies the value to be a variable character
• To views the contents of the table, we use the command: SELECT * FROM Drillers;

PLEASE UPVOTE IF THIS HELPED YOU

Let me know if you have any doubts in the comment section.