Post by al3xandr1a » Sat Jun 01, 2013 12:33 pm

Installing opencart, is an underscore "_" necessary in table prefixes?

What will happen if I use "prefixname" only instead of "prefixname_" ?

~al3xandr1a
Newbie / Student


User avatar
New member

Posts

Joined
Fri Jul 02, 2010 7:27 pm

Post by ChetanCx » Sat Jun 01, 2013 3:08 pm

Its not compulsory to use underscore in prefix

example :
table prefix = mystore
table names :- mystoreorders , mystoreproducts etc...

table prefix = mystore_
table names :- mystore_orders , mystore_products etc...

conclusion - easier to read table names

User avatar
Active Member

Posts

Joined
Sat Dec 08, 2012 8:12 pm

Post by al3xandr1a » Sat Jun 01, 2013 6:02 pm

So its only for readability of the developer and nothing to do with database function.... is that correct?

~al3xandr1a
Newbie / Student


User avatar
New member

Posts

Joined
Fri Jul 02, 2010 7:27 pm

Post by Johnathan » Sat Jun 01, 2013 9:36 pm

Yes, the underscore is not required. It's just a database convention to prefix the tables with something related to the software, followed by an underscore.

Image
Image Image Image Image


User avatar
Global Moderator

Posts

Joined
Fri Dec 18, 2009 3:08 am

Who is online

Users browsing this forum: No registered users and 45 guests