SQLite database creating through script

Question

There is the following script:

CREATE TABLE IF NOT EXISTS `location_cities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_region_id` int(11) NOT NULL DEFAULT '0',
  `location_district_id` int(11) DEFAULT NULL,
  `location_country_id` int(11) NOT NULL DEFAULT '0',
  `lon` float(11,8) NOT NULL DEFAULT '0.00000000',
  `lat` float(11,8) NOT NULL DEFAULT '0.00000000',
  `prefix` varchar(50) DEFAULT NULL,
  `name` varchar(128) NOT NULL,
  `size` int(3) NOT NULL DEFAULT '0' COMMENT 'Размер города',
  `tz_name` varchar(128) DEFAULT NULL,
  `timezone` varchar(100) NOT NULL DEFAULT '+00:00',
  `timezone2` varchar(100) NOT NULL DEFAULT '+00:00',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12393 ;

When I try to execute it using 'sqlite3 db/development.sqlite3 < alogist.sql' I got error 'Error: near line 27: near "AUTO_INCREMENT": syntax error' (27 - the line with "CREATE_TABLE ...". So, what's the trouble? How can I fix it? Thanks!

It's AUTOINCREMENT not 'AUTO_INCREMENT' . In SQLLite no AUTO_INCREMENT is there. — Janny
– Janny, Commented Sep 22, 2014 at 8:57

laalto · Accepted Answer · 2014-09-22 08:57:49Z

1

In sqlite, an autoincrement column is specified as

INTEGER PRIMARY KEY AUTOINCREMENT

Replace your int(11) NOT NULL AUTO_INCREMENT with that.

Further problems:

COMMENT is not supported. Remove COMMENT 'Размер города'
Remove PRIMARY KEY (ID) - the primary key has already been specified.
Remove the MySQL-specific ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12393.

answered Sep 22, 2014 at 8:57

laalto

153k68 gold badges293 silver badges306 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mikhail Timofeev · Accepted Answer · 2014-09-22 08:58:27Z

0

SQLite syntax:

 `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL

answered Sep 22, 2014 at 8:58

Mikhail Timofeev

2,16916 silver badges13 bronze badges

Collectives™ on Stack Overflow

SQLite database creating through script

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related