MYSQL中的操纵表

创建表

CREATE TABLE
IF NOT EXISTS member (
    id INT auto_increment,
    NAME CHAR (50) DEFAULT 'noname',
    PRIMARY KEY (id)
) ENGINE = 'MYISAM';

删除表

DROP TABLE member;

修改表

增加列：ALTER TABLE member ADD province CHAR (20);
删除列：ALTER TABLE member DROP COLUMN NAME;

重命名表：

RENAME TABLE member TO man;