thomaswang
V2EX  ›  问与答

sql 问题

  •  
  •   thomaswang · Jun 26, 2018 · 1392 views
    This topic created in 2903 days ago, the information mentioned may be changed or developed.
    +-------------+---------+
    | 列名         | 类型     |
    +-------------+---------+
    | PersonId    | int     |
    | FirstName   | varchar |
    | LastName    | varchar |
    +-------------+---------+
    
    按名字查询用户,不存在返回 null, 这个 sql 咋写
    
    1 replies    2018-06-26 22:28:54 +08:00
    edk24
        1
    edk24  
       Jun 26, 2018
    在你的业务逻辑中写, 如果数据库查询结果为 null. 为它设定应该"默认结果"并返回 /输出
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   3596 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 29ms · UTC 04:47 · PVG 12:47 · LAX 21:47 · JFK 00:47
    ♥ Do have faith in what you're doing.