use location;
 delete from client where codeclient >8;
 drop procedure if exists inserer_client;
delimiter //
create procedure inserer_client()
begin
  declare cpt, nb     int;
  declare code   int;
  set cpt = 0;
  set nb=100;
	set code=10;
  while cpt < nb
  do
    
    insert into
     client (codeclient ,nom,prenom , codpost ,ville )
    values
     (code,concat('n_client',code),concat('p_client',code),'17300','Rochefort');
   
        set cpt   = cpt + 1;
		set code=code+1;
  end while;
end;
//
delimiter ;
call inserer_client;
select * from client;