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]