You don't need to be at the mysql> prompt to run it, just run this from the DOS prompt:
mysql <temp.sql and that will run mysql.exe and read everything from your temp.sql file. ----- Original Message ----- From: "Barbara Ferrell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "barbara" <[EMAIL PROTECTED]> Sent: Friday, October 26, 2001 2:15 PM Subject: how to run sql script in NT > 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 > --------------------------------------------------------------------- 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
