I have tried to create a MySQL table with the following lines:
$query[] = "CREATE TABLE member (
IDbigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
userName varchar(40) NOT NULL,
.
.
.
RecordCreationTime TIMESTAMP NOT NULL DEFAULT '0',
LastLoginTIMESTAMP NOT NULL
MySQL
Thanks Eric,
I looked forever... and didn't find that in the docs.
I guess the space padding isn't really needed for an ID field.
- Original Message -
From: "Eric Mayers" <[EMAIL PROTECTED]>
To: "John D. Kirkpatrick" <[EMAIL PROTECTE
MySQL Gurus,
I'm trying to figure out what the number after the type means for numbers.
I noticed in someone's code that for the ID field they used bigint(20).
bigint I thought was fixed at 8 bytes. Does this override the size? 20
bytes??? 20 bits?
Thanks
John
---
