Create sqlite3 database at prompt

Posted by user15432 on Stack Overflow See other posts from Stack Overflow or by user15432
Published on 2010-05-05T06:19:26Z Indexed on 2010/05/05 6:28 UTC
Read the original article Hit count: 254

Filed under:

sqlite3

I tried using the following commands to create a database file at prompt, but none of them would work.

$ sqlite3 test.db
sqlite3 test.db
test.db

does it require a semi-colon at the end or is it that hard to create a database file using sqlite3 prompt?

Related posts about sqlite3

ruby1.9.1 - sqlite3 problem on ubuntu 9.10 x64 (no such file to load -- sqlite3)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have problem with sqlite3, because it is not working. irb(main):001:0> require 'sqlite3' LoadError: no such file to load -- sqlite3 from (irb):1:in `require' from (irb):1 from /usr/bin/irb:12:in `<main>' I have installed following packages: sudo apt-get install ruby1… >>> More
python sqlite3 won't execute a join, but sqlite3 alone will

as seen on Stack Overflow - Search for 'Stack Overflow'
Using the sqlite3 standard library in python 2.6.4, the following query works fine on sqlite3 command line: select segmentid, node_t, start, number,title from ((segments inner join position using (segmentid)) left outer join titles using (legid, segmentid)) left outer join numbers… >>> More
Snow Leopard upgrade -> reinstalling sqlite3-ruby gem problem

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I got ruby 1.8.7 (native compiled), rails 2.3.4, OSX 10.6.2 and also sqlite3-ruby. The error I'm getting when accessing the rails app is NameError: uninitialized constant SQLite3::Driver::Native::Driver::API History: I upgraded to snow leopard by migrating my apps with a FW-cable from… >>> More
Compile PHP Error with freetype

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey Guys, I configured PHP myself, included all of the libraries I needed... but then realized I forgot the freetype library. So I went back to my php-5.3.2 directory and ran ./configure '--with-free-type=/usr/local/lib' PHP did the configure fine, no errors. But when I run make: collect2: ld… >>> More
how to enable sqlite3 for php?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am trying to install sqlite3 for php in ubuntu. I install apt-get php5-sqlite3 and edited php.ini to include sqlite3 extension. When I run phpinfo(); I get SQLITE3 SQLite3 support enabled sqlite3 library version 3.4.2 as shown above, sqlite3 is enabled. However, I get "Class SQLite3… >>> More

Developer IT

Create sqlite3 database at prompt - Developer IT

Create sqlite3 database at prompt

sqlite3

Related posts about sqlite3

ruby1.9.1 - sqlite3 problem on ubuntu 9.10 x64 (no such file to load -- sqlite3)

python sqlite3 won't execute a join, but sqlite3 alone will

Snow Leopard upgrade -> reinstalling sqlite3-ruby gem problem

Compile PHP Error with freetype

how to enable sqlite3 for php?

Categories cloud