[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
Chris,
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.
http://uk.php.net/mysql_insert_id
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.
Matthias
More information about the thelist
mailing list