Welcome Guest, Not a member yet? Register   Sign In
Avoid conflict between column names ?

(This post was last modified: 11-07-2017, 12:38 AM by Coool6.)

Hello to the great CI community !

Before i used to write my columns names as follow : 

[dbprefix]_[tablename]_[columnname] for example abc_recipes_name 

It avoided any conflict with other tables in case of joining for example.
but seems nobody do that except me, so i'm back to just the column name but in case of joining it cause some issues. 

My actual way of fixing is to use aliases in the SELECT but i'm not sure if it's the best practice, it's a bit of messy.

Is there any better way using CI ? 

Thanks a lot,

Messages In This Thread
Avoid conflict between column names ? - by Coool6 - 11-07-2017, 12:38 AM

Theme © iAndrew 2016 - Forum software by © MyBB