mysql分组查询 2 => array(0,1,2),这个字段可以忽略掉 , 只是想按b字段来分组查询~ 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 ---- 表的结构 `goods`CREATE TABLE IF NOT EXISTS `goods` ( `goods_id` int(11) NOT NULL AUTO_INCREMENT, `cat_id` int(11) NOT NULL, `sn` varchar(60) NOT NULL, `name` varchar(60) NOT NULL, `desc` varchar(255) NOT NULL, `link` varchar(300) NOT NULL, `sort` tinyint(3) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `thumb` varchar(300) NOT NULL, `img` varchar(300) NOT NULL, PRIMARY KEY (`goods_id`), UNIQUE KEY `goods_id` (`goods_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;---- 转存表中的数据 `goods`--INSERT INTO `goods` (`goods_id`, `cat_id`, `sn`, `name`, `desc`, `link`, `sort`, `status`, `thumb`, `img`) VALUES(1, 1, 'P14012', 'x', 'x', '', 1, 1, '', ''),(2, 2, 'P15013', 'b', 'b', '', 1, 1, '', ''),(3, 3, 'P17013', 'c', 'c', '', 1, 1, '', ''),(4, 1, 'P14014', 'd', 'd', '', 2, 1, '', ''),(5, 1, 'P14015', 'd', 'd', '', 3, 1, '', ''),(6, 1, 'P14017', 'd', 'd', '', 4, 1, '', ''),(7, 2, 'P15014', 'd', 'd', '', 2, 1, '', ''),(8, 3, 'P15014', 'z', 'z', '', 3, 1, '', ''),(9, 2, 'P15014', 'z', 'z', '', 3, 1, '', ''),(10, 3, 'P17016', 'z', 'z', '', 2, 1, '', '');-- ------------------------------------------------------------ 表的结构 `goods_cat`CREATE TABLE IF NOT EXISTS `goods_cat` ( `cat_id` int(11) NOT NULL AUTO_INCREMENT, `pid` int(11) NOT NULL, `type` varchar(20) NOT NULL, `name` varchar(50) NOT NULL, `desc` varchar(255) NOT NULL, `sort` tinyint(3) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`cat_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;-- 转存表中的数据 `goods_cat`INSERT INTO `goods_cat` (`cat_id`, `pid`, `type`, `name`, `desc`, `sort`, `status`) VALUES(1, 0, 'jiezhi', '戒指', '戒指系列', 1, 1),(2, 0, 'shouzhuo', '手镯', '手镯系列', 2, 1),(3, 0, 'erhuan', '耳环', '耳环系列', 3, 1),(4, 0, 'shoulian', '手链', '手链', 4, 1);结果 array(4) { [0] => array(2) { ["cat"] => array(7) { ["cat_id"] => string(1) "1" ["pid"] => string(1) "0" ["type"] => string(6) "jiezhi" ["name"] => string(6) "" ["desc"] => string(12) "" ["sort"] => string(1) "1" ["status"] => string(1) "1" } ["goods"] => array(4) { [0] => array(10) { ["goods_id"] => string(1) "1" ["cat_id"] => string(1) "1" ["sn"] => string(6) "P14012" ["name"] => string(6) "" ["desc"] => string(6) "" ["link"] => string(0) "" ["sort"] => string(1) "1" ["status"] => string(1) "1" ["thumb"] => string(0) "" ["img"] => string(0) "" } [1] => array(10) { ["goods_id"] => string(1) "4" ["cat_id"] => string(1) "1" ["sn"] => string(6) "P14014" ["name"] => string(6) "" ["desc"] => string(6) "" ["link"] => string(0) "" ["sort"] => string(1) "2" ["status"] => string(1) "1" ["thumb"] => string(0) "" ["img"] => string(0) "" } [2] => array(10) { ["goods_id"] => string(1) "5" ["cat_id"] => string(1) "1" ["sn"] => string(6) "P14015" ["name"] => string(6) "" ["desc"] => string(6) "" ["link"] => string(0) "" ["sort"] => string(1) "3" ["status"] => string(1) "1" ["thumb"] => string(0) "" ["img"] => string(0) "" } [3] => array(10) { ["goods_id"] => string(1) "6" ["cat_id"] => string(1) "1" ["sn"] => string(6) "P14017" ["name"] => string(6) "" ["desc"] => string(6) "" ["link"] => string(0) "" ["sort"] => string(1) "4" ["status"] => string(1) "1" ["thumb"] => string(0) "" ["img"] => string(0) "" } } } [1] => array(2) { ["cat"] => array(7) { ["cat_id"] => string(1) "2" ["pid"] => string(1) "0" ["type"] => string(8) "shouzhuo" ["name"] => string(6) "" ["desc"] => string(12) "" ["sort"] => string(1) "2" ["status"] => string(1) "1" } ["goods"] => array(3) { [0] => array(10) { ["goods_id"] => string(1) "2" ["cat_id"] => string(1) "2" ["sn"] => string(6) "P15013" ["name"] => string(7) "" ["desc"] => string(7) "" ["link"] => string(0) "" ["sort"] => string(1) "1" ["status"] => string(1) "1" ["thumb"] => string(0) "" ["img"] => string(0) "" } [1] => array(10) { ["goods_id"] => string(1) "7" ["cat_id"] => string(1) "2" ["sn"] => string(6) "P15014" ["name"] => string(6) "" ["desc"] => string(6) "" ["link"] => string(0) "" ["sort"] => string(1) "2" ["status"] => string(1) "1" ["thumb"] => string(0) "" ["img"] => string(0) "" } [2] => array(10) { ["goods_id"] => string(1) "9" ["cat_id"] => string(1) "2" ["sn"] => string(6) "P15014" ["name"] => string(6) "" ["desc"] => string(6) "" ["link"] => string(0) "" ["sort"] => string(1) "3" ["status"] => string(1) "1" ["thumb"] => string(0) "" ["img"] => string(0) "" } } } [2] => array(2) { ["cat"] => array(7) { ["cat_id"] => string(1) "3" ["pid"] => string(1) "0" ["type"] => string(6) "erhuan" ["name"] => string(6) "" ["desc"] => string(12) "" ["sort"] => string(1) "3" ["status"] => string(1) "1" } ["goods"] => array(3) { [0] => array(10) { ["goods_id"] => string(1) "3" ["cat_id"] => string(1) "3" ["sn"] => string(6) "P17013" ["name"] => string(12) "" ["desc"] => string(12) "" ["link"] => string(0) "" ["sort"] => string(1) "1" ["status"] => string(1) "1" ["thumb"] => string(0) "" ["img"] => string(0) "" } [1] => array(10) { ["goods_id"] => string(1) "8" ["cat_id"] => string(1) "3" ["sn"] => string(6) "P15014" ["name"] => string(7) "" ["desc"] => string(7) "" ["link"] => string(0) "" ["sort"] => string(1) "3" ["status"] => string(1) "1" ["thumb"] => string(0) "" ["img"] => string(0) "" } [2] => array(10) { ["goods_id"] => string(2) "10" ["cat_id"] => string(1) "3" ["sn"] => string(6) "P17016" ["name"] => string(6) "" ["desc"] => string(6) "" ["link"] => string(0) "" ["sort"] => string(1) "2" ["status"] => string(1) "1" ["thumb"] => string(0) "" ["img"] => string(0) "" } } } [3] => array(2) { ["cat"] => array(7) { ["cat_id"] => string(1) "4" ["pid"] => string(1) "0" ["type"] => string(8) "shoulian" ["name"] => string(6) "" ["desc"] => string(6) "" ["sort"] => string(1) "4" ["status"] => string(1) "1" } ["goods"] => NULL }}php循环出来了(一共查询5次)~ 但我不知道mysql能不能查出来 ~ 如果 mysql能一次搞定 就最好了 中二了~ 好好进修MySQL mysql中同一服务器,要从一个数据库里复制一个表到另一个数据库,sql语句怎么写? 列出数据库所有的存储过程 字条颜色怎么存储? mysql编码问题 有没有sql语句能够判断某个表是否存在? 这个功能怎么实现,各位给看看 渴望回复 NOT NULL问题 连接远程mysql出错 Mysql 5.7 创建的用户只能24小时有效 请教一条sql语句 问个多表查询语句
--
-- 表的结构 `goods`
CREATE TABLE IF NOT EXISTS `goods` (
`goods_id` int(11) NOT NULL AUTO_INCREMENT,
`cat_id` int(11) NOT NULL,
`sn` varchar(60) NOT NULL,
`name` varchar(60) NOT NULL,
`desc` varchar(255) NOT NULL,
`link` varchar(300) NOT NULL,
`sort` tinyint(3) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '1',
`thumb` varchar(300) NOT NULL,
`img` varchar(300) NOT NULL,
PRIMARY KEY (`goods_id`),
UNIQUE KEY `goods_id` (`goods_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- 转存表中的数据 `goods`
--
INSERT INTO `goods` (`goods_id`, `cat_id`, `sn`, `name`, `desc`, `link`, `sort`, `status`, `thumb`, `img`) VALUES
(1, 1, 'P14012', 'x', 'x', '', 1, 1, '', ''),
(2, 2, 'P15013', 'b', 'b', '', 1, 1, '', ''),
(3, 3, 'P17013', 'c', 'c', '', 1, 1, '', ''),
(4, 1, 'P14014', 'd', 'd', '', 2, 1, '', ''),
(5, 1, 'P14015', 'd', 'd', '', 3, 1, '', ''),
(6, 1, 'P14017', 'd', 'd', '', 4, 1, '', ''),
(7, 2, 'P15014', 'd', 'd', '', 2, 1, '', ''),
(8, 3, 'P15014', 'z', 'z', '', 3, 1, '', ''),
(9, 2, 'P15014', 'z', 'z', '', 3, 1, '', ''),
(10, 3, 'P17016', 'z', 'z', '', 2, 1, '', '');-- ----------------------------------------------------------
-- 表的结构 `goods_cat`
CREATE TABLE IF NOT EXISTS `goods_cat` (
`cat_id` int(11) NOT NULL AUTO_INCREMENT,
`pid` int(11) NOT NULL,
`type` varchar(20) NOT NULL,
`name` varchar(50) NOT NULL,
`desc` varchar(255) NOT NULL,
`sort` tinyint(3) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`cat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;-- 转存表中的数据 `goods_cat`INSERT INTO `goods_cat` (`cat_id`, `pid`, `type`, `name`, `desc`, `sort`, `status`) VALUES
(1, 0, 'jiezhi', '戒指', '戒指系列', 1, 1),
(2, 0, 'shouzhuo', '手镯', '手镯系列', 2, 1),
(3, 0, 'erhuan', '耳环', '耳环系列', 3, 1),
(4, 0, 'shoulian', '手链', '手链', 4, 1);
结果 array(4) {
[0] => array(2) {
["cat"] => array(7) {
["cat_id"] => string(1) "1"
["pid"] => string(1) "0"
["type"] => string(6) "jiezhi"
["name"] => string(6) ""
["desc"] => string(12) ""
["sort"] => string(1) "1"
["status"] => string(1) "1"
}
["goods"] => array(4) {
[0] => array(10) {
["goods_id"] => string(1) "1"
["cat_id"] => string(1) "1"
["sn"] => string(6) "P14012"
["name"] => string(6) ""
["desc"] => string(6) ""
["link"] => string(0) ""
["sort"] => string(1) "1"
["status"] => string(1) "1"
["thumb"] => string(0) ""
["img"] => string(0) ""
}
[1] => array(10) {
["goods_id"] => string(1) "4"
["cat_id"] => string(1) "1"
["sn"] => string(6) "P14014"
["name"] => string(6) ""
["desc"] => string(6) ""
["link"] => string(0) ""
["sort"] => string(1) "2"
["status"] => string(1) "1"
["thumb"] => string(0) ""
["img"] => string(0) ""
}
[2] => array(10) {
["goods_id"] => string(1) "5"
["cat_id"] => string(1) "1"
["sn"] => string(6) "P14015"
["name"] => string(6) ""
["desc"] => string(6) ""
["link"] => string(0) ""
["sort"] => string(1) "3"
["status"] => string(1) "1"
["thumb"] => string(0) ""
["img"] => string(0) ""
}
[3] => array(10) {
["goods_id"] => string(1) "6"
["cat_id"] => string(1) "1"
["sn"] => string(6) "P14017"
["name"] => string(6) ""
["desc"] => string(6) ""
["link"] => string(0) ""
["sort"] => string(1) "4"
["status"] => string(1) "1"
["thumb"] => string(0) ""
["img"] => string(0) ""
}
}
}
[1] => array(2) {
["cat"] => array(7) {
["cat_id"] => string(1) "2"
["pid"] => string(1) "0"
["type"] => string(8) "shouzhuo"
["name"] => string(6) ""
["desc"] => string(12) ""
["sort"] => string(1) "2"
["status"] => string(1) "1"
}
["goods"] => array(3) {
[0] => array(10) {
["goods_id"] => string(1) "2"
["cat_id"] => string(1) "2"
["sn"] => string(6) "P15013"
["name"] => string(7) ""
["desc"] => string(7) ""
["link"] => string(0) ""
["sort"] => string(1) "1"
["status"] => string(1) "1"
["thumb"] => string(0) ""
["img"] => string(0) ""
}
[1] => array(10) {
["goods_id"] => string(1) "7"
["cat_id"] => string(1) "2"
["sn"] => string(6) "P15014"
["name"] => string(6) ""
["desc"] => string(6) ""
["link"] => string(0) ""
["sort"] => string(1) "2"
["status"] => string(1) "1"
["thumb"] => string(0) ""
["img"] => string(0) ""
}
[2] => array(10) {
["goods_id"] => string(1) "9"
["cat_id"] => string(1) "2"
["sn"] => string(6) "P15014"
["name"] => string(6) ""
["desc"] => string(6) ""
["link"] => string(0) ""
["sort"] => string(1) "3"
["status"] => string(1) "1"
["thumb"] => string(0) ""
["img"] => string(0) ""
}
}
}
[2] => array(2) {
["cat"] => array(7) {
["cat_id"] => string(1) "3"
["pid"] => string(1) "0"
["type"] => string(6) "erhuan"
["name"] => string(6) ""
["desc"] => string(12) ""
["sort"] => string(1) "3"
["status"] => string(1) "1"
}
["goods"] => array(3) {
[0] => array(10) {
["goods_id"] => string(1) "3"
["cat_id"] => string(1) "3"
["sn"] => string(6) "P17013"
["name"] => string(12) ""
["desc"] => string(12) ""
["link"] => string(0) ""
["sort"] => string(1) "1"
["status"] => string(1) "1"
["thumb"] => string(0) ""
["img"] => string(0) ""
}
[1] => array(10) {
["goods_id"] => string(1) "8"
["cat_id"] => string(1) "3"
["sn"] => string(6) "P15014"
["name"] => string(7) ""
["desc"] => string(7) ""
["link"] => string(0) ""
["sort"] => string(1) "3"
["status"] => string(1) "1"
["thumb"] => string(0) ""
["img"] => string(0) ""
}
[2] => array(10) {
["goods_id"] => string(2) "10"
["cat_id"] => string(1) "3"
["sn"] => string(6) "P17016"
["name"] => string(6) ""
["desc"] => string(6) ""
["link"] => string(0) ""
["sort"] => string(1) "2"
["status"] => string(1) "1"
["thumb"] => string(0) ""
["img"] => string(0) ""
}
}
}
[3] => array(2) {
["cat"] => array(7) {
["cat_id"] => string(1) "4"
["pid"] => string(1) "0"
["type"] => string(8) "shoulian"
["name"] => string(6) ""
["desc"] => string(6) ""
["sort"] => string(1) "4"
["status"] => string(1) "1"
}
["goods"] => NULL
}
}
php循环出来了(一共查询5次)~ 但我不知道mysql能不能查出来 ~ 如果 mysql能一次搞定 就最好了