mysql command-line question...

2003-07-04 Thread Davide Monge
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.

Re: mysql command-line question...

2003-07-04 Thread Paul Chvostek
On Fri, Jul 04, 2003 at 02:27:18PM +0200, Davide Monge wrote: 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

Re: command line question..

2001-12-05 Thread Denis A. Rudakov
Hello ! I often use that common scheme to parametrize my queries. #!/bin/bash #check parameters most commonly (only number of parameters) if [ $# !=NUMBER_OF_PARAMETERS_NEEDED ]; then echo Too few parameters;exit 1; fi # these are queries in my transactional procedure # $1...$N are