1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-08-01 06:46:55 +03:00
Files
mariadb-columnstore-engine/utils/winport/win_setup_mysql_part3.1.sql
2016-01-06 14:08:59 -06:00

13 lines
473 B
SQL

use calpontsys;
select calonlinealter(
'alter table systable add (autoincrement int)') as xxx;
alter table systable add (autoincrement int);
update systable set autoincrement=0 where autoincrement is null;
select calonlinealter(
'alter table syscolumn add (nextvalue bigint)') as xxx;
alter table syscolumn add (nextvalue bigint);
update syscolumn set nextvalue=1 where nextvalue is null;
update syscolumn set autoincrement='n' where autoincrement is null;