用8251实现串行口异步通信，自发自收，波特率1200bps。采用查询方式发送与接收。从键盘输入发送字符。发送与接收的字符均在屏幕上显示。按esc键返回dos-Achieved with the 8251 serial asynchronous communication, spontaneous self-income, the baud rate 1200bps. Way to send and receive using queries. To send characters from the keyboard. Send and receive characters are displayed on the screen. Press esc key to return to dos
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001109s ]
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.075858s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001180s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001132s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000907s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003492s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000771s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003519s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.017715s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001215s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 233893 [ RunTime:0.018619s ]
