mysql 常用增删改查命定

插入一条记录: 
          mysql> insert into table_name (column_name1,column_name2,.) values (value1,value2,..); 
更新一条记录： 
          mysql> update tbl_name 
set col_name1=expr1 [, col_name2=expr2 ...][WHERE where_definition] 
[ORDER BY ...][LIMIT row_count]; 
删除一条记录： 
         mysql>delete from table_name where id=XX; 
删除整个表的数据： 
         mysql> drop from table_name; 
查询一条记录： 
         mysql>select * from table_name where id=XX;