MYSQL´æ´¢¹ý³Ì¼Ç¼ÈçºÎ²åÈëÒ»¸öбí
ͳһ·ç¸ñ£¬Ê×ÏÈÌù´úÂë
SQL code:
call SP_Ping_Dialtest('NetWork_Type',8,6,'2GG','G','3','Ping Test','2009-01-02 12:00:00','2009-12-02 12:01:00')
µÃµ½¼Ç¼ NÌõ
ÏÖÔÚÏë°ÑÕâNÌõ¼Ç¼²åÈëµ½±íTÖУ¬Ôõô´¦Àí£¿£¿
¸Ï½ô×Ô¼º×øÉ³·¢£¬Òª²»Âí¿Ë˼ÓÖÀ´ÁË¡£
ÔÚÏߵȡ£
´óºú×ÓÀ´ÁË!
ÎÞÂÛʲôÑùµÄSQL,²åÈ뵽бíÎÞ·ÇÊÇSelect intoºÍInsert into
ÄãÄDZßÓпͻ§¶Ë¹¤¾ß,¿´ÕâÁ½ÖÖÓï¾äµÄ°ïÖú¼´¿É
ÎʱðÈËÒ²Êǰ״î
µÈÓÚû˵¡£
ÄÇÄã¾ÍµÈןßÈ˸øÄãд°É
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()
SQL code:
sqlÀïÊÇ£º
getdate()
ÒýÓÃ
now()
ѧϰ
SQL code:
select now();
SQL code:
TODAY()
?
SQL code:
select now();
/* ......
SELECT a.tguildname ,SUM(a.ct) + if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......
ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£
http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......
select * from table where '123456789' like '%'+×ֶαí+'%'
Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......