INSERT INTO canals (code, libelle) VALUES ('PX05', 'PAUL');
INSERT INTO canals (code, libelle) VALUES ('PX_ACIMA', 'ACIMA');
INSERT INTO canals (code, libelle) VALUES ('PX_BIM', 'BIM');
INSERT INTO canals (code, libelle) VALUES ('PX_BVP', 'BVP');
INSERT INTO canals (code, libelle) VALUES ('PX_CHOPAIN', 'CHOPAIN');
INSERT INTO canals (code, libelle) VALUES ('PX_CLUB ME', 'CLUB MED');
INSERT INTO canals (code, libelle) VALUES ('PX_FOODPX', 'FOODIPEX');
INSERT INTO canals (code, libelle) VALUES ('PX_GLOVO', 'GLOVO');
INSERT INTO canals (code, libelle) VALUES ('PX_KAZYON', 'KAZYON');
INSERT INTO canals (code, libelle) VALUES ('PX_MADAEF', 'MADAEF');
INSERT INTO canals (code, libelle) VALUES ('PX_RISMA', 'RISMA');
INSERT INTO canals (code, libelle) VALUES ('PX09', 'SILVER');
INSERT INTO canals (code, libelle) VALUES ('PX10', 'BRONZE');

update clients set canals_ids = ( select id from canals where code=clients.groupe_prix limit 1 );

insert ignore into `canals_has_clients`(clients_id,canals_id) select id,canals_ids from clients;