thomaswang
V2EX  ›  问与答

sql 问题

  •  
  •   thomaswang · Jun 26, 2018 · 1527 views
    This topic created in 2959 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   ·   6112 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 31ms · UTC 03:12 · PVG 11:12 · LAX 20:12 · JFK 23:12
    ♥ Do have faith in what you're doing.