SQL Common Statements

Select *  from PersonSelect distinctName from PersonSelect *  fromPersonwhereName='Huangcongcong'Select *  fromPersonwhere  Year>1991Select *  fromPersonOrder  byIDSelect *  fromPerson limit5Select *  fromPerson Name like"%Cong%"Select *  fromPerson Name like"[!HC]%"Select *  fromPersonwhereNameinch('Huangcongcong','huangbingbing')Select *  fromPersonwhereNamebetween 'huangbingbing'  and 'Huangcongcong'SelectName asXingming from PersonSelect *  fromPersonwhereName is NULLSelect *  intoPerson_back from PersonInsert  intoPerson (name, Year)Values('huangbingbing',1992)UpdatePersonSet  Year=1990 whereName='huangbingbing'Delete  fromPersonwhereName='Huangcongcong'Delete *  from PersonDelete  from PersonCreate Databasemy_dbCreate TablePerson (IDint  not NULL Primary Key Check(ID>0) auto_increment, namevarchar( -) not NULL, Addressvarchar( -)default 'Shanghai', Cityvarchar( -),    Foreign Key(ID)References Order(ID))Alter Table PersonAdd Unique(ID)Alter Table PersonDrop IndexIDAlter Table PersonAdd Primary Key(ID)Alter Table PersonDrop Primary KeyAlter Table PersonAdd Foreign Key(ID)References Order(ID)Alter Table PersonDrop Foreign KeyAlter Table PersonAdd Check(ID>0)Alter Table PersonDrop constraint CheckAlter Table PersonAdd constraintChk_personCheck(ID>0)Alter Table PersonDrop constraintChk_personAlter Table PersonAlterCitySet default 'Shenzhen'Alter Table PersonAlterCityDrop defaultCreate IndexPersonindex onPerson nameAlter Table PersonDrop IndexPersonindexAlter Tablepersonauto_increment= -Create ViewPersonviewSelect *  fromPerson

SQL Common Statements