Difference between revisions of "Sqlite"

From Linuxintro
imported>ThorstenStaerk
imported>ThorstenStaerk
 
Line 13: Line 13:
 
= See also =
 
= See also =
 
* [[mysql]]
 
* [[mysql]]
 +
* [[Migrating a database from mysql to sqlite]]

Latest revision as of 12:41, 7 September 2013

Here is an example how to work with sqlite:

# sqlite roundcubemail
SQLite version 2.8.17
Enter ".help" for instructions
sqlite> .databases
seq  name             file                                                      
---  ---------------  ----------------------------------------------------------
0    main             /var/www/roundcube/roundcubemail                          
1    temp             /var/tmp/sqlite_fWDjMUYco0dIRgS 

See also