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;