Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: DBI SQLite

by Plankton (Priest)
on Nov 11, 2011 at 06:10 UTC ( #937528=note: print w/ replies, xml ) Need Help??


in reply to DBI SQLite

To rule out any problems with you Perl code you could use sqlite3 from the command-line to verify your SQLite data file. For example you could do this to see what tables are available in your SQLite database:

plankton@chumbucket:~$ sqlite3 mysqlitedb SQLite version 3.7.4 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .dump PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE tbl1 (one varchat(10), two smallint); INSERT INTO "tbl1" VALUES('hello',10); COMMIT; sqlite> .tables tbl1 sqlite> .exit
You can find out more about SQLite command line shell here: http://www.sqlite.org/sqlite.html


Comment on Re: DBI SQLite
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://937528]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (8)
As of 2015-07-03 21:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (56 votes), past polls