new to mysql

[ramsay]

Hello guys ,

I am new to mysql. I have succesfully installed mysql on win2000.

I have the following questions

1) If I have a script say 'test.sql'

test.sql has the follwing code

CREATE TABLE employee_data
(
emp_id int unsigned not null auto_increment primary key,
f_name varchar(20),
l_name varchar(20),
title varchar(30),
age int,
yos int,
salary int,
perks int,
email varchar(60)
);

how do I run this script from mysql> prompt

2) if the script is in a different folder, How do i run is

Thank you
new to mysql

[kidsleep]

I've always run scripts from the bin directory of mysql So I can't answer your second question but as for your first, at the prompt

mysql>source test.sql

try this (again, with the script in the bin dir)

HTH