What is the basic statement of database addition

Basic statements for addition, deletion, modification and query in the database: “INSERT INTO table name field list VALUES (value list)”, “DELETE FROM table name WHERE clause”, “UPDATE table name SET column=value WHERE clause” , “SELECT * FROM tablename”. (Recommended tutorial: mysql video tutorial) Database Add, delete, modify and check basic statements Increase data in the database In MySQL, you can use the INSERT INTO statement to add data to the existing database Insert one or more rows of tuple data into the table. Grammar format: INSERT INTO table name (column name 1, column name 2,…column name N) VALUES (value 1, value 2,…value N); If the data is a character type, you must use single or double quotes, such as: “value”. Table name: Specify the name of the table being operated. Column name: Specify the column name that needs to insert data. If you want to insert data into all columns in the table, all column names can be omitted, just use INSERT VALUES(…) directly. VALUE clause: This clause contains a list of data to be inserted. The order of the data in the data list should correspond to the order of the columns. Example: Insert a new record in the…