use location;
drop function if exists fct_compare;
delimiter //
create function fct_compare()
returns varchar(60)
reads sql data
begin
DECLARE nb_article,nb_categorie int;

SELECT 
    COUNT(*)
INTO nb_article FROM
    article;
SELECT 
    COUNT(*)
INTO nb_categorie FROM
    categorie;
 if nb_article < nb_categorie then
	return 'la table categorie contient plus de lignes qu''article';
else
return 'la table article contient plus de lignes que categorie';
  end if;
  end;
  //
delimiter ;
select fct_compare();