Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : mysql

mysqlÖкóÍËÃüÁ

mysql>create book(
    ->id varchar(20) not null,g
    ->
ÒÔÉÏÊÇÔÚmysqlÃüÁîÐÐÀïµÄ²Ù×÷
ÔÚÉÏÃæÖÐÎÒÔÚµ¹ÊýµÚ¶þÐжà´òÁËÒ»¸ö×ÖĸgÈ»ºó°´Á˻سµ¼ü£¬ÇëÎÊ´Óµ¹ÊýµÚÒ»ÐÐÔõô»Øµ½µ¹Êýÿ¶þÐнøÐиü¸Ä°¡£¿
\c Â𣬼Dz»ÇåÁË£¬½¨ÒéÏÈдºÃsql½Å±¾Îļþ£¬È»ºóÌá½»Ö´ÐÐ

ÔÚmysqlÖÐÊäÈë¡°£ ......

php ²éѯ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/ ......

¹ØÓÚmysql´¥·¢Æ÷£¬ÓÐûÓа취ʵÏÖÕâÑùµÄ¹¦ÄÜ£¿

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 ......

mysqlÖÐÈçºÎ¸ù¾ÝsqlÓï¾äÖ´Ðнá¹ûÖ´ÐÐÆäËûsqlÓï¾ä

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Ö´Ðнá¹ûÈ¥Ö´ÐÐÆäËûµÄÓï¾ä£¬²»Ïëͨ¹ý ......

Çë½ÌMYSQLÈ¡·¨

ÓÐÈý¸ö±íÁªÈ¡£¬user_group.*, user.*, radacct.* È¡20Ìõ

Ìõ¼þ£ºradacct±íÀïֻȡһÌõ¼Ç¼£¨Óëuser±íµÄµÇ¼ÃûÏàͬµÄÒ»Ìõ×îеģ©


$sortby .= ($this->order != "") ? " ORDER BY radacct.AcctStartTime ".$this->order : ""
$where.=" ORDER BY  radacct ......

MySQL°²×°ÎÊÌ⣡

³õ´Î°²×°µÄʱºòûÎÊÌ⣬µ«ÊÇÒ»²»Ð¡ÐÄÖØ×°ÏµÍ³ÁË£¬Ôٴΰ²×°MySQLµÄʱºò£¬µ½start serviceµÄʱºò¾Í²»ÐÐÁË£¬°²×°²»³É¹¦£¡
ÎҰѰ²×°ÎļþʲôµÄ¶¼É¾ÍêÁË£¬×¢²á±íÀïµÄҲɾÁË£¬µ«ÊÇ»¹ÊÇ×°²»³É¹¦£¡µ½ÏÖÔÚ»¹Ã»ÕÒµ½½â¾öµÄ·½·¨£¬Çë½Ì£¡
Ìáʾʲô´íÎó£¿

Â¥Ö÷£¬Çë°Ñ°²×°²»ÉϵĴíÎóÌáʾ

  Ìù³öÀ´£¬·ñÔòÎÒÃÇÎÞ·¨°ïÖúÄã ......
×ܼǼÊý:1662; ×ÜÒ³Êý:277; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [196] [197] [198] [199] 200 [201] [202] [203] [204] [205]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ