› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
ditie
V2EX  ›  MySQL

请问 mysql5.7 怎么实现根据不同值的判断,来执行不同的 sql 查询语句(完全不同的表的那种)

  •  
  •   ditie · May 28, 2019 · 6091 views
    This topic created in 2677 days ago, the information mentioned may be changed or developed.

    我这么尝试写了下,但不行。百度了也没找到解决办法,求大佬们指点

    select * from CASE @变量 @ WHEN 0 THEN ( Select Statement ) WHEN 1 THEN ( Other Select Statement )
    WHEN 2 THEN ( Other Select Statement )
    END

    1 replies  •  2019-06-07 13:32:31 +08:00
    gavindexu
        1
    gavindexu  
       Jun 7, 2019 via iPhone
    emm ……
    我在想你是不是试试 select from a,b,c,d ?
    //
    CASE @变量 @
    WHEN 1 THEN a.xxx
    WHEN 2 THEN b.xxx
    WHEN 3 THEN c.xxx
    ELSE d.xxx
    END AS qry_value
    //
    但这样能不能出来 1 个结果…
    我还不确定🤣
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2359 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 26ms · UTC 10:52 · PVG 18:52 · LAX 03:52 · JFK 06:52
    ♥ Do have faith in what you're doing.