Syntax error received when trying to source a file from mysql command line

Question

I have a file that is filled with statements that appear like the following:

update table set column1=NULL where column2 in (select id from users where user_id in ('user1','user2'));

As you can see this is correct syntax. When I run this command manually on the mysql command line it works as intended.

However when I attempt to source the file I get syntax errors. Has anyone seen this issue before? I'm looking for a resolution...

mysql> \! source /tmp/update_users.sql
/tmp/update_users.sql: line 2: syntax error near unexpected token `('
/tmp/update_users.sql: line 2: `(select id from users where user_id in ('user1','user2'));'

that other guy · Accepted Answer · 2018-10-11 23:02:09Z

3

You have to use the MySQL source command:

mysql> source /tmp/update_users.sql

When you use \!, you instead invoke a shell command. The shell source command expects a shell script, not a sql file.

answered Oct 11, 2018 at 23:02

that other guy

125k12 gold badges187 silver badges214 bronze badges

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

1 Comment

user3299633 Over a year ago

Aye! I had a brain fart LOL -- thanks for the quick response!

Collectives™ on Stack Overflow

Syntax error received when trying to source a file from mysql command line

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related