List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:October 26 2001 2:11pm
Subject:Re: how to run sql script in NT
View as plain text  
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 <mysql-thread89082@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
Chinese - East Asian LanguagesGerd Ruschhaupt26 Oct
  • how to run sql script in NTBarbara Ferrell26 Oct
  • Re: how to run sql script in NTPhilip White26 Oct
  • Re: how to run sql script in NTGerald Clark26 Oct
  • Re: Chinese - East Asian LanguagesJason Wong26 Oct
RE: how to run sql script in NTAndrew Murphy26 Oct