N2tFaMFs

11,create like: 
2use a table to create another same table .
3ex: CREATE TABLE IF NOT EXISTS tb_test4 LIKE tb_test3;
4
52,event:
6
7CREATE EVENT event_test 
8ON SCHEDULE EVERY 1 SECOND
9DO INSERT INTO tb_test_e (username, PASSWORD) VALUES ('w1', 'p1');
10
11SHOW EVENTS;
12
13DROP EVENT event_test;
14
153,procedure:
16
17DELIMITER //
18DROP PROCEDURE IF EXISTS pro_test //
19CREATE PROCEDURE pro_test (IN u1 VARCHAR(60), IN p1 VARCHAR(60))
20BEGIN 
21INSERT INTO tb_test_e (username, PASSWORD) VALUES (u1, p1);
22END //
23DELIMITER ;
24
25CALL pro_test('pu1', 'pp2');
26
274,check db info:
28
29SHOW DATABASES;
30USE db_trad_rm;
31SHOW TABLES;
32SHOW PROCESSLIST;
33SHOW EVENTS;
34
355, delete 
36delete from tb_test_e;
37truncate tb_test_e;
38
396, date formate
40DELIMITER //
41DROP PROCEDURE IF EXISTS proc_test_date //
42CREATE PROCEDURE proc_test_date()  
43BEGIN
44DECLARE cur_date_var VARCHAR(20);
45SET cur_date_var = DATE_FORMAT(CURDATE(), '%Y%m%d');
46SET @date_temp = CONCAT('CREATE TABLE IF NOT EXISTS test_date_', cur_date_var, ' LIKE tb_test3');
47SELECT @date_temp;
48PREPARE stat_temp FROM @date_temp;
49EXECUTE stat_temp;
50DEALLOCATE PREPARE stat_temp;
51END //
52DELIMITER ;
53CALL proc_test_date();