Can we change the memSQL columns ordinal position in a table

Help
2

You can use ALTER TABLE … MODIFY. SingleStoreDB Cloud · SingleStore Documentation.
E.g.

memsql> create table t(a int, b int, c int);
Query OK, 0 rows affected (0.07 sec)

memsql> insert t values(1,2,3);
Query OK, 1 row affected (0.04 sec)

memsql> select * from t;
+------+------+------+
| a    | b    | c    |
+------+------+------+
|    1 |    2 |    3 |
+------+------+------+
1 row in set (0.07 sec)

memsql> alter table t modify c int after a;
Query OK, 1 row affected (0.76 sec)
Records: 1  Duplicates: 0  Warnings: 0

memsql> select * from t;
+------+------+------+
| a    | c    | b    |
+------+------+------+
|    1 |    3 |    2 |
+------+------+------+

Don’t try to directly update information_schema. That’s not recommended and I’m not sure it’s possible.

1 Like