MySQL command line run script twice

Question

I'm trying to run a script with MySQL on Windows like this :

mysql.exe -h 127.0.0.1  databaseName -uroot < path\to\my\script.sql

On my script I do some stuff like this

select 'start'; 

select 'import';
SOURCE import some other sql with functions and procedures

select 'run';
some stuff

select 'end';

And when I'm looking for logs I found this :

start
start
import
import
run
run
end
end

Did you know why MySQL is doing this ?

what logs do you check? what command do you use to output to log? provide script.sql — Alex
– Alex, Commented Apr 5, 2017 at 13:12
when I say logs, I'm means all select statement on the script I can see on the standard output — User42
– User42, Commented Apr 5, 2017 at 13:14
so if your script contain just 1 line select 'start'; are you still getting it twice? seem like sqlfiddle.com/#!9/9eecb7d/98044 mysql is outputting column title and values. so to check this theory you can try select 'start' as my_command; You'll see the difference ;-) — Alex
– Alex, Commented Apr 5, 2017 at 13:17

Alex · Accepted Answer · 2017-04-05 13:41:05Z

1

Seem like

mysql is outputting column title and values.

select 'start' as my_command;

or

select 'start' as step;

You'll see the difference ;-)

answered Apr 5, 2017 at 13:41

Alex

17.3k1 gold badge31 silver badges52 bronze badges

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

1 Answer 1