MySQL Crash Cource Please

date posted 13th July 2001 17:43

I would really appreciate if anybody can help me with this:

I am using phpMyAdmin, since it is easy to use and I have installed and used
it before.

For some reason I can not execute the 'all.sql' script that came with the
banner script, so doing it manualy seems the only option. The server is
remotely hosted Cobalt RAQ4.

Here is one of the tables I have to create and if someone can show me how I
will try and do the rest. It's about time I learn how to do this.


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