Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how do I print newline in sqlite3

Tags:

sqlite

I am learning sqlite3. I wanna insert a separator between two tables, how do I do this?

-- show Table [exam]                                                                                
SELECT * from exam;   

-- here I wanna print a newline as separator
-- how to do this?

-- show Table [examlog]                                                                             
SELECT * from examlog; 
like image 432
CCC Avatar asked Dec 08 '11 05:12

CCC


2 Answers

If it's still of any use:

.print '' 

will print a new line in the output.

like image 160
Nico Esk Avatar answered Oct 14 '22 00:10

Nico Esk


Try

select '';

on a line by itself.

like image 22
Thilo Avatar answered Oct 14 '22 01:10

Thilo