脚本宝典收集整理的这篇文章主要介绍了DATABASE TEST8,脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。
#subwindow
CREATE TABLE test8_00 AS
SELECT * FROM pub.teacher
GRANT ALL ON test8_00 to user202000130088
GRANT select on test8_00 to user202000130088
GRANT update on test8_00 to user202000130088
GRANT insert on test8_00 to user202000130088
GRANT delete on test8_00 to user202000130088
#mainwindow
# test SELECT * FROM userb202000130088.test8_00
CREATE TABLE test8_10 (test varchar(20),age numeric(3))
INSERT INTO test8_10 VALUES('结果1',88)
INSERT INTO test8_10 VALUES('结果2',90)
INSERT INTO test8_10 VALUES('结果3',90)
INSERT INTO test8_10 VALUES('结果4',86)
INSERT INTO test8_10 VALUES('结果5',90)
INSERT INTO test8_10 VALUES('结果6',90)
Update userb202000130088.test8_00 set age=age-10
INSERT INTO test8_10 VALUES('结果7',86)
CREATE TABLE test8_01 AS SELECT * FROM test8_00
INSERT INTO test8_10 VALUES('结果8',86)
INSERT INTO test8_10 VALUES('结果9',76)
INSERT INTO test8_10 VALUES('结果10',86)
以上是脚本宝典为你收集整理的DATABASE TEST8全部内容,希望文章能够帮你解决DATABASE TEST8所遇到的问题。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。