I'm confused. You say you are at a dos prompt, but you show a mysql prompt.
At the dos prompt do: mysql < temp.sql At the mysql prompt: source temp.sql Barbara Ferrell wrote: > i am extremely new at this: > > i am on NT4.0 > > i am in a DOS screen at the mysql prompt (mysql>) > the path that is described in the top of the window is: =3D > c:\apache\mysql\bin\mysql.exe > > > i wrote a script to create and load a database exactly as it said in the = > =3D > book.. i saved the file as ..Temp.sql > > then i typed: > mysql> temp.sql ; at the mysql prompt > > it doesn't recognize the .sql file... how do I get it to run? > > > > the temp.sql file has this in it: > > create database temp ; > USE DATABASE Temp; > CREATE TABLE Test_Table > (Test_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT, > Test_Name VARCHAR(30), > Test_Date DATETIME, > Test_Giver VARCHAR(30)); > INSERT INTO Test_Table > (Test_ID, Test_Name, Test_Date, Test_Giver) > VALUES > (null, 'Test', '2000-01-01', 'barb'); > > > > > > > > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php