Dennis Gearon wrote:
> Please CC me, I am on digest.
>
> What is an int(11) as in the following table creation statement? I
> looked online at the documentation, and not only is the documentation
> MUCH different than the last time I looked at it, (been awhile), but I
> didn't see anything related to a parameter to the size of an int field
> that looked like 11.
>
> BTW, why does the make of the definition below have backtick quotes on
> all names?
>
> CREATE TABLE calendar_events` (
> `eventID` int(11) NOT NULL auto_increment,
> `eventTitle` varchar(20) default NULL,
> `eventMessage` varchar(200) default NULL,
> `eventTime` time default NULL,
> `eventDate` date default NULL,
> PRIMARY KEY (`eventID`)
> ) TYPE=MyISAM;
As far as I know, the number in brackets eg int(11) is only used for
numeric fields when you are importing from a fixed-width text file, with
'load data infile'. In this case, the width of the fields is taken from
the number in brackets from the table definition. Pretty strange stuff
if you ask me. Anyway you can safely ignore it if you're not importing
data from a fixed-width file. For more info see 'load data infile'.
The backticks are there to aid MySQL in parsing the string later in case
you have used reserved words or strange characters.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@stripped
website: http://www.nusconsulting.com.au
