mysql 的sql编写

L创建数据库CREATE DATABASEdatabase_name;o

2.删除数据库DROP DATABASEdatabase_name;o

3.选择数据库USE database_name;o

4.创建表CREATE TABLEtable_name columnldatatype constraint,column2datatype constraint,o•••constrainto；o

5.修改表ALTER TABLEtable_nameoADD column_name datatypeconstraint;oALTER TABLEtable_nameoALTER TABLEtable nameMODIFYcolumnname datatypeconstraint;o

6.删除表DROP TABLEtable_name;o

7.插入数据INSERT INTOtable_name columnl,column2,column3,.・・VALUES valuel,value2,value3,...;o

8.更新数据UPDATE table_nameoSET columnl=valuel,column2=value2,.WHERE condition;o

9.删除数据DELETE FROM table_nameoWHERE condition;o

10.查询数据SELECT columnl,column2,FROMtable_nameoWHERE conditionoLIMIToffset,limit;o

11.管理用户权限GRANT permissionsoONdatabase_name.table_nameoREVOKE permissionsoONdatabase_name.table_nameo。