Current location - Training Enrollment Network - Books and materials - How to write database addition, deletion and modification?
How to write database addition, deletion and modification?
Add:

Insert into table name value (value 1, value 2, ...)

Delete:

Delete from table name with column name = value

Change:

Update table name set column name = new value, where column name = a value.

Check:

Select a column name from the table name

Query all columns in the table:

SELECT * FROM table name

-Note: SQL statements are case-insensitive. SELECT is equivalent to select.