MySQL SQL CODE

1、创建表时增加表及表字段的说明信息:

CREATE TABLE STUDENT (
	STU_ID			BIGINT(20) primary key COMMENT '主键',
	STU_NAME		varchar(50) COMMENT '学生姓名',
	STU_PASSWORD	varchar(50) COMMENT '学生密码'
) COMMENT '学生表';

2、插入语句:

INSERT INTO 
	STUDENT (STU_ID,STU_NAME,STU_PASSWORD) 
	VALUES(1,'liaki','likai1118');