[thelist] Re: Trying to create table in MySQL DB with phpmyadmin

Matthias Willerich matthias at die-legendaeren.de
Tue Sep 6 01:23:13 CDT 2005


You shouldn't use BIGINT for the id, at least not if you're using
mysql_insert_id() in the php, as this might return the wrong number.

INT( 255 ) would probably be the next biggest candidate. When you get errors
while creating a table, it's usually down to using a keyword(which you can
escape) or to not putting in a value for the size of the field. Not all
fields want one, but hey, most do, and it makes you think about the needed
dimensions as well.


More information about the thelist mailing list