hi!
The MySQL online manual reports:
...omissis...
shell> mysql database < script.sql > output.tab
If you have problems due to insufficient memory in the client, use
the --quick option! This forces mysql to use mysql_use_result()
rather than mysql_store_result() to retrieve the result set.
Using mysql is very easy. Just start it as follows: mysql database or
mysql --user=user_name --password=your_password database. Type a SQL
statement, end it with `;', `\g', or `\G' and press Enter.
mysql supports the following options:
...omissis...
I need to understand if there where the possibility to do:
[EMAIL PROTECTED] root]# mysql -u root -ppw R500 < INSERT INTO CARTA (date,
time, commessa, barcode) VALUES ("03/07/2003", "14:55:54", "03-0456",
"99TPPEMETALPPC/425")
instead of:
[EMAIL PROTECTED] root]# mysql -u root -ppw R500 < command.sql
where my SQL statement reside inside the script 'command.sql'
Any idea?
thanks in advance!
David
______________________________________________________________________
Yahoo! Mail: 6MB di spazio gratuito, 30MB per i tuoi allegati, l'antivirus, il filtro
Anti-spam
http://it.yahoo.com/mail_it/foot/?http://it.mail.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
