连接SQLyog
如图:
创建一个学生表:
CREATE TABLE `tb_type2` (
`sid` INT(4) ZEROFILL);
USE youran;
INSERT INTO `tb_type2` VALUE(12) ,(1234),(123456);
USE youran;
INSERT INTO `tb_type2` VALUE(12) ,(1234),(123456);
CREATE TABLE student(
studentNo INT(4) PRIMARY KEY COMMENT'学号',
loginPwd VARCHAR(20) NOT NULL COMMENT'密码',
studentName VARCHAR(50) NOT NULL COMMENT'姓名',
sex CHAR(2) DEFAULT'男' COMMENT'性别',
gradeID INT(4) UNSIGNED COMMENT'年级编号',
phone VARCHAR(50) COMMENT