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