mysql 创建数据表

创建表

CREATE TABLE [IF NOT EXISTS]  `tableName`(

id = SMALLINT,

name = VARCHAR(20),

sex = ENUM('男', '女'), 

birth = YEAR,

salary = Float(8,2),

tel = INT,

married = TINYINT(0) , COMMENT '0未婚 其他已婚'

)ENGINE = INNODB CHARSET=UTF8

注 有中文需要提前运行 (mysql 5.6之后不用)

SET NAMES GBK

COMMENT '...'  为注释

#...

-- ....

也是注释

查看表结构

DESC tableName;

DESCRIBE tableName;

SHOW COLUMS FROM tableName;

插入记录  INSERT tableNamevalue|values(...);

查询所有记录 SELECT * FROM tableName;

例子

CREATE TABLE IF NOT EXISTS kaka2(

num1 TINYINT UNSIGNED,

num2 TINYINT,

num3 INT ZEROFILL

);

INSERT kaka2 values(1,-1,1);

SELECT * FROM kaka2;