2KV9NyJk

1id bigint
2name varchar
3description varchar
4slug 
5     
6CREATE TABLE IF NOT EXISTS MyTable (
7  id int NOT NULL AUTO_INCREMENT,
8  name varchar(50) NOT NULL,
9  description varchar(50) NOT NULL,
10  slug varchar(64) NOT NULL AS (SHA2(CONCAT(name, description), 256) STORED,
11  PRIMARY KEY (id)
12) DEFAULT CHARSET=utf8; 
13     
14CREATE TRIGGER MySlugIns BEFORE INSERT ON MyTable
15FOR EACH ROW SET slug = SHA2(CONCAT(name, description));
16
17CREATE TRIGGER MySlugUpd BEFORE UPDATE ON MyTable
18FOR EACH ROW SET slug = SHA2(CONCAT(name, description), 256); 
19     
20COLUMN        VALUE
21id            1
22name          Fred
23description   A Person
24slug          ea76b5b09b0e004781b569f88fc8434fe25ae3ad17807904cfb975a3be71bd89 
25     
26select md5(concat_ws('', col_1, .. , col_n));