great 10x for looking into it.And thank you for the great utilities that you have made.

BR
Martin

The answer lies in the strange output you got from your `SHOW CREATE TABLE`. How is it possible you have `AUTO_INCREMENT=18446744073709551615` for an INT column? There is nothing the query can do about this: I suggest reporting this as a bug to MySQL.

10x for the fast response.Here is the requested information:

mysql> show create table ussd_ubrowser.ubrowser_phone_producers \G;
*************************** 1. row ***************************
Table: ubrowser_phone_producers
Create Table: CREATE TABLE `ubrowser_phone_producers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`ordClmn` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18446744073709551615 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql> show table status from ussd_ubrowser like 'ubrowser_phone_producers' \G;
*************************** 1. row ***************************
Name: ubrowser_phone_producers
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 6
Avg_row_length: 21
Data_length: 128
Max_data_length: 281474976710655
Index_length: 2048
Data_free: 0
Auto_increment: 18446744073709551615
Create_time: 2013-02-22 20:42:54
Update_time: 2013-02-22 20:42:54
Check_time: 2015-11-27 14:57:07
Collation: latin1_swedish_ci
Checksum: NULL
Create_options:
Comment:
1 row in set (0.01 sec)


Thanks!

| ussd_ubrowser | ubrowser_phone_producers | id | int | int(11) | 0 | 2147483647 | 18446744073709551615 | 8589934596.0000 |

How is that possible,the Signed int to have more than 2147483647 and the output in AUTO_INCREMENT_RATIO is as seen above 8589934596.The version of MySQL that I use is quite old:

5.1.73 64Bit

BR
Martin