The method of inserting data into the table by mysql

This article mainly introduces the method of inserting data into the table by mysql, which is very detailed and has certain reference value. Friends who are interested must finish reading it.

MySQL is a relational database management system developed by MySQL AB Company of Sweden and currently belongs to Oracle Company. MySQL is an associated database management system that stores data in different tables instead of all data in a large warehouse, which increases speed and flexibility.

How does mysql insert data into the table?

The insert into command is used to insert data into a table.

Insert into command format:

Insert into [[,.. ])] Values (value 1) [, (value n)]

For example:

Insert two records into the table MyClass, indicating that the score of Tom with number 1 is 96.45, that of Joan with number 2 is 82.99, and that of Wang with number 3 is 96.5.

Mysql > insert into MyClass values (1), (2), (2)

Note: insert into can only insert one record into the table at a time.

The above is all the contents of the method of inserting data into the table by mysql. Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!