🖥️ MySQL Database
Sign in
🖥️

MySQL Database


MySQL Database


How to execute a MySQL command from a batch-file?

Please note that this is not a preferable way because the username and password are in plain text visible. 

Clipboard

@echo_off

SET un=myusername

SET pw=mypassword

SET db=mydatabase


"G:\MySQL\MySQL Server 5.1\bin\mysql.exe" -u%un% -p%pw% %db% -Bse "UPDATE arcsignal SET type='ENUM', c_type='0001' WHERE unr=2 AND signalname IN (SELECT signalname FROM enumdata WHERE unr=2 GROUP BY signalname)"