Next, the INSERT statement is used to save new data into a database table. For example:
INSERT INTO user (username, password) VALUES ("test2", "123456");
The preceding SQL command inserts username and password data into the user table. There are some other statements that can be used together with INSERT, such as LOW_PRIORITY, DELAYED, HIGH_PRIORITY, and so on.
Please refer to the following link to learn more about these options:
https://dev.mysql.com/doc/refman/5.7/en/insert.html
