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"
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.
Us
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 ar
Hello everyone..
I know that you can write the sql scripts into a text file and redirect it
to the mysql from command line.. Is there any way to add shell/system
commands to automate process? PArticularly, I am looking for a way to echo
files and put them in a blob column.
I am also wondering
