Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysql in²éѯ....

test.php  Ϊʲôȡ²»µ½Öµ£¿
PHP code:

<?php
mysql_connect("localhost","root","123456");
mysql_select_db("test");

$arr=array("1","2","3","5","10","6","9");
$query=mysql_query("select * from aaa where id in($arr)");//in("Êý×é")£¬Ã÷Á˵ÄÒâ˼---È¡µÃid=1¡¢2¡¢3...µÄÐÅÏ¢
while($result=mysql_fetch_array($query)){
echo $result[0]."<br>";
echo $result[1].""<br>;
}
?>




´íÎóÐÅÏ¢£ºmysql_fetch_array(): supplied argument is not a valid MySQL result resource .......
echo $query¿´Ò»ÏÂÓï¾ä¡£

PHP code:

$query=mysql_query("select * from aaa where id in('$arr')");



ÒýÓÃ
PHP code$query=mysql_query("select * from aaa where id in('$arr')");

µ¥ÒýºÅ£¬Ë«ÒýºÅ...¶¼ÊÔ¹ý£¬»¹ÊDz»ÐÐ- -£¡

ÄãÕæÓвţ¬Ö±½Ó°ÑÊý×é·Åµ½×Ö·û´®ÀïÈ¥
¸øÄãÌáʾÏ£¬ÓÃjoinº¯Êý

UP UP UP .......

ÒýÓÃ
ÄãÕæÓвţ¬Ö±½Ó°ÑÊý×é·Åµ½×Ö·û´®ÀïÈ¥
¸øÄãÌáʾÏ£¬ÓÃjoinº¯Êý

LZ»¹upʲô£¬¸Ï½ôÈ¥¸´Ï°sqlµÄinÓï¾ä£¬


Ïà¹ØÎÊ´ð£º

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

mysqlÓï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

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£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£

http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......

mysqlÁÙʱ±íµÄÎÊÌâ

ÎÒÎÊÏ£¬ÊDz»Êǽ¨Á¢ÁÙʱ±í±ØÐëºÍÖ÷±íµÄ×Ö¶Îʲô¶¼Ò»Ñù£¬²ÅÄÜÆð×÷Óðɣ¿»¹ÓÐÀïÃæÖ÷±íµÄÊý¾Ý¿âÊDz»ÊÇÒ²¾Í¸´ÖƵ½ÁÙʱ±íÁË£¬Èç¹ûÎÒselect Ö÷±í£¬²»ÓÃÔÚдselect ÁÙʱÁ˰ɣ¬ÊÇ×Ô¶¯¾ÍselectµÄÁÙʱÁ˰É?
ÎÒÎÊÏ£¬ÊDz»Êǽ¨Á ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ