I had looked everywhere to find the answer to this question. Now that I look at the FAQ again I see it in there. I tryed searching the FAQ for "auto increment" when it turns out to be "auto-increment" on the FAQs page. Being a MySQL user who was dead ended and had no choice but to find a new database with Transactions or something simliar because of MySQL's limitations I had several questions that seemed difficult to find during the switchover. 1. Auto increment - now serial datatype 2. 'SHOW TABLES' in mysql - now '\d' (I got lucky to stumble apon this.) 3. 'DESCRIBE' in mysql - now '\d tablename' (same as above.) As more people realize MySQL's limitations I think there will be more people making the switchover. As a result I'm sure many people find themselves asking the same questions I did. I would recommend these 3 things be easy to find the the FAQ for MySQL familiar users. My 2 cents... On Tue, 26 Dec 2000, Brett W. McCoy wrote: > On Tue, 26 Dec 2000 [EMAIL PROTECTED] wrote: > > > Is there a way set a primary key to Auto Increment like you can > > with MySQL? > > See the documentation on CREATE SEQUENCE, and also on CREATE TABLE and the > SERIAL type. > > [An aside: this is something definitely that qualifies as a frequently > asked question, as this is like the 4th time in a week this question has > been asked. Would posting a FAQ list on a regular basis to the list be > helpful for things like this, like is done on the Perl newsgroups?] > > -- Brett > http://www.chapelperilous.net/~bmccoy/ > --------------------------------------------------------------------------- > Hanson's Treatment of Time: > There are never enough hours in a day, but always too many days > before Saturday. >
