mysql fields ??

[amy1]

1)How can I set up a column with pre-defined values so that I can use them in check boxes and/radio buttons or lists? How can I design my table so that it shows the check box, etc.?

2)Can I assign calculations to a column: ie: column c= column a + colunm b

3)How can I set a modification date column so that will insert the date automatically after any modification to the database?

4) I want to put a reference to image dir into a varchar column but I don't know the sytax for it do I just go like this: images/image.jpg or full address and do I use any quotation marks????

thanks

[Sxooter]

1: create table test (information text default 'abc');

2: Yes.

3: timestamp in mysql does this (against SQL spec, but it works.)

4: yep. Just like that.