Abel.lin的专栏

/**查看event是否开启 : SHOW VARIABLES LIKE '%event_sche%';将事件计划开启 : SET GLOBAL event_scheduler = 1; 将事件计划关闭 : SET GLOBAL event_scheduler = 0; 关闭事件任务 : ALTER EVENT eventName ON COMPLETION PRESERVE DISABL

insert触发器update触发器delete触发器

/**建表*/DROP TABLE IF EXISTS myDataBaseName;CREATE TABLE myDataBaseName ( ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, NAME VARCHAR(255) NOT NULL DEFAULT 'm

1、创建表CREATE TABLE `gas` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `oil` VARCHAR(100) NULL DEFAULT NULL, `district` VARCHAR(100) NULL DEFAULT NULL, `price` DOUBLE NULL DEFAULT '0', PRIMARY KEY (`id`