mirror of
https://github.com/MariaDB/server.git
synced 2025-02-07 06:12:18 +01:00
17 lines
613 B
Text
17 lines
613 B
Text
create database mysqltest1;
|
|
create table mysqltest1.t1 (i int, j int as (i) persistent);
|
|
show create table mysqltest1.t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`i` int(11) DEFAULT NULL,
|
|
`j` int(11) GENERATED ALWAYS AS (`i`) STORED
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
|
|
alter table mysqltest1.t1 add index (i);
|
|
show create table mysqltest1.t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`i` int(11) DEFAULT NULL,
|
|
`j` int(11) GENERATED ALWAYS AS (`i`) STORED,
|
|
KEY `i` (`i`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
|
|
drop database mysqltest1;
|