useful-qry/table-controls/function-snipet.sql

SHOW FUNCTION STATUS WHERE Db = 'genmodel_back';
SHOW PROCEDURE STATUS WHERE Db = 'genmodel_back';

SELECT
    CONCAT('DROP ',ROUTINE_TYPE,' `',ROUTINE_SCHEMA,'`.`',ROUTINE_NAME,'`;') as stmt
FROM information_schema.ROUTINES Where ROUTINE_SCHEMA = 'ssohost_db'

SELECT
    CONCAT('DROP ',ROUTINE_TYPE,' ','`',ROUTINE_NAME,'`;') as stmt
FROM information_schema.ROUTINES Where ROUTINE_SCHEMA = 'genmodel_back'

SELECT group_concat(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_SCHEMA = 'weberp_db' AND TABLE_NAME = 'dbr_setup';

SELECT concat('###', table_name,"$$$;", CHAR(10 using utf8)) FROM information_schema.tables
WHERE table_schema = 'weberp_db';

describe dbr_user_perm;

delete from dbr_company where email = 'sales@dabory.com';
delete from pro_member where email = 'sales@dabory.com';

delete from dbr_company where email = 'admin@dabory.com';
delete from pro_member where email = 'admin@dabory.com';

delete from dbr_company where email = 'dev1@dabory.com';
delete from pro_member where email = 'dev1@dabory.com';
delete from dbr_company where email = 'dev2@dabory.com';
delete from pro_member where email = 'dev2@dabory.com';

delete from dbr_company where email = 'dev1.dabory@gmail.com';
delete from pro_member where email = 'dev1.dabory@gmail.com';
delete from dbr_company where email = 'dev2.dabory@gmail.com';
delete from pro_member where email = 'dev2.dabory@gmail.com';

delete from dbr_company where email = 'wngur6076@naver.com';
delete from pro_member where email = 'wngur6076@naver.com';

delete from dbr_company where email = 'kimhi65@naver.com';
delete from pro_member where email = 'kimhi65@naver.com';