第7章 查询数据

7.1 基本查询语句

# Host: 127.0.0.1  (Version: 5.7.20)
# Date: 2023-01-09 12:17:58
# Generator: MySQL-Front 5.3  (Build 4.269)

/*!40101 SET NAMES gb2312 */;

#
# Structure for table "course"
#

DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(24) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

#
# Data for table "course"
#

INSERT INTO `course` VALUES (1,'111灰色多少度'),(9,'801# 深灰 -10床（1186条）'),(10,'801#灰-12床（910）'),(11,'90000蓝色');

#
# Structure for table "kuanshi"
#

DROP TABLE IF EXISTS `kuanshi`;
CREATE TABLE `kuanshi` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='款式';

#
# Data for table "kuanshi"
#


#
# Structure for table "price"
#

DROP TABLE IF EXISTS `price`;
CREATE TABLE `price` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `jname` varchar(24) DEFAULT NULL,
  `gname` varchar(255) DEFAULT NULL,
  `price` double(10,2) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8;

#
# Data for table "price"
#

INSERT INTO `price` VALUES (40,'801','包后浪：双片',0.12),(41,'801','接前幅短',0.10),(42,'801','接前幅长',0.12),(43,'801','接前幅中线',0.12),(44,'801','拉裤头橡筋',0.20),(45,'801','六角袋+商标',0.70),(46,'801','六线侧骨底浪',0.40),(47,'801','前袋(801)',0.85),(48,'801','前圆章',0.10),(49,'801','上裤头橡筋',1.00),(50,'801','双针后浪(801)',0.10),(51,'801','压前幅短',0.10),(52,'801','压前幅长',0.12),(53,'801','压前幅中线',0.12),(54,'802','后袋定位（802）',0.08),(55,'20853','包裤头橡筋',1.50),(56,'20853','打枣x21',0.42),(61,'我是真的','我是真的不知道',12.00),(62,'111灰色多少度','我是个头了个好',122.00),(63,'111灰色多少度','上裤头香锦',0.15),(64,'801# 深灰 -10床（1186条）','三线X6',0.18),(65,'90000蓝色','前袋',0.85),(66,'90000蓝色','前圆章',0.10),(67,'801# 深灰 -10床（1186条）','贴六角袋+商标',0.70),(68,'801# 深灰 -10床（1186条）','包前浪',0.10),(69,'90000蓝色','假利双线',0.20),(70,'801# 深灰 -10床（1186条）','接前幅短',0.10),(71,'801# 深灰 -10床（1186条）','压前幅短',0.10),(72,'801# 深灰 -10床（1186条）','接前幅长',0.12),(73,'801# 深灰 -10床（1186条）','压前幅长',0.12),(74,'801# 深灰 -10床（1186条）','接前幅中线',0.12),(75,'801# 深灰 -10床（1186条）','压前幅中线',0.12),(76,'801# 深灰 -10床（1186条）','包后浪：双片',0.12),(77,'801# 深灰 -10床（1186条）','平车合后浪+压线',0.14),(78,'801# 深灰 -10床（1186条）','双针后浪',0.10),(79,'801# 深灰 -10床（1186条）','六线侧骨底浪',0.40),(80,'801# 深灰 -10床（1186条）','双针侧骨',0.20),(81,'801# 深灰 -10床（1186条）','上裤头橡筋',1.00),(82,'801# 深灰 -10床（1186条）','拉裤头橡筋',0.20),(83,'801# 深灰 -10床（1186条）','包裤头+半圆',0.35),(84,'801# 深灰 -10床（1186条）','拉裤耳X1',0.01),(85,'801# 深灰 -10床（1186条）','打组X10',0.20),(86,'801# 深灰 -10床（1186条）','后幅定位',0.06),(87,'801# 深灰 -10床（1186条）','后袋定位',0.06),(88,'801# 深灰 -10床（1186条）','返裤+扎',0.06);

#
# Structure for table "score"
#

DROP TABLE IF EXISTS `score`;
CREATE TABLE `score` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT NULL,
  `nid` varchar(248) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `jname` varchar(255) DEFAULT NULL,
  `gname` varchar(255)