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 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