creeV3Country.sql 326 Bytes
tee creeV3Country.log

-- create table Country (
-- 	countryId int(11) NOT NULL AUTO_INCREMENT,
-- 	countryName varchar(100) DEFAULT NULL,
-- 	PRIMARY KEY ('countryId')
-- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into Country (countryId, countryName)
	select ID_PAYS, LIB_PAYS from v2.pays;

-- show create table Country;