2015/4/10 SQL database Additions and deletions

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