Re: FN-FORUM MySQL Crash Cource Please

date posted 13th July 2001 17:56

OK, so the 'KEY' value refers to a field called 'clientID' in another table,
but what do I do with it ?

Cheers

Willie Jordaan


>
> CREATE TABLE adclicks (
> bannerID mediumint(9) DEFAULT '0' NOT NULL,
> t_stamp timestamp(14),
> host varchar(255) NOT NULL,
> KEY clientID (bannerID)
> );
>
>
> >From this I take it that I create a table called 'adclicks' and (?????)
> fields.
>
> Now I'm faced with the options in phpMyAdmin. I added some values as I
think
> they should be (but I bet it's wrong)
>
> Field: Type: Length/Set Attributes
Null
> Default Extra Primary Index Unique
> bannerID MEDIUMINT 9 not
null
> t_stamp TIMESTAMP 14
> host VARCHAR 255 not
> null
> clientID
>
????????????????????????????????????????????????????????????????????????????
> ???????
>
> What does 'KEY' indicate?
>
> What happens to the empty values?
> Some of them (in this case 'clientID' will have a value in 'Type'. What do
I
> set that to if it is not specified?
>
> Any help in this would really be appreciated.
>
> Cheers
>
> Willie Jordaan
>
>
>
> ============================================================
>
> * Free listing for freelancers
> * Free to advertise jobs
> * Free jobs distribution service
> * Free database of 1000 freelancers
>
> Freelancers and Freelance Jobs
> http://www.freelancers.net
>
> To post to the Forum:
> [EMAIL REMOVED]
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
> To subscribe to the digest for this list or for further information please
visit:
> http://www.freelancers.net/forum.html
>