SELECT
GROUP_CONCAT(COLUMN_NAME) AS fields
FROM
INFORMATION_SCHEMA.Columns
WHERE
table_name = 'mytable'
AND table_schema = 'test';
select trigger_schema, trigger_name, action_statement from information_schema.triggers
select * from information_schema.triggers where information_schema.triggers.trigger_schema like '%test%';
select * from information_schema.triggers where information_schema.triggers.trigger_name like '%trigger_name%' and information_schema.triggers.trigger_schema like '%data_base_name%';
SELECT
table_name, data_length
FROM
information_schema.tables
WHERE
table_schema = 'netkilller'
ORDER BY data_length DESC
LIMIT 10;