INSERT

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.