课程特色:1)数据库表,列,数据类型2)查询语句select语法3)插入语句insert语法4)删除语句delete语法5)修改语句update语法6)where子句,过滤数据7)NULL,空值解析8)分组group by 子句和多行函数9)order by 子句,按顺序查询数据10)having子句过滤分组...
SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.000847s ]
SELECT * FROM `fqi_school` WHERE `school_id` = '15675' AND `site_id` = 7 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000212s ]
SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000565s ]
SELECT * FROM `fqi_school_class` WHERE `school_id` = 15675 [ RunTime:0.000201s ]
SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000618s ]
SELECT * FROM `fqi_school_campus` WHERE `school_id` = 15675 [ RunTime:0.000198s ]
SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000668s ]
SELECT COUNT(*) AS think_count FROM `fqi_school_course` WHERE `school_id` = 15675 AND `site_id` = 7 AND `course_status` = 1 AND `school_status` = 1 [ RunTime:0.000312s ]
SELECT * FROM `fqi_school_course` WHERE `school_id` = 15675 AND `site_id` = 7 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 0,10 [ RunTime:0.000266s ]