创建一个表：mysqlgt; CREATE TABLE students (-gt; sno CHAR(10) PRIMARY KEY,-gt; sname CHAR(8) NOT NULL,-gt; ssex CHAR
创建一个表：
mysql> CREATE TABLE students (
-> sno CHAR(10) PRIMARY KEY,
-> sname CHAR(8) NOT NULL,
-> ssex CHAR(1) NOT NULL CHECK(ssex = 'F' OR ssex = 'M'),
-> sage INT NOT NULL,
-> sdept CHAR(20) DEFAULT 'Computer'
-> )
-> ;
MySQl所支持的字符类型：
修改表结构：
mysql> ALTER TABLE students CHANGE sage sage INT UNSIGNED;
mysql> ALTER TABLE students ADD Grade1 INT NOT NULL DEFAULT '1';
删除一个字段：
mysql> ALTER TABLE students DROP Grade1 ;
表重命名：
mysql> ALTER TABLE students RENAME students2;
数据库存储引擎类型：
存储引擎：相当于一个插件，，MySQL跟存储在磁盘上的文件进行交互的接口。
*************************** 1. row ***************************
Engine: InnoDB（行级别锁 粒度比较小）
Support: YES
Comment: Supports transactions, row-level locking, and foreign keys
Transactions: YES
XA: YES
Savepoints: YES
*************************** 2. row ***************************
Engine: MRG_MYISAM
Support: YES
Comment: Collection of identical MyISAM tables
Transactions: NO
XA: NO
Savepoints: NO
*************************** 3. row ***************************
Engine: BLACKHOLE
Simple Groupware 是一个完整的协同工作套件包。它采用PHP,XML,SQL,HTML,CSS和sgsML开发。Simple Groupware与其它同类型系统不同之处在于使用了新的编程语言sgsML。该语言能够实现快速开发Web应用系统。支持MySQL,Oracle和PostgreSQL。
Support: YES
Comment: /dev/null storage engine (anything you write to it disappears)
Transactions: NO
XA: NO
Savepoints: NO
*************************** 4. row ***************************
Engine: CSV
Support: YES
Comment: CSV storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 5. row ***************************
Engine: MEMORY
Support: YES
Comment: Hash based, stored in memory, useful for temporary tables
Transactions: NO
XA: NO
Savepoints: NO
*************************** 6. row ***************************
Engine: FEDERATED
Support: NO
Comment: Federated MySQL storage engine
Transactions: NULL
XA: NULL
Savepoints: NULL
*************************** 7. row ***************************
Engine: ARCHIVE
Support: YES
Comment: Archive storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 8. row ***************************
