Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

removing country names


ShowRides

Recommended Posts

Says who? Run this SQL (backup your db first).

 

DROP TABLE IF EXISTS countries;

CREATE TABLE countries (

countries_id int NOT NULL auto_increment,

countries_name varchar(64) NOT NULL,

countries_iso_code_2 char(2) NOT NULL,

countries_iso_code_3 char(3) NOT NULL,

address_format_id int NOT NULL,

PRIMARY KEY (countries_id),

KEY IDX_COUNTRIES_NAME (countries_name)

);

INSERT INTO countries VALUES (223,'United States','US','USA', '2');

 

Done

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...