InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How do you Insert Data Into MySQL? |
|
Answer» The INSERT INTO STATEMENT is used to add new records to a MySQL table: INSERT INTO table_name (column1, column2, COLUMN3,...)VALUES (value1, value2, value3,...)If we want to add values for all the columns of the table, we do not NEED to SPECIFY the column names in the SQL query. However, the order of the values should be in the same order as the columns in the table. The INSERT INTO syntax WOULD be as follows: INSERT INTO table_nameVALUES (value1, value2, value3, ...); |
|