Hbase-触发器，存储

触发器

USE test;
#创建学生表
CREATE TABLE IF NOT EXISTS student
(
    username VARCHAR(50),
    PASSWORD VARCHAR(50),
    stuid INT PRIMARY KEY AUTO_INCREMENT,
    birthday DATE
);
#插入数据
INSERT INTO student(username,PASSWORD,birthday)
VALUES
('王二','11111','2016-08-23');
#成绩表
CREATE TABLE IF NOT EXISTS cj
(
    num INT AUTO_INCREMENT PRIMARY KEY,
    stu_id INT,
    stu_name VARCHAR(50),
    math FLOAT,
    chinese FLOAT,
    english FLOAT
);
SELECT * FROM student;
#触发器：插入语句
DELIMITER $
CREATE TRIGGER abc
AFTER INSERT ON student FOR EACH ROW
BEGIN
INSERT INTO cj(stu_id,stu_name)VALUES(new.stuid,new.username);
END $
DELIMITER ;

#执行触发
INSERT INTO student(username,PASSWORD,birthday)
VALUES
('张三','22222','2016-08-23');