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 · 3730 views
    This topic created in 2849 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
    drlalll
        1
    drlalll  
       Jul 27, 2018 via iPhone
    这个没有要求的话用笛卡尔积不就行了吗?
    stonezing
        2
    stonezing  
       Jul 27, 2018   ❤️ 1
    行转列?
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   992 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 47ms · UTC 19:17 · PVG 03:17 · LAX 12:17 · JFK 15:17
    ♥ Do have faith in what you're doing.