Single field multiple entry

Question

I have a database table contains:

userid, username,months.

Is it possible store more than one number of months in a single field for one user. means that for example for user 1,name khan,months 1,2,3,4,5,6,7 or jan,feb,mar,ap,may,jun etc. is it possible????if yes then how please help me

Suthish Nair · Answer

If that the case use a separate table having two columns for storing Foreign Key and Month column. This will be easy when you generate reports or want to make any joins DML operations etc..

Sam Hobbs · Answer

Can you add columns to the table or must you use the same columns (userid usernamemonths)? I am not sure I understand Suthish's suggestion but it is probably what database experts would say to do. You also did not say if the multiple months consist of a single range; in other words 1-7 (or jan-jul) for January through July. If a single range then you could have a start month and an end month. If not a single range then you could create 12 boolean fields and set them to true or false.

saifullah khan · Answer

ok sir it is correct but when i want to generate report which show me the months in a sequence and in a proper format for a particular user then what will i do?

Muralidharan Deenathayalan · Answer

Yes . You can. Use varchar datatype to store multiple data in a single column.

Jaganathan Bantheswaran · Answer

Hi Just make months column as type of varchar and store the months separated by comma. While retrieving the months split it by comma and do the stuff.