I need to print a message between query results, but i can't find an appropriate SQL command that works with SQLite. For example if I have 2 tables, BRANCH
and STAFF
, and I need to return it's contents, i want the output to be like
BRANCH data ------------
*table content here*
STAFF data -------------
* table content here*
How do I print BRANCH data -----
message?
Mysqldump is a command-line utility that is used to generate the logical backup of the MySQL database. It produces the SQL Statements that can be used to recreate the database objects and data. The command can also be used to generate the output in the XML, delimited text, or CSV format.
Open a command prompt (cmd.exe) and 'cd' to the folder location of the SQL_SAFI. sqlite database file. run the command 'sqlite3' This should open the SQLite shell and present a screen similar to that below.
SELECT "Your Message";
This Works just fine
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With