Table Design in mysql

Question

Hi everyone,

I need to create one table, Description : i need to create table based on schedule like daily, weekly & monthly,

columns are like : sno, startdate, enddate, day, scheduletype

For example i ll take weekly data, for my point of view : From sunday to saturday (1 - 7 )Id i create.... So lots of posibilities are creates like (1,2)(1,3) ..(1,2,3)....up to n....this twise posibility only but that will created up to 7 posibility in one.

so how can i store this posibility in mysql database?

If any one have an issue get back to me...

Thanks in advanced!!!!

Riddhi

Answer 1

mysql> CREATE TABLE Date (StartDate date, EndDate date, -> Number of days VARCHAR(20), Reason(1)); with this you can create a table