Wednesday 4 November 2020

How to echo print statements while executing a sql script

 

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 ''; 

No comments:

Post a Comment

Note: only a member of this blog may post a comment.

Blog Archive