mysql date

[NZ_Kiwis]

how can I set my mysql table up so the date is dd-mm-yyyy?

[Weedpacket]

You don't. The date is stored independently of the format, which can be specified when selecting by using DATE_FORMAT; for insertion there is the STR_TO_DATE function.