进入墨天轮openGauss实训环境
Welcome to 墨天轮.
This is Web Terminal of modb.pro; Good Good Study, Day Day Up.
root@modb:~#
root@modb:~# su - omm
omm@modb:~$ gsql -r
gsql ((openGauss 2.0.0 build 78689da9) compiled at 2021-03-31 21:03:52 commit 0 last mr )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type “help” for help.
编写福字SQL语句
create table hhj (hhj varchar(100)); insert into hhj values( '....................]OOOO\]`...................................' ); insert into hhj values( ' . =黄黄黄黄黄黄黄黄黄黄黄\..... . ............. ..' ); insert into hhj values( ' ...黄黄黄黄黄黄黄黄黄黄黄黄O.... .. ...,]OOO\`... ..' ); insert into hhj values( ' ...O黄黄黄黄黄黄黄黄黄黄黄黄^.. ......,O黄黄黄黄黄黄黄黄黄^.. ..' ); insert into hhj values( ' ...O黄黄黄黄黄黄黄黄黄黄黄黄\......,黄黄黄黄黄黄黄黄黄黄黄黄黄... ..' ); insert into hhj values( ' ..,黄黄黄黄黄黄黄黄黄黄黄黄黄O...,/黄黄黄黄黄黄黄黄黄黄黄黄黄黄^... ..' ); insert into hhj values( ' ..O黄黄黄O[O黄黄黄黄黄黄黄/.,黄黄黄黄O[....黄黄黄黄黄黄O.... ..' ); insert into hhj values( ' ....,O/[......\黄黄O/`,黄黄黄/.......O黄黄黄黄黄黄` ..' ); insert into hhj values( ' .......... .......,黄黄黄`.......,黄黄黄黄黄黄黄^. ..' ); insert into hhj values( '........ ........,O黄黄`......../黄黄黄黄黄黄黄黄^..... ..' ); insert into hhj values( '....]]`. .......=黄黄/........,黄黄黄黄黄黄黄黄黄黄黄黄黄\`. ..' ); insert into hhj values( '..=黄黄黄黄黄\`....... .,/黄黄^..=黄黄^.. ../黄黄黄黄黄黄黄黄黄黄黄黄黄黄O.. ..' ); insert into hhj values( '..黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄...黄黄`... ..=黄黄黄黄黄黄黄黄黄黄黄黄黄/... ..' ); insert into hhj values( '.=黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄`..=O. ...../黄黄黄黄黄黄黄黄黄黄黄黄黄O.. . ..' ); insert into hhj values( '.O黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄O`...=.. ...,黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄O`.. ..' ); insert into hhj values( '.O黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄/ ..=O黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄\.... ..' ); insert into hhj values( '.=黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄/. ...........[\黄黄黄黄黄黄黄黄黄黄黄黄^.. ..' ); insert into hhj values( '...[[[[[\黄黄黄黄黄黄黄黄O............................,O黄黄黄黄黄黄黄黄黄黄\.. .' ); insert into hhj values( '. ....../黄黄黄黄黄黄黄黄`....../`...,/黄黄黄黄黄黄\`...,/\]..,黄黄黄黄黄黄黄黄黄黄\...' ); insert into hhj values( '.....]O黄黄黄黄黄黄黄黄黄黄......O^.,O黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄`..O黄黄黄黄黄黄黄黄黄^..' ); insert into hhj values( '..,O黄黄黄黄黄黄黄黄黄黄黄黄黄....,黄^.O黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄^...黄黄黄黄黄黄黄黄黄O..' ); insert into hhj values( '.,黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄^..=黄O.O黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄O.....=黄黄黄黄黄黄黄黄黄^.' ); insert into hhj values( '.=黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄O]O黄黄.=黄黄黄`....\黄黄黄黄黄黄黄黄黄黄黄黄黄`....=黄黄黄黄黄黄黄黄黄^.' ); insert into hhj values( '.=黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄^.O黄黄`......O黄黄黄黄黄黄黄黄黄黄黄黄O....=黄黄黄黄黄黄黄黄黄^.' ); insert into hhj values( '..O黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄O..黄黄O......O黄黄黄黄黄黄黄黄黄黄黄黄黄黄....=黄黄黄黄黄黄黄黄黄^.' ); insert into hhj values( '....[[`..,黄黄黄黄黄黄黄黄黄黄^..黄黄O....=黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄....O黄黄黄黄黄黄黄黄黄..' ); insert into hhj values( '..........=黄黄黄黄黄黄黄黄黄^..O黄黄^..O黄黄黄黄/[`...\黄黄黄黄黄O...=黄黄黄黄黄黄黄黄黄^..' ); insert into hhj values( ' ..,黄黄黄黄黄黄黄黄黄\..=黄黄黄..... =黄黄黄黄O...,黄黄黄黄黄黄黄黄黄/...' ); insert into hhj values( ' ...O黄黄黄黄黄黄黄黄O...\黄黄黄`... ,黄黄[..../黄黄黄黄黄黄黄黄黄O....' ); insert into hhj values( ' ...=黄黄黄黄黄黄黄黄O....\黄黄黄黄`........... .../黄黄黄黄黄黄黄黄黄黄/.. ..' ); insert into hhj values( ' ....黄黄黄黄黄黄黄黄^.....=黄黄黄黄黄O]........]/黄黄黄黄黄黄黄黄黄黄黄黄`... ..' ); insert into hhj values( ' ,\黄黄黄O[. ....\黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄O`. ..' ); insert into hhj values( ' ........ ......,\黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄黄O[..... ..' ); insert into hhj values( ' ' ); create table fu(fu varchar(100)); insert into fu values( '....................]OOOO\]`...................................' ); insert into fu values( ' . =福福福福福福福福福福福\..... . ............. ..' ); insert into fu values( ' ...福福福福福福福福福福福福O.... .. ...,]OOO\`... ..' ); insert into fu values( ' ...O福福福福福福福福福福福福^.. ......,O福福福福福福福福福^.. ..' ); insert into fu values( ' ...O福福福福福福福福福福福福\......,福福福福福福福福福福福福福... ..' ); insert into fu values( ' ..,福福福福福福福福福福福福福O...,/福福福福福福福福福福福福福福^... ..' ); insert into fu values( ' ..O福福福O[O福福福福福福福/.,福福福福O[....福福福福福福O.... ..' ); insert into fu values( ' ....,O/[......\福福O/`,福福福/.......O福福福福福福` ..' ); insert into fu values( ' .......... .......,福福福`.......,福福福福福福福^. ..' ); insert into fu values( '........ ........,O福福`......../福福福福福福福福^..... ..' ); insert into fu values( '....]]`. .......=福福/........,福福福福福福福福福福福福福\`. ..' ); insert into fu values( '..=福福福福福\`....... .,/福福^..=福福^.. ../福福福福福福福福福福福福福福O.. ..' ); insert into fu values( '..福福福福福福福福福福福福福福福福福福福福福...福福`... ..=福福福福福福福福福福福福福/... ..' ); insert into fu values( '.=福福福福福福福福福福福福福福福福福福福福`..=O. ...../福福福福福福福福福福福福福O.. . ..' ); insert into fu values( '.O福福福福福福福福福福福福福福福福福福O`...=.. ...,福福福福福福福福福福福福福福福福O`.. ..' ); insert into fu values( '.O福福福福福福福福福福福福福福福福福/ ..=O福福福福福福福福福福福福福福福福福福福\.... ..' ); insert into fu values( '.=福福福福福福福福福福福福福福福福/. ...........[\福福福福福福福福福福福福^.. ..' ); insert into fu values( '...[[[[[\福福福福福福福福O............................,O福福福福福福福福福福\.. .' ); insert into fu values( '. ....../福福福福福福福福`....../`...,/福福福福福福\`...,/\]..,福福福福福福福福福福\...' ); insert into fu values( '.....]O福福福福福福福福福福......O^.,O福福福福福福福福福福福福福福福福福福福`..O福福福福福福福福福^..' ); insert into fu values( '..,O福福福福福福福福福福福福福....,福^.O福福福福福福福福福福福福福福福福福福福福福^...福福福福福福福福福O..' ); insert into fu values( '.,福福福福福福福福福福福福福福福^..=福O.O福福福福福福福福福福福福福福福福福福福福O.....=福福福福福福福福福^.' ); insert into fu values( '.=福福福福福福福福福福福福福福福O]O福福.=福福福`....\福福福福福福福福福福福福福`....=福福福福福福福福福^.' ); insert into fu values( '.=福福福福福福福福福福福福福福福福福福福^.O福福`......O福福福福福福福福福福福福O....=福福福福福福福福福^.' ); insert into fu values( '..O福福福福福福福福福福福福福福福福福O..福福O......O福福福福福福福福福福福福福福....=福福福福福福福福福^.' ); insert into fu values( '....[[`..,福福福福福福福福福福^..福福O....=福福福福福福福福福福福福福福福福....O福福福福福福福福福..' ); insert into fu values( '..........=福福福福福福福福福^..O福福^..O福福福福/[`...\福福福福福O...=福福福福福福福福福^..' ); insert into fu values( ' ..,福福福福福福福福福\..=福福福..... =福福福福O...,福福福福福福福福福/...' ); insert into fu values( ' ...O福福福福福福福福O...\福福福`... ,福福[..../福福福福福福福福福O....' ); insert into fu values( ' ...=福福福福福福福福O....\福福福福`........... .../福福福福福福福福福福/.. ..' ); insert into fu values( ' ....福福福福福福福福^.....=福福福福福O]........]/福福福福福福福福福福福福`... ..' ); insert into fu values( ' ,\福福福O[. ....\福福福福福福福福福福福福福福福福福福福福福福福福O`. ..' ); insert into fu values( ' ........ ......,\福福福福福福福福福福福福福福福福福O[..... ..' ); insert into fu values( ' ' );
复制
两个福字效果如下
omm=# select * from hhj;
omm=# select * from fu;
最后修改时间:2022-01-14 15:17:18
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。
评论
您已成功参加本次SQL“祝福”大赛,将有机会角逐各项大奖!
中奖名单将于1月21日公布,请持续关注。
3年前

评论
Good Good Study, Day Day Up.
3年前

评论