Recherche dans la base

• Description de la base

mysql> select user_subscriber,list_subscriber,bounce_subscriber from subscriber_table 
       where bounce_subscriber != 'NULL' order by list_subscriber;

Pour les listes d'une école : (direction.ecole, scolarite.ecole, ….)

mysql> select user_subscriber,list_subscriber from subscriber_table 
       where bounce_subscriber != 'NULL' and list_subscriber like "%ecole" ;

Supprimer les erreurs

mysql> update subscriber_table set bounce_subscriber =NULL and  bounce_score_subscriber =NULL
       where bounce_subscriber != 'NULL' and list_subscriber = 'xxxx' ;

mysql> select user_subscriber, list_subscriber  from  subscriber_table where  reception_subscriber ='nomail' ;

mysql> select user_subscriber from  subscriber_table where  reception_subscriber ='nomail' and list_subscriber = 'liste' ;

mysql> update subscriber_table SET reception_subscriber ='nomail' WHERE  user_subscriber like '%jean.dupont%';

ou

mysql> update subscriber_table SET reception_subscriber ='nomail' WHERE  user_subscriber ='jean.dupont@grenoble-inp.fr';

mysql> select user_subscriber, list_subscriber  from  subscriber_table where user_subscriber like 'jean.dupont%';

mysql> select user_subscriber, list_subscriber  from  subscriber_table where list_subscriber='liste';

mysql> delete from subscriber_table where list_subscriber='liste';

mysql> select list_admin  from admin_table where role_admin='owner' and user_admin='toto@grenoble-inp.fr';

mysql> select list_admin  from admin_table where role_admin='editor' and user_admin='toto@grenoble-inp.fr';

mysql> select subscriber_table.list_subscriber, user_subscriber from subscriber_table 
       left join admin_table on admin_table.list_admin=subscriber_table.list_subscriber 
       where admin_table.role_admin='owner' and admin_table.user_admin='toto@grenoble-inp.fr';

mysql> SELECT user_admin, list_admin from admin_table 
       where role_admin='owner' and list_admin in 
      (select list_subscriber from subscriber_table where included_subscriber='1');

mysql> delete from exclusion_table  where  list_exclusion='test-exclus' and  user_exclusion='toto@grenoble-inp.fr' ;

mysql> select distinct robot_list from  list_table;