PHPmyAdmin help

I have just downloaded phpmyadmin and went to create a database and was faced with alot of diferent option to what im used to using access. atm im trying to find out a expanation for the options on the mysql site but its like looking for a nedle in a haystack. if anyone has time could they expalin in laymans terms what each field is

1.Field Type
2.Length/Values*
3.Collation
4.Attributes
5.Null
6.Default**
7.Extra
8.Comments
9.MIME type
10.Browser transformation
11.Transformation options***

all i need to know is what info need to go into them and what they do, then hopfully i will have more of a clue where to start.

Cheers ME

hey,
ok here is what i think!! I hope i am right!!

1. The type of data the field will be storing, eg INT, VarChar, Set, Blob, etc For a definition of these see the site or ask for specific ones here ! Can't rewrite the manual tho
2. The length of the field or the values it holds. For example if you want the VARChar length to be only 100 then put in 100. For some you have to specifiy (like varchar) for others like int you don't as it will set it for you. The Values side of things, if you select the field type as set it allows you to list the values that can be in the db. Eg for a forum you might have a field "account_activated" and the options would be yes or no so in the values field you would put 'yes', 'no'
3. No idea where you are looking..sorry
4. Setting the attributes of the field binary/unsigned etc, not sure how to explain this...
5. i think the null/not null is there so if when you inset it is ok for the field to be empty then it goes through but if it is set to notnull then there has to be an entry for that field on the insert statement.
6. you can set a default so that if the insert statement you have does not insert anything to the db then the default value will be used.
7. Extra provides the ability for you to auto increment a int field, most commonly used for the id of the record!
8. Any comments about the DB which another developer may need.
9. /10 /11. not sure tbh...

i hope what i have written helps, maybe someone else can explain the rest..

Any more questions just ask and i will try to help!

RF

Thanks mate, yep all the above is a help and will get me on my way.. time to play and get back with more questions for u... getting a couple of books so ill read those then, think of something to test your brain thanks mate

brain??? what brain....not sure i have one of those

lol

stop laughing at me and go and do some work

done too much of it lately god i need xmas to hurry up so i can do afternoon drinking and evening sleeping ooo for xmas

lol, i have been wrking a lot recently too!! Trying to finish writing the code for my hosting site!! So not much time to troll here