Ok :) You are absolutely correct. My mistake :) Bye On Sat, 15 Feb 2003, Jocelyn Fournier wrote:
> Hi, > > AFAIK, Aux is indeed a special filename in Windows (if I execute Aux under > the W2K console, it opens the "open with" window). > > Regards, > Jocelyn > ----- Original Message ----- > From: "Pedro Vasconcelos" <[EMAIL PROTECTED]> > To: "Paul DuBois" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Saturday, February 15, 2003 6:20 PM > Subject: Re: Report a bug > > > > > 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 > > > > > > --------------------------------------------------------------------- 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