# unload a table into a file

SELECT * 
    from student
    where student_id < 10
    into outfile '/home/sultans/web/sql/demo/8other_mysql/output/student.file' 
    fields terminated by ',' optionally enclosed by '\''