I am trying to create a script that will insert data. Right now I am just
using something simple to test this out, but I can't get it to work. Here is
what I have.
mysql --user=root --password= Database_Name;
INSERT INTO table_name (column_name) VALUES (value);
After I run the script, I
Put the full path to mysql in the script...
Jeff
-Original Message-
From: Mike Tuller [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 1:07 PM
To: [EMAIL PROTECTED]
Subject: Shell Script to Insert Data
I am trying to create a script that will insert data. Right
now
The first line starts mysql.
When mysql exits, the second line does nothing, as it is not a valid
shell command.
try :
echo 'INSERT INTO table_name (column_name) VALUES (value)' | mysql
--user=root --password= Database_Name
Or put the second line in a file, and cat the file through a
Mike Tuller wrote:
I am trying to create a script that will insert data. Right now I am just
using something simple to test this out, but I can't get it to work. Here is
what I have.
mysql --user=root --password= Database_Name;
INSERT INTO table_name (column_name) VALUES (value);
After I
PROTECTED]
Subject: Shell Script to Insert Data
I am trying to create a script that will insert data. Right
now I am just using something simple to test this out, but I
can't get it to work. Here is what I have.
mysql --user=root --password= Database_Name;
INSERT INTO table_name