longcolumn.out

来自「derby database source code.good for you.」· OUT 代码 · 共 531 行 · 第 1/5 页

OUT
531
字号
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 + =
减小字号Ctrl + -
显示快捷键?