I see that the auto_increment keyword is not supported by SQLite:
addressid bigint(20) unsigned NOT NULL auto_increment,
.
.
.
PRIMARY KEY (addressid)I understand that I have to move the 'unsigned' keyword (before 'bigint') but I do not know how to get the auto_increment semantic under SQLite.
I found in the 'Datatypes in SQLite' manual page (in Section 2.0) the comment:
"INTEGER PRIMARY KEY columns can be used to implement the
equivalent of AUTOINCREMENT."Is the following the proper re-write to get the precise semantic I am seeking?
addressid INTEGER PRIMARY KEY NOT NULL
Can I then omit the subsequent "PRIMARY KEY (addressid)" line?
Is "NOT NULL" no longer needed?
Can someone recommend a good SQL book (I am not a DB guy)? There are so many out there and I'd like to purchase just one, so I need to get it right the first time. I found on-line manuals by DB engine providers - eg, http://www.mysql.com/doc/en/SQL_Syntax.html - but I do not know when I may be looking at specialized extentions (eg, mySQL's REGEXP and auto_increment keywords). I'd like to have my own reference.
Tia,
- rich
-- rich coco [EMAIL PROTECTED] 781.736.1200 x165 Starbak Inc. 29 Sawyer Rd. Waltham, MA 02453
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
