This file contains the material presented as the first Embedded MATLAB webinar on the MathWorks web site on September 13, 2007.
It contains the PDF version of presentation slides and all necessary demonstration files (including MATLAB M-files and Simulink models).
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001115s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.102335s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000910s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001097s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000948s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004081s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001184s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003889s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.021820s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001317s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 503196 [ RunTime:0.022538s ]