美文网首页
DataGrip: write multi sql

DataGrip: write multi sql

作者: developerAbble | 来源:发表于2018-05-28 11:50 被阅读3次

    we can use DataGrip to write Sqls in a window. Thats wonderful.

    for example:

    -- desc tbl_unit;
    -- select * from tbl_unit;
    
    # 每个区(高桥区)下面的所有街道信息:
    /*
    select
      id,
      name,
      manager_user,
      address,
      gds1
    from tbl_unit
    where fatherid in (select id
                       from tbl_unit
                       where del = 0 and fatherid = 2)
          and state = '正常营业'
          and area_id = 1;
          */
    

    When we use it ,we can write everything. When we don't use it ,we can make an annotation by -- # or /**/

    注:代码上面的"正常营业"并不是笔者设计的,笔者后来看到这汉字,实在无法接受。

    相关文章

      网友评论

          本文标题:DataGrip: write multi sql

          本文链接:https://www.haomeiwen.com/subject/sjowjftx.html