Single field multiple entry

saifullah khan

15y2kSQL

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
Accepted 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 Hobbs15y ago
Can you add columns to the table or must you use the same columns (userid, username,months)? 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 khan15y ago
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?
15y ago
Yes . You can. Use varchar datatype to store multiple data in a single column.
Jaganathan Bantheswaran15y ago
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.