mysql updating table problem

[Anon]

Ok iam testing updateing my tables through command line I am running mysql you off of XP as a test... here is the command line I am using

c:\mysql\bin\mysql.exe -u root --execute= < "C:\sqlloginput.txt" > "C:\sqllogoutput.txt"

and when I run that I get no errors, but it does nothing to the tables here is what is in sqlloginput.txt

USE gamesnet;
INSERT INTO script VALUES (....
exit

any help would be apreciated

[Anon]

First you say your trying to UPDATE a table... Then your script shows me that you want to INSERT a new entry. I don't know much about Command Line like that nor why it would even be worth your time. I usually use the mysql> prompt and go to it. Or use an external page .PHP to insert tables. But hey man whatever floats your boat. You might also want to try saving as .php and not .txt. Though remember I know nothing about command line scripting like what your doing. Mine would be something like:

USE gamesnet;
Update script SET matt='Smart',Chad='Retarted';
exit;

Chad

[Anon]

I must have phrased it wrong, I meant im adding to the table, and the reason I use command line is cause ever 5 minutes it executes that command line, adds eveything from input into the table, then it erases the input and waits for the next 5 minutes.

Thats why I use commandline, because it is automated, and does this every 5 minutes

so I do the -e or --execute=

and then in the file:
USE database
insert into table,....
exit