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(at)flipper(dot)webdevelop(dot)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.
>