# Load a table from a file

DROP   TABLE student2;
CREATE TABLE student2
(
	student_id INT           NOT NULL,
	lname      VARCHAR(20)   NOT NULL,
	fname      VARCHAR(20)   NOT NULL,
	ssn        CHAR(11)      NOT NULL,
	sex        ENUM('F','M') NOT NULL
);


LOAD data infile '/home/sultans/web/sql/demo/8other_mysql/output/student.file' replace
    into table student2
    fields terminated by ',' optionally enclosed by '\'';


SELECT * from student2;