摘要：1 SELECT IF(ed.id IS NULL, '0', ed.id) id, IF(ed.name IS NULL, '其他', ed.name) name, COUNT(up.uid) memberCount, IF(ed.create_time IS NULL, NOW(), ed.create_time) create_time FROM user_profile up 2 ... 阅读全文

摘要：UPDATE enrolment SET create_time = CONCAT('2016-01-', FLOOR(RAND() * 6 + 1), ' ', FLOOR(RAND() * 24), ':', FLOOR(RAND() * 59), ':', FLOOR(RAND() * 59)... 阅读全文

摘要：1 /* 2 * 添加数据之后报名人数加一 3 */ 4 DELIMITER $$ 5 CREATE TRIGGER trigger_insert_enrolment_party_info 6 AFTER INSERT ON `enrolment` 7 FOR EACH ROW... 阅读全文

摘要：添加、修改、删除字段/** 添加字段 **/ALTER TABLE table_name ADD field type DEFAULT NULL;/** 修改字段 **/ALTER TABLE table_name CHANGE old_field new_field new_type;/** 删除... 阅读全文