Re: Auto Increment

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 postgres@flipper.webdevelop.net 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.
>