Shulou(Shulou.com)05/31 Report--

It is believed that many inexperienced people don't know what to do about the data manipulation in the sql statement. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

I. insert statement

Insert is used to enter data into a table, and its specific syntax structure is as follows.

The INSERT INTO table name VALUES (value 1, value 2...) we can also specify the column in which the data is to be inserted:

INSERT INTO table_name (column 1, column 2.) VALUES (value 1, value 2pm.)

Example:

The code is as follows:

Insert into country values ('USA')

II. Update statement

The update statement is used to update the data in the table, and its specific syntax is as follows.

UPDATE table name SET column name = new value WHERE column name = a value

Example:

The code is as follows:

Update country set countryname = 'China' where countryid = 4

III. Delete statement

The delete statement is used to delete the data in the table, and its specific syntax structure is as follows.

DELETE FROM table name WHERE column name = value

Example:

The code is as follows:

Delete from country where countryid = 4

After reading the above, have you mastered the method of data manipulation in the sql statement? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.