��곗�댄�� 踰���댁�� 由ы�ы��

create database college; college��쇰�� ��곗�댄�� 踰���댁�� 留����.
use college ;
show tables ; table��� 蹂댁�ъ��.
create table student <===������ �����대��
(snum int(10) not null,
sname char(15),
major char(20),
level char(2),
age int(2),
primary key(snum));
create table class <====諛� �����대��
(cname char(7) not null,
room char(5),
fid int(5),
primary key(cname));
create table enrolled <===enrolled �����대��
(snum int(10) not null,
cname char(7),
primary key(snum));
create table faculty <===faculty �����대��
(fid int(5) not null,
fname char(10),
deptid int(5),
primary key(fid));
LOAD DATA LOCAL INFILE `student_file.sql` INTO TABLE student; <=student.Sql �����대�� 媛�媛� �����고�곕�� ������
LOAD DATA LOCAL INFILE `class_file.sql` INTO TABLE class;<=class.Sql �����대�� 媛�媛� �����고�곕�� ������
LOAD DATA LOCAL INFILE `enrolled_file.sql` INTO TABLE enrolled;<=enrolled.Sql �����대�� 媛�媛� �����고�곕�� ������
LOAD DA���(������)