MySQL Tips Archives

How to Query for Not Equal in SQLite

Friday, January 13th, 2012 at 1:39 pm  
Leave your comment

The symbol used in SQLite for not equal is ‘<>’

Consider a sample select query as follows:

Incoming search terms:

  • sqlite not equal
  • anding sqlite queries in ios
  • sqlite not equal to selection query
  • sqlite not equal to
  • sqlite equal select result
  • sqlite equal
  • python sqlite not equal
  • objective c sql select where not equal
  • not eueals in sqllite
  • not equal to sqlite android

PHP function to convert date from MM/DD/YYYY to YYYY-MM-DD

Monday, July 25th, 2011 at 9:07 am  
Leave your comment

//Convert MM/DD/YYYY to YYYY-MM-DD. This format is useful if you want to insert into a MySQL date field.

Incoming search terms:

  • date format conversion in magento from dd/mm/yyyy to yyyy-mm-dd

Executing a query in sqlite3 in xcode

Monday, May 23rd, 2011 at 9:48 am  
Leave your comment

sqlite3_step(statement);

This is the code to execute a query in sqlite3. Here statement is the sqlite3_stmt object, declared as follows
sqlite3_stmt *statement;

Incoming search terms:

  • select sqlite xcode

Preparing a sqlite3 statement to execute in xcode

Monday, May 23rd, 2011 at 9:42 am  
Leave your comment

sqlite3_prepare_v2(database, cString, -1, &statement, nil);

This is the code used to prepare the sqlite3 statement to execute. Here the arguments are as follows

database -> sqlite3 object, declared as       sqlite3 *database;

cString -> const char, obtained by converting the query string to char format.

statement -> sqlite3_stmt object, declared as      sqlite3_stmt *statement;

Incoming search terms:

  • xcode execute sqlite

Getting the string result from a query in sqlite3 xcode

Monday, May 23rd, 2011 at 9:33 am  
Leave your comment

This is the code used to get the string result from a query in sqlite3. Here the obtained result is a char value and we have to convert it to NSString. Here, the first argument is statement, which is the sqlite3_stmt object, declared as follows
sqlite3_stmt *statement;
The second argument is the integer value, which represent the column index from the query.

Getting the integer result from a query in sqlite3 xcode

Monday, May 23rd, 2011 at 9:23 am  
Leave your comment

sqlite3_column_int(statement, 0);

This is the code used to get the integer result from a query in sqlite3. Here the first argument is statement, which is the sqlite3_stmt object, declared as follows

sqlite3_stmt *statement;

The second argument is the integer value, which represent the column index from the query.

 

Getting the last inserted rowid in sqlite3 xcode

Monday, May 23rd, 2011 at 9:01 am  
Leave your comment

sqlite3_last_insert_rowid(database);

This is the code used to get the last inserted rowid in sqlite3. Here database is the sqlite3 object, declared as follows

sqlite3 *database;

Incoming search terms:

  • xcode last insert rowid
  • corona sqlite last_insert_rowid
  • xcode sqlite3_last_insert_rowid

Displaying sqlite3 Error Message in xcode

Monday, April 25th, 2011 at 12:05 pm  
Leave your comment

sqlite3 *database;     // the sqlite3 database object
.
.
.
NSLog( @”Failed from sqlite3_step(statement). Error is:  %s”, sqlite3_errmsg(database) );    // the parameter for the method, sqlite3_errmsg(sqlite3*) is the sqlite3 object, which represents the database.

Incoming search terms:

  • como ver errores sqlite xcode
  • xcode sqlite3_exec errmsg utf8
  • xcode sqlite3_exec
  • xcode sqlite get error codes
  • xcode sqlite error message
  • xcode how to show the sqlite error
  • sqlite3_prepare error xcode
  • sqlite3_prepare error message
  • sqlite xcode error
  • how can i print the error msg of sqlite3

Making a Database Backup using GZip compression.

Thursday, February 17th, 2011 at 11:34 am  
Leave your comment

Backing up your database is very important in a database driven application. Ideally database should be backed up often. There are a lot of ways to accomplish this. I’ll show how to back up database using command-line commands.

The command to run the backup is:

mysqldump -u mysqluser -p mysqldatabase

“mysqldump” program is a tool for creating database backups.

The parameters used are:

“-u” switch means you’re going to specify a username to connect with, which must follow, like “-u mysqluser” above

“-p” switch means you’re either going to immediately specify the password to use (with no space), or it’ll prompt you for one

The final parameter used in the example above is the name of the database to backup

If you run the command above, you would see the contents of your database go scrolling on the screen.

To place the contents of the output into a file, execute the following command

mysqldump -u mysqluser -p mysqldatabase > db_backup.sql

Now you should be able to see a file named “db_backup.sql”, and if you open it you can see a SQL script with the structure and content of your database ready for restoration or migration.

Now compress this SQL script using GZip compression. Instead of gzip, you can use bzip, tar etc..

To add compression into this command, just execute the following command.

mysqldump -u mysqluser -p mysqldatabase | gzip > db_backup.sql.gz

Now your database backup is ready to import/export for future use.

SQLite Commands

Monday, January 31st, 2011 at 2:01 pm  
Comments (1)

Making/Accessing Sqlite database
user@host:~$ sqlite3 test.db

Listing views, tables, and indexes

sqlite> .tables

test testview

sqlite> .tables t%

test

sqlite> .indices test

testindex

Listing schema information

sqlite> .schema test

CREATE TABLE test (ids integer primary key, value text);

CREATE INDEX testindex on test (value);

Seeing SQLite databases

sqlite> .databases

seq name file

— ————— ————————————

0 main /home/user/test.db

1 temp /var/tmp/etilqs_oCUXLLbZO4TjUNI

Exporting data — sqlite

export all of database objects to a file for backup using the SQLite .output and .dump commands.These commands will output all of the data from the database. The first .output line directs any output from now on to the file /tmp/test.sql. The second line .dump will export all of the data in the objects in the database. If the file is already there it will overwrite that file. The last command will set the output back to the screen.

Read the rest of this entry

Incoming search terms:

  • arduino with sqlite
  • javascript sqlite export csv