常用语句

 

alter table tablename modify columnname integer unsigned not null auto_increment primary key;
alter table tablename add column colname columntype after column;
alter table news add column ID int(11) first;加为第一列

show variables like character_set_%;
show variables like collation_%;

set names charset;
set character_set_database=gbk;

show databases;
show tables;
describe tablename;
show create database databasename;
show create table tablename;
show full columns from tablename/G;

mysqldump -u -p -h --options databasename>*.sql;
mysql -u -p -h --options databasename<*.sql;
load data local infile 'c:/wanghuida.txt' into table tablename lines terminated by '/r/n';