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

Çë½Ì£¬¹ØÓÚmysql²éѯµÄ¼òµ¥ÎÊÌâ

PHP code:
<?php
$sql="select `*` from `ceshi`.`fbjz` order by id desc";
$result=mysql_query($sql);
$row=mysql_fetch_row($result)
print_r($row);
?>
<?=$row[0]?>
µÃµ½µÄÄÚÈÝÊÇ£º'ÕâÀïÊÇÒ»¶ÎºÜ³¤ºÜ³¤µÄ±êÌâÄÚÈÝ'
//Õâ¸ö½á¹ûÓÐ14¸öºº×Ö£¬ÎÒÖ»ÏëÏÔʾ6¸öºº×Ö£¬ÇëÎÊÔõôд£¿

for(i=0,i <=6,i++){
echo $row[i];
}

ÎÒµÄÒâ˼$row[0]µÃµ½µÄÊý¾ÝÌ«³¤Á˵õ½µÄÄÚÈÝÓÐ14¸öºº×Ö£¬Ì«¶àÁË£¬ÏëÖ»ÏÔʾ6¸ö×Ö¶øÒÑ£¬


ÎÒÕâ¸ö±íÀïÃæ¾ÍÖ»ÓÐrow[0]£¬Ã»ÓÐ123...ÁË


×ßÈË

·Ç³£¸Ðл Â¥ÉÏ


Ïà¹ØÎÊ´ð£º

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

MYSQLÓëSmartyµÄÓ¦ÓÃ

ÔÚÈýÊ®½²Óöµ½ÕâÑùÒ»¸öÎÊÌâ¾ÍÊÇÔËÐдúÂëʱ³öÏÖ´íÎó Fatal error: Call to undefined method mysql::fetch_array() in D:\WWW\news\index.php on line 12
£¬ÎÒ°Ñmysql::fetch_array() ¸Ä³Émysql::fetch_row() ÓÖ³öÏÖF ......

Mysql ʹÓÃÎÊÌâ - Java / Web ¿ª·¢

ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ 
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£

mysqlÃüÁîÐÐģʽÏÂ: ......

MYSQLÊÂÎñ»Ø¹öµÄÎÊÌâ

SQL code:

CREATE PROCEDURE A()
BEGIN
DECLARE 'Constraint Violation'
CONDITION FOR sqlexception;
DECLARE EXIT HANDLER FOR
'Constraint Violation' ROLLBACK;
BEGIN TRAN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ