Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL with SQLite print message command

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?

like image 219
graciov Avatar asked Feb 28 '16 19:02

graciov


People also ask

What is the use of .dump command SQL?

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.

How view SQLite database from command-line?

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.


1 Answers

SELECT "Your Message";

This Works just fine

like image 116
graciov Avatar answered Sep 27 '22 00:09

graciov