7 lines
225 B
Text
7 lines
225 B
Text
.mode list
|
|
.headers off
|
|
.once dynamic.tmp
|
|
select 'alter table t rename column ''column' || format('{:02d}', 2 * n) || ''' to ''flag' || format('{:02d}'';', n) from range(1,25) t(n);
|
|
.read dynamic.tmp
|
|
.mode duckdb
|
|
.headers on
|