📄 longcolumn.out
字号:
ij> select b from testing;B --------------------------------------------------------------------------------------------------------------------------------b b b b b b b b b b &b b b b b b b b b b &b b b b b b b b b b &b b b b b b b b b b &b b b b b b b b b b &b b b b b b b b b b &b b b b b b b b b b &b b b b b b b b b b &b b b b b b b b b b &b b b b b b b b b b &ij> select c from testing;C --------------------------------------------------------------------------------------------------------------------------------c c c c c c c c c c &c c c c c c c c c c &c c c c c c c c c c &c c c c c c c c c c &c c c c c c c c c c &c c c c c c c c c c &c c c c c c c c c c &c c c c c c c c c c &c c c c c c c c c c &c c c c c c c c c c &ij> select d from testing;D --------------------------------------------------------------------------------------------------------------------------------d d d d d d d d d d &d d d d d d d d d d &d d d d d d d d d d &d d d d d d d d d d &d d d d d d d d d d &d d d d d d d d d d &d d d d d d d d d d &d d d d d d d d d d &d d d d d d d d d d &d d d d d d d d d d &ij> select e from testing;E --------------------------------------------------------------------------------------------------------------------------------e e e e e e e e &e e e e e e e e &e e e e e e e e &e e e e e e e e &e e e e e e e e &e e e e e e e e &e e e e e e e e &e e e e e e e e &e e e e e e e e &e e e e e e e e &ij> select a, c, e from testing;A |C |E --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------a a a a a a a a a a &|c c c c c c c c c c &|e e e e e e e e &a a a a a a a a a a &|c c c c c c c c c c &|e e e e e e e e &a a a a a a a a a a &|c c c c c c c c c c &|e e e e e e e e &a a a a a a a a a a &|c c c c c c c c c c &|e e e e e e e e &a a a a a a a a a a &|c c c c c c c c c c &|e e e e e e e e &a a a a a a a a a a &|c c c c c c c c c c &|e e e e e e e e &a a a a a a a a a a &|c c c c c c c c c c &|e e e e e e e e &a a a a a a a a a a &|c c c c c c c c c c &|e e e e e e e e &a a a a a a a a a a &|c c c c c c c c c c &|e e e e e e e e &a a a a a a a a a a &|c c c c c c c c c c &|e e e e e e e e &ij> select b, e from testing;B |E -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------b b b b b b b b b b &|e e e e e e e e &b b b b b b b b b b &|e e e e e e e e &b b b b b b b b b b &|e e e e e e e e &b b b b b b b b b b &|e e e e e e e e &b b b b b b b b b b &|e e e e e e e e &b b b b b b b b b b &|e e e e e e e e &b b b b b b b b b b &|e e e e e e e e &b b b b b b b b b b &|e e e e e e e e &b b b b b b b b b b &|e e e e e e e e &b b b b b b b b b b &|e e e e e e e e &ij> -- update the first and last columnupdate testing set a = PADSTRING('1 1 1 1 1 1 1 1 1 1', 64768);10 rows inserted/updated/deletedij> update testing set e = PADSTRING('9 9 9 9 9 9 9 9 9 9',64768);10 rows inserted/updated/deletedij> -- select should return 10 rowsselect a, e from testing;A |E -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------1 1 1 1 1 1 1 1 1 1 &|9 9 9 9 9 9 9 9 9 9 &1 1 1 1 1 1 1 1 1 1 &|9 9 9 9 9 9 9 9 9 9 &1 1 1 1 1 1 1 1 1 1 &|9 9 9 9 9 9 9 9 9 9 &1 1 1 1 1 1 1 1 1 1 &|9 9 9 9 9 9 9 9 9 9 &1 1 1 1 1 1 1 1 1 1 &|9 9 9 9 9 9 9 9 9 9 &1 1 1 1 1 1 1 1 1 1 &|9 9 9 9 9 9 9 9 9 9 &1 1 1 1 1 1 1 1 1 1 &|9 9 9 9 9 9 9 9 9 9 &1 1 1 1 1 1 1 1 1 1 &|9 9 9 9 9 9 9 9 9 9 &1 1 1 1 1 1 1 1 1 1 &|9 9 9 9 9 9 9 9 9 9 &1 1 1 1 1 1 1 1 1 1 &|9 9 9 9 9 9 9 9 9 9 &ij> select a, c, b, e from testing;A |C |B |E -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------1 1 1 1 1 1 1 1 1 1 &|c c c c c c c c c c &|b b b b b b b b b b &|9 9 9 9 9 9 9 9 9 9 &1 1 1 1 1 1 1 1 1 1 &|c c c c c c c c c c &|b b b b b b b b b b &|9 9 9 9 9 9 9 9 9 9 &1 1 1 1 1 1 1 1 1 1 &|c c c c c c c c c c &|b b b b b b b b b b &|9 9 9 9 9 9
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -