Edward Posted December 3, 2013 Share Posted December 3, 2013 I was just wondering does anyone like to use table prefixes and why? Most of Larry's book don't have them sorry Larry but i didn't see them. I have a website with increasing database tables and would like to start using abbreviations now if are necessary. I would appreciate any answers to this question. Link to comment Share on other sites More sharing options...
Larry Posted December 6, 2013 Share Posted December 6, 2013 Hey Edward. Could you explain what you mean by "table abbreviations"? Just want to make sure we're talking about the same thing before I answer. Also could you send me an email? I have something for you (if you want). Thanks! Link to comment Share on other sites More sharing options...
Edward Posted December 7, 2013 Author Share Posted December 7, 2013 I mean like for your mysql tables, sorry i meant prefixes i have updated the post. tbl_orders tbl_transactions etc... Link to comment Share on other sites More sharing options...
Edward Posted December 7, 2013 Author Share Posted December 7, 2013 Btw i don't know your email, i recently changed my email to a more personal email. I updated my email on this forum if you can email it. I did send you two messages one with the incorrect email the second with the correct email. I would appreciate it if you don't print my email on these forum threads if you have to confirm it you can check my email in your user database. Link to comment Share on other sites More sharing options...
Edward Posted December 8, 2013 Author Share Posted December 8, 2013 Its alright i finally answered my own question. Thanks Link to comment Share on other sites More sharing options...
Larry Posted December 8, 2013 Share Posted December 8, 2013 Hello Edward. I'll reply to your email in a bit. Thanks for sending that. I'm not using it anywhere here, just sending you a direct email. As for the table prefixes, I've never particularly used them, but I understand their appeal, especially on larger projects or when using multiple components (e.g., a forum, a shopping cart, etc.). So, in that case, I might be inclined to do wp_, ipb_, and so forth. I don't quite get the point of using tbl_ as a prefix (awfully redundant), but I know it's a common thing to do. Link to comment Share on other sites More sharing options...
Edward Posted December 8, 2013 Author Share Posted December 8, 2013 That was what i was thinking using them to help separate database tables, the good thing about Yii is we can later just change the table name that the model links to. I guess i can leave that for later on. Thanks i appreciate your reply. Link to comment Share on other sites More sharing options...
Recommended Posts