> It works fine on Unix. Is "Aux" a special filename in Windows? Not that i am aware of. Maybe you should try this on Windows. I could be just a problem on windows version. Thanks.
On Sat, 15 Feb 2003, Paul DuBois wrote: > 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 > > --------------------------------------------------------------------- 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