摘要:
mysql列存储引擎-用户定义变量-现状记录
关联ISSUE: https://github.com/stoneatom/stonedb/issues/958
参考:
MySQL :: MySQL 5.7 Reference Manual :: 9.4 User-Defined Variables
DDL:
表结构及数据:
create table t(a int, b int, index idx_a(a));
insert into t values (1,2), (3,4);
insert into t select a + 1, b + 1 from t;
查询SQL:
SELECT i, a AS aa