creeV3Country.sql 305 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 pays;

show create table Country;