› 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
Mac
V2EX  ›  MySQL

脑袋卡住了,求一个查询语句的方法

  •  
  •   Mac · Jul 27, 2018 · 4048 views
    This topic created in 2994 days ago, the information mentioned may be changed or developed.
    CREATE TABLE `po` (
    	`id` INT(11) NOT NULL AUTO_INCREMENT,
    	`pono` VARCHAR(20) NOT NULL,
    	`etd` DATE NOT NULL,
    	`port` VARCHAR(20) NOT NULL,
    	PRIMARY KEY (`id`)
    )
    
    CREATE TABLE `detail` (
    	`id` INT(11) NOT NULL AUTO_INCREMENT,
    	`poid` INT(11) NOT NULL,
    	`cdno` VARCHAR(20) NOT NULL,
    	`qty` INT(11) NOT NULL DEFAULT '0',
    	PRIMARY KEY (`id`)
    )
    

    两个表,detail 是 po 的子集,detail.poid 关联 po.id 如何输出

    ║   ║ pono1 ║ pono2 ║ pono3 ║ pono4 ║

    ----------------------------------------

    ║ cdno1 ║ qty ║ qty ║ qty ║ qty ║

    ║ cdno2 ║ qty ║ qty ║ qty ║ qty ║

    ║ cdno3 ║ qty ║ qty ║ qty ║ qty ║

    2 replies  •  2018-07-27 09:53:45 +08:00
    sB3Z28DrQC0CkMMZ
        1
    sB3Z28DrQC0CkMMZ  
       Jul 27, 2018 via iPhone
    这个没有要求的话用笛卡尔积不就行了吗?
    stonezing
        2
    stonezing  
       Jul 27, 2018   ❤️ 1
    行转列?
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   3087 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 31ms · UTC 00:05 · PVG 08:05 · LAX 17:05 · JFK 20:05
    ♥ Do have faith in what you're doing.