记录--常用的linux命令

时间:2022-03-17 16:28:50

 

 

 

mysql event

/*查询event是否开启(查询结果Off为关闭  On为开启)*/
show variables like '%sche%';   

/*开启/关闭命令(1开启--0关闭)*/
set global event_scheduler=1;

/*关闭事件任务: */alter event e_test_insert ON COMPLETION PRESERVE DISABLE; 
/*开户事件任务: */alter event e_test_insert ON COMPLETION PRESERVE ENABLE; 

/*删除存储过程*/
drop procedure up_appointment_del

/*查询所有存储过程*/
show PROCEDURE STATUS

/*查询表的列*/
DESCRIBE housesinfo


/*导出表-mysql*/
mysqldump -uroot -h192.168.1.59 --routines -p callcenter > D:\2016-04-07.sql