作者:LAMP小白 点击:2032 发布日期:2012-10-24 22:15:00 返回列表
查看某个表的信息
mysql> SHOW CREATE TABLE studentG
*************************** 1. row ***************************
Table: student
Create Table: CREATE TABLE `student` (
`name` varchar(20) NOT NULL,
`sex` enum('F','M') NOT NULL,
`student_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`student_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
改变某个字段
mysql> ALTER TABLE student MODIFY name char(20);
Query OK, 5 rows affected (0.07 sec)
Records: 5 Duplicates: 0 Warnings: 0
mysql> ALTER TABLE student CHANGE name user_name char(20);
Query OK, 5 rows affected (0.02 sec)
Records: 5 Duplicates: 0 Warnings: 0
改变使用的引擎
mysql> ALTER TABLE student ENGINE = InnoDB;
Query OK, 5 rows affected (0.02 sec)
Records: 5 Duplicates: 0 Warnings: 0
重命名表
mysql> ALTER TABLE student RENAME TO student_a;
Query OK, 0 rows affected (0.01 sec)
交换两张表的名字
mysql> RENAME TABLE member TO temp, student_a TO member, temp TO student;
Query OK, 0 rows affected (0.01 sec)
上一篇:算法分析笔记 下一篇:快递查询API