mysql>create book(
->id varchar(20) not null,g
->
ÒÔÉÏÊÇÔÚmysqlÃüÁîÐÐÀïµÄ²Ù×÷
ÔÚÉÏÃæÖÐÎÒÔÚµ¹ÊýµÚ¶þÐжà´òÁËÒ»¸ö×ÖĸgÈ»ºó°´Á˻سµ¼ü£¬ÇëÎÊ´Óµ¹ÊýµÚÒ»ÐÐÔõô»Øµ½µ¹Êýÿ¶þÐнøÐиü¸Ä°¡£¿
\c Â𣬼Dz»ÇåÁË£¬½¨ÒéÏÈдºÃsql½Å±¾Îļþ£¬È»ºóÌá½»Ö´ÐÐ
ÔÚmysqlÖÐÊäÈë¡°£ ......
´úÂëÈçÏÂÇë¸÷λָÕýÒ»ÏÂÄÄÀï³ö´í£¬ÒªÔõô¸Ä£¬Ð»Ð» <?php
header("Content-type: text/vnd.wap.wml;charset=gb2312 \n");
echo(" <?xml version=\"1.0\" encoding=\"gb2312\"?>\n");
echo(" <!DOCTYPE wml PUBLIC \"-//WAPFORUM/ ......
CREATE TRIGGER t_insertonlineuser_before_insert
BEFORE INSERT ON online_user_tb
FOR EACH ROW
BEGIN
//α´úÂë
if exists (select 1 from online_user_tb) then
update online_user_tb;
else
insert online_us ......
SQL code:
select case (select count(*) from pcardfull where uid=9) as t when t > 0 then (select * from pcardacct) else (select * from pcardfull) end
ÎÒÏëÅжÏÒ»ÌõsqlÓï¾äµÄ½á¹ûÈ»ºó¸ù¾Ý½á¹ûÖ´ÐÐÆäËû²»Í¬µÄsqlÓï¾ä
Èý¸ö±í²»Ò»¶¨ÓйØÏµµÄ£¬Ö»ÊÇͨ¹ýµÚÒ»¸ösqlÖ´Ðнá¹ûÈ¥Ö´ÐÐÆäËûµÄÓï¾ä£¬²»Ïëͨ¹ý ......
ÓÐÈý¸ö±íÁªÈ¡£¬user_group.*, user.*, radacct.* È¡20Ìõ
Ìõ¼þ£ºradacct±íÀïֻȡһÌõ¼Ç¼£¨Óëuser±íµÄµÇ¼ÃûÏàͬµÄÒ»Ìõ×îеģ©
$sortby .= ($this->order != "") ? " ORDER BY radacct.AcctStartTime ".$this->order : ""
$where.=" ORDER BY radacct ......
³õ´Î°²×°µÄʱºòûÎÊÌ⣬µ«ÊÇÒ»²»Ð¡ÐÄÖØ×°ÏµÍ³ÁË£¬Ôٴΰ²×°MySQLµÄʱºò£¬µ½start serviceµÄʱºò¾Í²»ÐÐÁË£¬°²×°²»³É¹¦£¡
ÎҰѰ²×°ÎļþʲôµÄ¶¼É¾ÍêÁË£¬×¢²á±íÀïµÄҲɾÁË£¬µ«ÊÇ»¹ÊÇ×°²»³É¹¦£¡µ½ÏÖÔÚ»¹Ã»ÕÒµ½½â¾öµÄ·½·¨£¬Çë½Ì£¡
Ìáʾʲô´íÎó£¿
Â¥Ö÷£¬Çë°Ñ°²×°²»ÉϵĴíÎóÌáʾ
Ìù³öÀ´£¬·ñÔòÎÒÃÇÎÞ·¨°ïÖúÄã ......