|
|
Posted by moosus on 06/07/06 06:35
Thanks Rik I will go through these
Cheers
moosus
in article 4659c$4486355c$8259c69c$12559@news1.tudelft.nl, Rik at
luiheidsgoeroe@hotmail.com wrote on 7/6/06 12:10 PM:
> moosus wrote:
>> Something like a session id can contain both numbers and letters ->
>> hence making the field text.
>
> But not pages & pages, VARCHAR seems the way to go, and for a lot of other
> fields too.
>
>> `n2` text NOT NULL, = Person's Name
>> `n3` text NOT NULL, = Person's Name
>> `n4` text NOT NULL, = Person's Name
>> `n5` text NOT NULL, = Person's Name
>> `n6` text NOT NULL, = Person's Name
>> `n7` text NOT NULL, = Person's Name
>> `n8` text NOT NULL, = Person's Name
>> `n9` text NOT NULL, = Person's Name
>> `n10` text NOT NULL, = Person's Name
> Are you sure these shouldn't be in a separate table, linked to the id
> earlier?
>
>> `industrytype` text NOT NULL, = Industry Type (from drop down)
>> `affiliation` text NOT NULL, Affiliation (from drop down)
> enum?
>
>> `rego` text NOT NULL, = YES / NO (tick box)
> bool, autmatically converted into tinyint(1) is what I usually choose: 0 or
> 1.
>
>> `expiry` text NOT NULL, = Date (mm/yyyy)
> Why not a real date? When using/displaying the information, you can always
> choose to check/display only the month & year.
>
> If your table is large enough, running the query:
> SELECT * FROM `afta` PROCEDURE ANALYSE ()
>
> Will give a lot of hints, but it's not entirely correct all the time.
>
> In smaller tables, try:
> SELECT * FROM `afta` PROCEDURE ANALYSE (20)
> or something like that: it's the maximum number of distinct values MySQL
> will consider valid for ENUM, which defaults to 256.
>
> Grtz,
Navigation:
[Reply to this message]
|