dimanche 7 juin 2015

How to create new table in SQLlite

I have converted a mdb database to sql (using some programm), but Im having errors while using it. the first line on it is:

CREATE DATABASE IF NOT EXISTS `movedb`;
USE `movedb`; 

is it ok? mozilla sql managers cant read it.. the error:

SQLiteManager: CREATE DATABASE IF NOT EXISTS movedb; [ near "DATABASE": syntax error ]

Exception Name: NS_ERROR_FAILURE

Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]

Aucun commentaire:

Enregistrer un commentaire