Try to search your question here, if you can't find : Ask Any Question Now ?

How can I delete columns from a table that have mutliple dependencies?

HomeCategory: stackoverflowHow can I delete columns from a table that have mutliple dependencies?
Avatarrupesh asked 1 month ago

So I have a table that is made up similar to this

group_id | code |code_type
 1         45       '9'
 2         56       '0'
 3         56       'NA'
 4         32       'NA'

The problem is that I have multiple code_types for the same code, but that’s okay, but when there is an ‘NA’ I want to delete it from the table, because obviously we have another code_type that specifies that code. So we don’t need that ‘NA’. Hopefully this makes sense, I’ll be glad to clarify if needed. So when it’s all said and done we will delete row 3 and keep the rest.

1 Answers
Best Answer
AvatarMannu answered 1 month ago
Your Answer

9 + 12 =

Popular Tags

WP Facebook Auto Publish Powered By : XYZScripts.com