随笔分类 - 数据库
摘要:-- 查看当前所有事件 show events; -- 查看定时器功能是否开启 show variables like 'event_scheduler'; -- 开启/关闭定时器功能 set global event_scheduler = on/off; -- 针对某一事件开启与关闭 -- 开启
阅读全文
摘要:SELECT A.name AS table_name, B.name AS column_name, C.value AS column_description FROM sys.tables A INNER JOIN sys.columns B ON B.object_id = A.object
阅读全文