definition of mysql db- correct or incorrect

[woods]

Hi

Is this a wrong definition of a mysql db? (no defaults defined) :

`date1` int(10) default NULL,
`date2` int(10) default NULL,
`num_jokes` int(8) unsigned NOT NULL,
`title` varchar(255) NOT NULL,
`path` text NOT NULL,
etc...
etc...

Thanks and bye -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[naughtyboy]

did you mean table? because a table is different from a database

i think what you're looking at is phpmyadmin output, and it has this nasty habit of writing default NULL when of course that is the default DEFAULT -- if you know what i mean -- when you declare a NULLable column

no, it is not a wrong definition, but there are a couple of things that might be "iffy" --

the two dates should probably be DATE or DATETIME datatypes if you plan to do any sort of date comparisons (e.g. find all rows for the previous month)

is num_jokes a counter? because normally one doesn't store this type of data, because it's redundant and can be derived, and because if you store it, it will have to be updated constantly (inefficient) -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --