Home Sign Up Sign In
› 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
Advertisement
coolicer
V2EX  ›  MySQL

MYSQL 存储过程怎么连接多个条件

  •   
  •   coolicer · May 20, 2014 · 4896 views
    This topic created in 4513 days ago, the information mentioned may be changed or developed.
    类似这种
    var query = $scope.user_name ?　"AND user_name='+USER_NAME+"'"："";
    ___query += $scope.phone ? "AND phone='+PHONE+"'": "";
    ___.....

    存储过程听得多，第一次写，不知道怎么合并

    **后端已死系列2
    Supplement 1  ·  May 20, 2014
    已解决
  • user
  • scope
  • query
    3 replies  •  2014-05-20 09:48:13 +08:00
    tobyzw
        1
    tobyzw  
       May 20, 2014
    直接这样调用存储过程合适吗？
    coolicer
        2
    coolicer  
    OP
       May 20, 2014
    @tobyzw 内部系统，而且名字还有处理的，就算能调用，只能用当前这一个。
    ioth
        3
    ioth  
       May 20, 2014
    合并啥
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2674 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 25ms · UTC 06:20 · PVG 14:20 · LAX 23:20 · JFK 02:20
    ♥ Do have faith in what you're doing.