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 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=xxxxxxxx Database_Name; > INSERT INTO table_name (column_name) VALUES ("value"); > > After I run the script, I check the data, and nothing was > entered. When I run each statement on it's own (not from a > script file, but in the shell) Everything seems to work. It > just doesn't work when you try to run it from a script. > > Any ideas? > > Mike Tuller > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
