SQL quiz. What queries below are correct? (table <b>users</b

What queries below are correct? (table users consists of exactly 4 columns: id , name , surname , occupation )?

INSERT INTO users VALUES ('0', 'jack', 'newton', 'businessman');
INSERT INTO users VALUES (id '0', name 'jack', surname 'newton', occupation 'businessman');
INSERT INTO users (id, name, surname, occupation) VALUES ('0', 'jack', 'newton', 'businessman');
INSERT INTO users VALUES (id = '0', name = 'jack', surname = 'newton', occupation = 'businessman');

Explanation

INSERT statement can be written in two ways.
The first way specifies both the column names and the values to be inserted:

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

If we add values for all the columns of the table, there is no need to specify the column names in the SQL query. The query syntax would be as follows:

INSERT INTO table_name
VALUES (value1, value2, value3, ...);

However, we have to make sure that values to be inserted follow the same order as the columns in the table's definition.

Theory

INSERT Query
The SQL INSERT INTO Statement is used to add new rows of data to a table in the database.
Syntax
There are two basic syntaxes of INSERT INTO statement as follows:
```
INSERT INTO TABLE_NAME (column1, column2, column3,...columnN)]  
VALUES (value1, value2, value3,...valueN);
```
Here, column1, column2,...columnN are the names of the columns in the table into which you want to insert data.
You may not need to specify the column(s) name in the SQL query if you are adding values for all the columns of the table. But make sure the order of the values is in the same order as the columns in the table. The SQL INSERT INTO syntax would be as follows:
```
INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN);
```
Read more.

INSERT Query Example

Following statements would create six records in CUSTOMERS table:


INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (1, 'Ramesh', 32, 'Ahmedabad', 2000.00 );

INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (2, 'Khilan', 25, 'Delhi', 1500.00 );

You can create a record in CUSTOMERS table using second syntax as follows:


INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (3, 'kaushik', 23, 'Kota', 2000.00 );

All the above statements would produce the following records in CUSTOMERS table:


| ID | NAME     | AGE | ADDRESS   | SALARY   |
+----+----------+-----+-----------+----------+
|  1 | Ramesh   |  32 | Ahmedabad |  2000.00 |
|  2 | Khilan   |  25 | Delhi     |  1500.00 |
|  3 | kaushik  |  23 | Kota      |  2000.00 |

Follow CodeGalaxy

Mobile Beta

Send Feedback

INSERT Query

Syntax

INSERT Query Example

INSERT Query

Follow CodeGalaxy

Mobile Beta