创建mysql 数据库，表

CREATE DATABASE sqlstudent;

use sqlstudent;

CREATE TABLE student(

studentNo INT (4) Not NULL COMMENT'学号' PRIMARY KEY,

loginpwd VARCHAR(20) NOT NULL COMMENT'密码',

studentName VARCHAR(50) NOT NULL COMMENT'学生姓名',

sex CHAR(2) DEFAULT '男' NOT NULL COMMENT'性别'

)COMMENT ="学生表";