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.
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.
INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN);
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 |
INSERT INTO first_table_name [(column1, column2, ... columnN)]
SELECT column1, column2, ...columnN
FROM second_table_name
[WHERE condition];
Войдите чтобы поставить Нравится
Войдите чтобы прокомментировать