创建表
CREATE TABLE [IF NOT EXISTS]
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 tableName value|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;