练涛
摘要: 自身连接无限分类数据表设计:CREATE TABLE tdb_goods_types ( type_id SMALLINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, type_name VARCHAR(20) N... 阅读全文
posted @ 2018-04-23 23:29 练涛 阅读(438) 评论(0) 推荐(0) 编辑
摘要: 多表连接三表连接demo: SELECT goods_id,goods_name,cate_name,brand_name,goods_price FROM tdb_goods AS g INNER JOIN tdb_goods_cates AS c ON... 阅读全文
posted @ 2018-04-23 22:08 练涛 阅读(186) 评论(0) 推荐(0) 编辑