Increase
1.insert Insertion
Syntax:insert[into]< table name >[column name]values< column value >
Cases:
Insert into Student (name, gender, date of birth) values (' Wang Weihua ', ' Male ', ' 1983/6/18 ')
2. Inserting a table
Syntax: Insert into< existing new table >< column name >select< original table column name >from< original table name >
Example: INSERT into AddressList (' name ', ' address ', ' email ') Select Name,address,email from students
By deleting
1.delete
Syntax: Delete from table name where column name =[column value]
Example: Delete from student where name= ' Wang Weihua '
2.truncate
Syntax:truncate< table name >
Change
1.update
Syntax:update< table name >set< column name = new value >where< Update condition >
Example: Update AddressList set age =18 where name = ' Wang Weihua '
Check
Select
Syntax:select< column name >from< table name >[where< query condition expression >][order by< sort column name >[ASC or DESC]]
2015/4/10 SQL database Additions and deletions