clear markdown feedback
≡
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (36238 in the last week).
select version();
version()
10.3.28-MariaDB
…
 hidden batch(es)
CREATE OR REPLACE TABLE t ( x INT ) WITH SYSTEM VERSIONING;
✓
 hidden batch(es)
ALTER TABLE t DROP SYSTEM VERSIONING;
✓
 hidden batch(es)
show create table t
Table Create Table
t CREATE TABLE `t` ( `x` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1
…
 hidden batch(es)
ALTER TABLE t ADD COLUMN ts TIMESTAMP(6) GENERATED ALWAYS AS ROW START
Duplicate ROW START column `ts`
 hidden batch(es)
ALTER TABLE t ADD COLUMN ts TIMESTAMP(6) GENERATED ALWAYS AS ROW START, ADD COLUMN te TIMESTAMP(6) GENERATED ALWAYS AS ROW END
Duplicate ROW START column `ts`
 hidden batch(es)