本书为“十二五”普通高等教育本科规划教材、普通高等教育“十一五”规划教材。本书系统全面地阐述了数据库系统的基本理论、应用技术和设计方法;以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.000330s ]
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.000329s ]
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.000253s ]
SHOW FULL COLUMNS FROM `ls_nav` [ RunTime:0.000497s ]
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.000263s ]
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.000209s ]
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.000202s ]
SHOW FULL COLUMNS FROM `ls_friendly_link` [ RunTime:0.000411s ]
SELECT * FROM `ls_friendly_link` WHERE `is_show` = 1 AND `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.000190s ]
SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.000380s ]
SELECT * FROM `ls_goods` WHERE `id` = 176889 AND `status` = 1 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `ls_goods` SET `click_count` = 118 , `update_time` = 1766203766 WHERE `id` = 176889 [ RunTime:0.000225s ]
SELECT `name`,`first_category_id`,`second_category_id` FROM `ls_goods` WHERE `id` = 176889 LIMIT 1 [ RunTime:0.000245s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 62 LIMIT 1 [ RunTime:0.000175s ]
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.000294s ]
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.000319s ]
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.000253s ]
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.000247s ]
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.000170s ]
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.000162s ]
SELECT * FROM `ls_friendly_link` WHERE `is_show` = 1 AND `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.000189s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000184s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 62 LIMIT 1 [ RunTime:0.000174s ]
SELECT * FROM `ls_goods` WHERE `del` = 0 AND `status` = 1 AND `create_time` <= 1766203706 ORDER BY `create_time` DESC LIMIT 5 [ RunTime:0.272728s ]