test3.sql

SET @name_test='Sam Smith';
SELECT * FROM student WHERE  name=@name_test;
source test4.sql;

test4.sql

SELECT test FROM student WHERE  name=@name_test;

test5.sql

create table student_athlete as select * from student a,athlete b  where b.this_student=a.student_id;
alter table student_athlete drop this_student;
alter table student_athlete add primary key (student_id);
alter table student_athlete modify student_id int NOT NULL AUTO_INCREMENT;