A liitle help, passing parameters to MySQL, a quickie!

cmc12

Hi,

I want to open MqSQL and run a command using a DOS batch script like this, it runs but doesn't update dB. any ideas is the command line tag -e correct?

mysql -e "USE <database name" -e "INSERT INTO ,table VALUES('xxx','xxxx','xxx','xxx','xxx','xxx');"

Thanks

cmc12

its okay thanks... should be

mysql <database name -e "INSERT INTO ,table VALUES('xxx','xxxx','xxx','xxx','xxx','xxx');"

Quote:

Originally Posted by cmc12

Hi,

I want to open MqSQL and run a command using a DOS batch script like this, it runs but doesn't update dB. any ideas is the command line tag -e correct?

mysql -e "USE <database name" -e "INSERT INTO ,table VALUES('xxx','xxxx','xxx','xxx','xxx','xxx');"

Thanks

A liitle help, passing parameters to MySQL, a quickie!

re: A liitle help, passing parameters to MySQL, a quickie!

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about