sql statement

sql

drop database if exists school;
create database school;
use school;
drop table if exists student;
create table student(
    sno int unsigned not null auto_increment primary key,
    name varchar(127) not null,
    major varchar(1024) not null,
    unique key unique_name (name)
)engine=InnoDB auto_increment=10000 default charset=utf8;

insert into student(name, major) value('aaa', 'computer');
insert into student(name, major) value('bbb', 'history');
insert into student(name, major) value('ccc', 'english');
insert into student(name, major) value('ddd', 'chinese');
insert into student(name, major) value('eee', 'biology');
insert into student(name, major) value('fff', 'operation');
insert into student(name, major) value('ggg', 'designer');

表结构

MySQL [school]> desc student;
+-------+------------------+------+-----+---------+----------------+
| Field | Type             | Null | Key | Default | Extra          |
+-------+------------------+------+-----+---------+----------------+
| sno   | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| name  | varchar(127)     | NO   | UNI | NULL    |                |
| major | varchar(1024)    | NO   |     | NULL    |                |
+-------+------------------+------+-----+---------+----------------+

转载于:https://my.oschina.net/u/3669947/blog/2873502