Skip to main content

All About Opencart: Add table prefix in mysql database for opencart

All About Opencart: Add table prefix in mysql database for opencart:

Add table prefix in mysql database for opencart

If you ever install an opencart without table prefix, you'll get troubles when using some custom modules. (Especially with the table ORDER, RETURN and OPTION. Because that is same as MYSQL Syntax., you'll get error when calling such as "SELECT * FROM ORDER")

Here is what you do to add prefix on the table.

Enter the database you want to change the table prefix.

put below command in SQL Tab and run it. Just change the RED one. Example : my_prefix_ into oc_
and my_database into yourdatabasename

SELECT Concat('ALTER TABLE ', TABLE_NAME, ' RENAME TO my_prefix_',TABLE_NAME, ';') FROM information_schema.tables WHERE table_schema ='my_database'
run it in SQl Tab in PHPMyadmin.
Copy the results. (Don't forget click Show All, to see all result) and select it from top to bottom using your mouse, and copy it.
Paste it on the notepad first.

and remove these 3 row from the list.
ALTER TABLE option RENAME TO oc_option; (rename manualy)
ALTER TABLE return RENAME TO oc_return; (rename manualy)
ALTER TABLE order RENAME TO oc_order; (rename manualy)
if you put this on below list, it will get error. You'll have to rename it manually one by one. Not using SQL Tab.

Copy the list (list table may vary, don't use my result list, use your result list) because i already delete some lines, because it's to long.
ALTER TABLE address RENAME TO oc_address;
ALTER TABLE affiliate RENAME TO oc_affiliate;
ALTER TABLE affiliate_transaction RENAME TO oc_affiliate_transaction;
ALTER TABLE attribute RENAME TO oc_attribute;
ALTER TABLE attribute_description RENAME TO oc_attribute_description;
ALTER TABLE attribute_group RENAME TO oc_attribute_group;
ALTER TABLE attribute_group_description RENAME TO oc_attribute_group_description;
ALTER TABLE url_alias RENAME TO oc_url_alias;
ALTER TABLE user_group RENAME TO oc_user_group;
ALTER TABLE weight_class RENAME TO oc_weight_class;
ALTER TABLE weight_class_description RENAME TO oc_weight_class_description;
ALTER TABLE zone_to_geo_zone RENAME TO oc_zone_to_geo_zone;
Copy the list put it on SQL Tab Box and run it.
there you go. please refresh it if you don't see the result changes. just change between database, and back again. you will see all your tables already have a prefix on it.
Don't Forget to manually rename the 3 tables (OPTION, RETURN and ORDER), don't use SQL you'll get error.
First Select the table, then click OPERATIONS Tab,  
Table options
Rename table to
Rename it to oc_order. (example). That's it. 
Thank you for reading. Hope it'll help you.


Popular posts from this blog

that freaky htaccess

Htaccess - Evolved

The Hyper Text Transfer Protocol (HTTP) was initiated at the CERN in Geneve (Switzerland), where it emerged (together with the HTML presentation language) from the need to exchange scientific information on a computer network in a simple manner. The first public HTTP implementation only allowed for plain text information, and almost instantaneously became a replacement of the GOPHER service. One of the first text-based browsers was LYNX which still exists today; a graphical HTTP client appeared very quickly with the name NCSA Mosaic. Mosaic was a popular browser back in 1994. Soon the need for a more rich multimedia experience was born, and the markup language provided support for a growing multitude of media types.

Htaccess file know-how will do several things for you:

Make your website noticeably faster.
Allow you to debug your server with ease.
Make your life easier and more rewarding.
Allow you to work faster and more productively.
^AskApache Htaccess Journey


NF - Not the Same (Audio)

Word of the Day

Here is your word for today:

Verse:   2 Chronicles 16:9

'The eyes of the Lord run to and fro throughout the whole earth, to show Himself strong in the behalf of them whose heart is perfect toward Him.'

- The Lord wants to step into your situation and show His strength.
- The Lord wants to show Himself strong on your behalf.
- Our hearts are perfect towards Him when we have placed all our hope in Him.
- No situation escapes His view, so let's be confident in His strength and ability.

PRAYER: Lord, I pray that You will come and show Yourself strong on my behalf. Move in my situation and may I see the powerful and mighty hand of God at work. Amen.

Have a blessed Tuesday.