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
>) TYPE=MyISAM;
>
>#
># Dumping data for table 'Aux'
>#
>
>LOCK TABLES Aux WRITE;
>INSERT INTO Aux VALUES
>(100.00),(100.11),(100.00),(100.22),(101.00),(102.00);
>UNLOCK TABLES;
>
>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
