update mysql query from a batch file

Question

Basically my batch file contains:

mysql -u root -pMypassword use myTableDB update myTable set extracted='Y'

but for some syntax error it doesn't update the table. However, when i run through command line:

mysql -u root -pMypassword use myTableDB
mysql update myTable set extracted='Y'

through command line it works. Anyone can point me what syntax error i have on the batch file.

Would that first command work if you typed it into the command line? — SomethingDark
– SomethingDark, Commented Apr 18, 2015 at 0:28
@SomethingDark, it doesn't work and it does not throw any error besides Usage: mysql [OPTIONS] [database] — Carlitos Overflow
– Carlitos Overflow, Commented Apr 18, 2015 at 0:32
Do the two separate commands work when you put them in the batch file? — SomethingDark
– SomethingDark, Commented Apr 18, 2015 at 0:33

RolandoMySQLDBA · Accepted Answer · 2015-04-18 02:52:32Z

3

The cleanest way would be the following:

mysql -u root -pMypassword -DmyTableDB -ANe"update myTable set extracted='Y'"

or if you want the SQL command placed in a variable, you could do this

set sqlstmt=update myTable set extracted='Y'
mysql -u root -pMypassword -DmyTableDB -ANe"%sqlstmt%"

Here is an example i just ran

set sqlstmt=show databases
mysql -u root -pMypassword -DmyTableDB -ANe"%sql%"

and I got this

C:\WINDOWS\system32> set sqlstmt=show databases
C:\WINDOWS\system32> mysql ... -ANe"%sql%"
+--------------------+
| information_schema |
|              mysql |
| performance_schema |
|               test |
+--------------------+

C:\WINDOWS\system32>

answered Apr 18, 2015 at 2:52

RolandoMySQLDBA

44.4k16 gold badges96 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dmitry Eresov · Accepted Answer · 2015-04-18 01:42:20Z

1

mysql client reads SQL commands from STDIN. To do what you want, you would have to do something like the following in your batch file:

echo "update myTable set extracted='Y'" | mysql -u root -pMypassword myTableDB

answered Apr 18, 2015 at 1:42

Dmitry Eresov

1064 bronze badges

Collectives™ on Stack Overflow

update mysql query from a batch file

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related