I'm new to objective c. I'm trying to create database for first time in my mac i did following steps
******100$ sqlite3 test.sql
SQLite version 3.7.5
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
But wen i enter .schema I'm getting following error
sqlite> .schema
Error: unable to open database "test.sql": unable to open database file
And same error if i go to create a teble
You can use Firefox addon SQLite Manager to create database.
Try something like this:
$ sqlite3 test.sql
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> CREATE TABLE test (a_int INTEGER, a_real REAL, a_text TEXT);
sqlite> .schema
CREATE TABLE test (a_int INTEGER, a_real REAL, a_text TEXT);
sqlite> INSERT INTO test (a_int, a_real, a_text) VALUES (1, 1.24, 'hello world');
sqlite> SELECT * from test;
1|1.24|hello world
sqlite>
(this was from Linux, but it should be the same...)
BTW the file extension .sql is wrong; that is used for a file containing SQL statements. Use .db instead.
test.sql file doesn't exist? (as I said in my answer, .sql is used for a different thing than a database file).Check this link for Create database, create table insert into table .
test.sqland you are attempting to open it as a database using thesqlite3command line tool...