create database sampledb;

use sampledb;

create table student
(
     name varchar(20) not null, -- 이름
    dept varchar(20) not null, -- 학과
    id char(10) primary key not null -- 학번, 기본키
);

insert into student values('최규식', '스마트컨텐츠개발', '2014071023');
insert into student values('박태수', '스마트컨텐츠기획', '2014072008');
insert into student values('정상혁', '스마트컨텐츠마케팅', '2014071020');

select * from student order by name asc;