selenin Posted June 6, 2010 Share Posted June 6, 2010 Hello, I'm just trying to modify a mysql field named source_id smallint(2), now I want to make it for more ids then one. I thought to do it like source_id varchar(100) and then write the ids like 53 ¦ 34 ¦ 78 ¦ and so on. Do you think that's a good idea, I'm pretty new with mysql? Quote Link to comment https://forums.phpfreaks.com/topic/204036-mysql-field-modification/ Share on other sites More sharing options...
Mchl Posted June 6, 2010 Share Posted June 6, 2010 It's a bad idea. If there will be more than one source_id assigned to a record in this table, you should move this data to other table. Quote Link to comment https://forums.phpfreaks.com/topic/204036-mysql-field-modification/#findComment-1068683 Share on other sites More sharing options...
selenin Posted June 6, 2010 Author Share Posted June 6, 2010 Thanks Mchl Quote Link to comment https://forums.phpfreaks.com/topic/204036-mysql-field-modification/#findComment-1068690 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.