SQLite Tutorial

This video shows a user how to take SQLite for a first spin using the command-line tool. It shows how to get in, get out, and use some basic SQL commands with SQLite.

For more information on SQLite, see

http://www.squidoo.com/sqlitehammer
http://www.squidoo.com/sqliteprogramming
http://www.squidoo.com/sqlitetutorial
http://www.squidoo.com/sqlitedatabasedesign

Category:

Science & Technology

Tags:

• SQLite Tutorial
• Tutorial SQL
• sqllite tutorial

[nextblain]

sqllite exact same as mysql command line?

[Jaynonymous1]

@nextblain - The SQL is very close. The built-in functions are different. Same name, different effect in few cases, same effect, different name in other cases. The "dot" commands (e.g. .quit, .schema, etc) are not there in the MySQL command line as far as I know.

[tarunpai]

how to install sqlite3?

[Jaynonymous1]

@tarunpai On Ubuntu, it is "sudo apt-get install sqlite3" or "sudo apt-get install sqlite". On windows, go to the sqlite download page, get the zip file for the sqlite shell, unzip it, and copy the utility to your windows system32 folder.

[eMGeeGFX]

If anyone wants to try out SQLite, it's available on the "Deathrow" remote access OpenVMS cluster.

You only need to define the following foreign DCL command and you're ready to go:

"$ SQLITE :== $DISK$USERS:[USERS.PAPO.BIN]SQ­LITE.EXE"

[Jaynonymous1]

@eMGeeGFX So does SQLite work on VAX/VMS?

[MegumiQL]

Thank you very much for this tutorial; helped me a lot.

[eMGeeGFX]

@Jaynonymous1, the GEIN:: system at "Deathrow" (currently available in the cluster) is an Alpha processor-based node. Or, did you mean if besides an Alpha port there's a VAX port as well? I haven't seen any of the latter, but I could probably build you a port most likely. (So you could use it on FAFNER:: or any other public access VAX node, or inside an emulator.)

[gilgomesp]

Very good, you was simple and efficient like @doubl3dge said.

[atma]

Thanks that was quite enlightening :-)