At 18:10 +0000 2/15/03, Pedro Vasconcelos wrote:
>The NameOfFile.sql contains:
># Table structure for table 'Aux'
>DROP TABLE IF EXISTS Aux;
>CREATE TABLE Aux (
> PrecoBase decimal(40,2) default NULL
># Dumping data for table 'Aux'
>LOCK TABLES Aux WRITE;
>INSERT INTO Aux VALUES
>when i try this command:
> mysql -u USER -p DATABASE <NameOfFile.sql
> (after i insert the password) it blocks.
>I am using 3.23.55 in win2000
It works fine on Unix. Is "Aux" a special filename in Windows?
>On Sat, 15 Feb 2003, Paul DuBois wrote:
>> At 17:44 +0000 2/15/03, Pedro Vasconcelos wrote:
>> >if you have a file NameOfFile.sql where you have a table named Aux and you
>> >try to create it using:
>> > mysql -u USER -p DATABASE <NameOfFile.sql
>> >when it reaches the definition of table Aux, this will block the execution
>> >of the command.
>> I have no problem creating a table named Aux, there's probably something
>> wrong with the statement other than the table name.
> > sql, query