CREATE TABLE test (a INT, b AS 1+1)INSERT INTO test(a) VALUES(1)SELECT * FROM testALTER TABLE test DROP COLUMN b ALTER TABLE test ADD b AS 2+2
INSERT INTO test(a) VALUES(1)SELECT * FROM test/*
a b
----------- -----------
1 2(1 行受影响)(1 行受影响)a b
----------- -----------
1 4
1 4*/
INSERT INTO test(a) VALUES(1)SELECT * FROM test/*
a b
----------- -----------
1 2(1 行受影响)(1 行受影响)a b
----------- -----------
1 4
1 4*/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货