Mysql 5.7的虚拟列

User:Administrator

Create Time:2021-5-20 16:56

• Snippet:2021-5-20 16:56
  • 致谢:
    • Mysql 5.7的虚拟列
  • 问题概述:mysql虚拟列
  • 方案细节

      txt> 创建包含虚拟列的表
      sql> CREATE TABLE `vir_test` (
           `id`                   int(11) NOT NULL AUTO_INCREMENT,
           `SimpleDate`           date DEFAULT NULL,
           `SimpleDate_dayofweek` tinyint(4) GENERATED ALWAYS AS (dayofweek(SimpleDate)) VIRTUAL,
           PRIMARY KEY (`id`),
           KEY `SimpleDate_dayofweek` (`SimpleDate_dayofweek`)
           ) ENGINE=InnoDB
      
      txt> 查看列信息
      sql> select * from information_schema.`COLUMNS` where TABLE_NAME LIKE '%VIR%';
      txt> 标志字段VIRTUAL GENERATED,来判断该列是虚拟列.