Home >Topic List >How to use insert statement in mysql
How to use insert statement in mysql
In MySQL, the INSERT statement is used to insert new data rows into a database table. If you want to know more about the insert statement, you can read the article below this topic.
insert statementThe basic syntax of the insert statement is "INSERT INTO table name (column 1, column 2, column 3, ...), VALUES (value 1, value 2, value 3, ...);", "table name" is to be inserted The name of the data table. "Column 1", "Column 2", "Column 3", etc. are the names of the columns in the table where data is to be inserted. "Value 1", "Value 2", "Value 3", etc. are the names of the columns to be inserted. data value.
How to write sql insert statementHow to write the sql insert statement: 1. "insert into table name values (value 1, value 2...);", insert the specified data into the existing table; 2. "Insert into table name 1 select * from table Name 2;", find the data in another table and insert it into the existing table.
Related Resource DownloadsMore>
Related TutorialsMore>