9/10 mysql

-- database 생성
create database sampledb;

 

-- database선택
use sampledb;

 

-- table생성
create table student(
id char(7) primary key,
name varchar(10) not null,
dept varchar(20) not null
);

 

-- 데이터입력
insert into student values('1091011','김철수','컴퓨터시스템');
insert into student values('0792012','최고봉','멀티미디어');
insert into student values('0494013','이기자','컴퓨터공학');

 

-- 조회
select * from student;