本书为“十二五”普通高等教育本科规划教材、普通高等教育“十一五”规划教材。本书系统全面地阐述了数据库系统的基本理论、应用技术和设计方法;以SQL Server 2017数据库管理系统为技术案例和实验平台,具有较好的可操作性。为便于组织教学和实验,本书的最后一章为数据库课程的教学标准、实验标准和实验方案,供读者参考。本书概念清楚、重点突出、章节安排合理,每章附有丰富习题,重视上机实验环节。本书可作为高等院校学生学习数据库系统的教材,也可供计算机爱好者阅读。
SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.000635s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 1 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000371s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 2 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000344s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 3 ORDER BY `sort` DESC [ RunTime:0.000230s ]
SHOW FULL COLUMNS FROM `ls_nav` [ RunTime:0.000612s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 1 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000529s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 2 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000258s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 3 ORDER BY `sort` DESC [ RunTime:0.000225s ]
SHOW FULL COLUMNS FROM `ls_friendly_link` [ RunTime:0.000446s ]
SELECT * FROM `ls_friendly_link` WHERE `is_show` = 1 AND `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.000256s ]
SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.000472s ]
SELECT * FROM `ls_goods` WHERE `id` = 176889 AND `status` = 1 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `ls_goods` SET `click_count` = 104 , `update_time` = 1763279256 WHERE `id` = 176889 [ RunTime:0.000264s ]
SELECT `name`,`first_category_id`,`second_category_id` FROM `ls_goods` WHERE `id` = 176889 LIMIT 1 [ RunTime:0.000275s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 62 LIMIT 1 [ RunTime:0.000170s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 1 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000248s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 2 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000297s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 3 ORDER BY `sort` DESC [ RunTime:0.000219s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 1 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000317s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 2 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000191s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 3 ORDER BY `sort` DESC [ RunTime:0.000159s ]
SELECT * FROM `ls_friendly_link` WHERE `is_show` = 1 AND `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.000209s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000223s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 62 LIMIT 1 [ RunTime:0.000130s ]
SELECT * FROM `ls_goods` WHERE `del` = 0 AND `status` = 1 AND `create_time` <= 1763279196 ORDER BY `create_time` DESC LIMIT 5 [ RunTime:0.318437s ]