OpenCart MySQL Commands

Go to phpmyadmin and click on the sql tab.
there you will get a form to input queries.
input the following commands and press "GO"

To enable or disable countries -

UPDATE country SET status = 0 WHERE country_id <> 223;
UPDATE zone SET status = 0 WHERE country_id <> 223;

223 = USA
222 = UK
150 = Netherlands

status 0 = disabled
status 1 = enabled

Lets share opencart Mysql commands here in the forum !

I second that! Very helpful!