Mysql questions- creating a table

vinnieza · Post by **vinnieza** » Wed Jun 22, 2005 2:27 pm

When creating a table what is collation?

also what is attributes and null for?

Thanks (ps point me to a website if you want)

(me goes off to google, sorry i always ask before i google. Tis much easier and if i don't find an answer there's probably usually one on the forum when i get back

)

Edit: Data types: http://www.mysqlfreaks.com/mysql_datatypes.php

Vacant · Post by **Vacant** » Thu Aug 25, 2005 12:33 pm

If you make something NOT_NULL, it means that the field can't be left blank in the table.

He says, neglecting to mention that hes only being doing mySQL for a few days

vinnieza · Post by **vinnieza** » Thu Aug 25, 2005 12:41 pm

lol better late than never i guess

Although, i only know the answer to the null one, the one you answered

Actually i did start on mysql a long time before that but only read the sql stuff on w3

then came back to it ages later

Vacant · Post by **Vacant** » Thu Aug 25, 2005 12:46 pm

I meant that *I* havent been doing it for that long, just to clear that up.

vinnieza · Post by **vinnieza** » Thu Aug 25, 2005 12:49 pm

i see

, but when i posted that, it had been about a week that i'd been working with mysql properly well maybe more or less can't rememeber