auto_increment problem

we recently upgraded from mysql version 3.23.49 to
3.23.51 (on a solaris 2.8) in the hopes that an
auto_increment problem we were having would go away.
it didn't:
How-To-Repeat: mysql> create table junk (
-> ids numeric (10,0) not null auto_increment);
ERROR 1063: Incorrect column specifier for column
'ids'
this statement worked as long as i took out the
auto_increment. a related problem is that the
last_insert_id function outputs all of the ids for
that column. i'm not sure what is causing the problem
and thought you might have some insight. thanks for
your help.
naomi rosen


__________________________________________________
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12195@lists.mysql.com
To unsubscribe, e-mail

Re: auto_increment problem

Hello Naomi,

Wednesday, July 17, 2002, 11:40:12 AM, you wrote:

NaDS> we recently upgraded from mysql version 3.23.49 to
NaDS> 3.23.51 (on a solaris 2.8) in the hopes that an
NaDS> auto_increment problem we were having would go away.
NaDS> it didn't:
NaDS> How-To-Repeat: mysql> create table junk (
NaDS> -> ids numeric (10,0) not null auto_increment);
NaDS> ERROR 1063: Incorrect column specifier for column
NaDS> 'ids'
NaDS> this statement worked as long as i took out the
NaDS> auto_increment. a related problem is that the
NaDS> last_insert_id function outputs all of the ids for
NaDS> that column. i'm not sure what is causing the problem
NaDS> and thought you might have some insight. thanks for
NaDS> your help.
NaDS> naomi rosen

Yes. This is expected behavior as you should use INT column types for
autoincrement column.


--
For technical support contracts, visit https://order.mysql.com/?ref=mpza
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com M: +7 095 725 4955


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12196@lists.mysql.com
To unsubscribe, e-mail