idShura

DELIMITER | 
CREATE TRIGGER `base`.`after_table`
AFTER INSERT ON `table` FOR EACH ROW BEGIN
INSERT INTO `table2` SET `name`='text';
END |
DELIMITER ;

-- Cleaning wp_commentmeta
SELECT *
  FROM wp_commentmeta
 WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments);

DELETE FROM wp_commentmeta
 WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments);

SELECT *
  FROM wp_commentmeta
 WHERE meta_key LIKE '%akismet%';

DELETE FROM wp_commentmeta
 WHERE meta_key LIKE '%akismet%';

-- Cleaning wp_postmeta table
SELECT *
  FROM wp_postmeta pm 
       LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
 WHERE wp.ID IS NULL;

DELETE pm
  FROM wp_postmeta pm 
       LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
 WHERE wp.ID IS NULL;

mysqld --verbose --help
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf

SELECT T1.PRIVILEGE, 
       T1.ADMIN_OPTION  SYS_USER,
       T2.ADMIN_OPTION  MY_USER 
  FROM DBA_SYS_PRIVS T1 
       LEFT JOIN DBA_SYS_PRIVS T2 ON T1.PRIVILEGE = T2.PRIVILEGE 
                           AND T2.GRANTEE = 'MY_USER'
  WHERE T1.GRANTEE = 'SYS'
  ORDER BY T1.PRIVILEGE ASC

select t1.Call_date 
       t1.AON
       count(*) cnt
  from tab1 t1
       left join tab1 t2 ON t2.AON = t1.AON 
 where t2.Call_date between t1.Call_date 
                        and t1.Call_date + 1
 group by t1.Call_date 
          t1.AON

SELECT o.* 
  FROM orders o
  LEFT JOIN status s ON s.orderid = o.id
 WHERE s.pay = 1