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 <suppressed> To unsubscribe, e-mail <suppressed> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.