create new sqlite Db

Posted by idober on Stack Overflow See other posts from Stack Overflow or by idober
Published on 2010-04-13T13:22:08Z Indexed on 2010/04/13 13:22 UTC
Read the original article Hit count: 253

Filed under:

sqlite3

I am working on Mac os X.

I want to create a new sqllite DB.

I am using http://www.sqlite.org/quickstart.html as a refernce:

I am entering: sqlite3 test.db

and getting the response:

SQLite version 3.6.12 Enter ".help" for instructions Enter SQL statements terminated with a ";"

why is this happening?

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 new sqlite Db - Developer IT

create new sqlite Db

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