How to echo print statements while executing a sql script

Question

We have a simple sql script which needs to be executed against a MySQL database and we would like print log statements on the progress of the script  e g  Inserted 10 records into foo or Deleted 5 records from bar   How do we do this    I would like to know the syntax to be used for insert update delete statements  How do I know about the number of rows affected by my statement s   I would also like to control printing them using a ECHO off or on command at the top of the script  The script should be portable across Windows   Linux OS

User · Answer

You can use print -p -- in the script to do this example       bin ksh mysql -u username -ppassword -D dbname -ss -n -q   amp  print -p --  select count    from some table   read -p get row count1 print -p --  select count    from some other table   read -p get row count2 print -p exit     echo  get row count1 echo  get row count2   exit

User · Answer

For mysql you can add  p to the commands to have them print out while they run in the script  SELECT COUNT    FROM  mysql   user   p   Run it in the MySQL client  mysql gt  source example sql -------------- SELECT COUNT    FROM  mysql   user  --------------   ----------    COUNT       ----------          24    ----------  1 row in set  0 00 sec

User · Answer

Just to make your script more readable  maybe use this proc   DELIMITER     DROP PROCEDURE IF EXISTS printf  CREATE PROCEDURE printf thetext TEXT  BEGIN    select thetext as       END       DELIMITER     Now you can just do   call printf  Counting products that have missing short description

User · Answer

I don t know if this helps   suppose you want to run a sql script  test sql  from the command line   mysql  lt  test sql   and the contents of test sql is something like   SELECT   FROM information schema SCHEMATA     echo  I like to party        The console will show something like   CATALOG NAME    SCHEMA NAME            DEFAULT CHARACTER SET NAME                def    information schema     utf8          def    mysql                  utf8          def    performance schema     utf8          def    sys                    utf8 I like to party      So you can execute terminal commands inside an sql statement by just using     provided the script is run via a command line       terminal commands

User · Answer

This will give you are simple print within a sql script   select  This is a comment  AS       Alternatively  this will add some dynamic data to your status update if used directly after an update  delete  or insert command   select concat   Updated    row count      rows   as

User · Answer

What about using mysql -v to put mysql client in verbose mode

[mysql] How to echo print statements while executing a sql script

Examples related to mysql

Examples related to sql