create DB & TABLE in Mysql

 

1. 数据库

show databases;

use DB_NAME;

create database DB_NAME;

 

2. 表

show tables;

create table  TABLE_NAME ; //清单2

describe TABLE_NAME ;

select * from TABLE_NAME ;

insert into TABLE_NAME  values (’xxx’,’xxx’,’xxx’,’xxx’);

delete from TABLE_NAME ;

1: -- create database `abc_db`; 2:  3: DROP TABLE IF EXISTS `abc_table`; 4: CREATE TABLE `abc_table` ( 5: `ID` bigint(20) NOT NULL auto_increment, -- 主键 6: `TOPIC` varchar(32) NOT NULL, 7: `GROUP_ID` varchar(64) NOT NULL, 8: `MD5` varchar(4000) default NULL 9: PRIMARY KEY (`ID`) 10: ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

关于ENGINE=InnoDB，请参看这里：

http://dev.mysql.com/doc/refman/5.1/zh/storage-engines.html

 

3. 索引

show index from TABLE_NAME ;

show keys from TABLE_NAME ;

create index INDEX_NAME on TABLE_NAME (COLUMN1, COLUMN3,…);

drop index INDEX_NAME on TABLE_NAME;

alter table TABLE_NAME add index INDEX_NAME (COLUMN1, COLUMN3,…);

alter table TABLE_NAME drop index INDEX_NAME;

 

参考：

http://www.chinaz.com/program/2010/0119/104365.shtml

http://hi.baidu.com/pibuchou/blog/item/268adc33a36ab294a8018e75.html

http://happyman-bruce.blogbus.com/logs/1740464.html

 

 

4. 其它

show processlist;

show grants for USER_NAME;