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;