ÎÒ´æ´¢¹ý³ÌÏë
begin
select * from newsys;
end
µ«´æ´¢¹ý³ÌµÄ²ÎÊýÓ¦¸ÃÔõôд?
phpÓÖÔõôµ÷Óã¬Çë¸øÎÒÍêÕûµÄʵÀý£¬ÎÒÔÚÍøÉÏËÑÁËÒ»´ó¶Ñ£¬½á¹û¶¼Ã»³É¹¦£¬Ð»Ð»¸÷λ£¡
ûÓùý£¬¶¥Ò»Ï£¡
......
°´µÀÀíÀ´Ëµ£¬Í¼Æ¬ÊÇÓ¦¸Ã°´ÕÕ·¾¶´æÔÚÊý¾Ý±íÖеģ¬ÓÉÓÚ¹¤×÷ÐèÒª£¬ÐèÒª½«Í¼Æ¬ÒÔ¶þ½øÖÆÁ÷µÄÇé¿ö´æÈëÊý¾Ý¿â£¬ÏÖÔÚ½«Êý¾Ý±ítableÖÐÒ»¸ö×Ö¶Îpicture£¬ÀàÐ͸ÄΪ longblob£¬ÒѾÄܳɹ¦½«¶þ½øÖÆÁ÷дÈë¸Ã×ֶΣ¬¿ÉÊÇÎÒÐèÒª½«¸ÃͼƬÔÚÄÚÈÝÒ³ÖÐÏÔʾ³öÀ´£¬ÒÔÏ´úÂëÊÇÎÒÔÚͼƬµÄλÖÃǶÈëµÄphp´úÂ룬ͼƬËÀ»î²»ÏÔʾ£¬´ó¼Ò°ïæ¿´¿´Ôõô»ØÊ£¿ ......
ÎÒ°²×°µÄÊÇappserv-win32-2.4.4a.exe×éºÏ°ü£¬ÎÒÔÚmysqlÖд´½¨ÁËÒ»¸ödb_bookÊý¾Ý¿â,²¢ÔÚdb_bookÊý¾Ý¿âÖд´½¨ÁËÒ»¸ötb_book±í£¬ÎÒÏëдһ¸öphp³ÌÐòÏòtb_book±íÖвåÈëÊý¾Ý£¬¿ÉÊdzöÏÖ¡°Ñ¡ÔñÊý¾Ý¿âʧ°Ü£¡¡±µÄÌáʾ£¬²»ÖªÊÇʲôÔÒò£¬Çë´ó¼Ò°ï棬лл£¡ÎÒдµÄphpÎļþÊÇ£º
<?php
$link=mysql_connect("$localhos ......
¶ÔMYSQLÖд洢µÄXML¸ñʽµÄÊý¾Ý½øÐвéѯ¸üÐÂÒÔ¼°É¾³ýij½áµã´¦ÀíµÄÀý×Ó£¬Çë·¢ÎÒÓÊÏ䣬лл£¬
30367940@qq.com
·¢ËͺóÇë»ØÌû£¬ÊÕµ½¼°½áÌû
ÄãÒªmysql¸ÉÂï?
ÂãÇó¿ÉÒÔ¿¼ÂÇ!
¶¥ÉÏÈ¥
¶Á³öÀ´È»ºóÓÃSimpleXML´¦Àí¾ÍÊÇÁË£¬Õâ¸öÊÇPHP×Ô´øµÄ´¦ÀíXMLµÄ¶«¶«
ÓÃphp×Ô´øµÄSimpleXML´¦Àí£¬Êý¾Ý¿â¶Á³öÀ´£¬¿ÉÒÔÏñ¶Á×Ö·û´®Ò ......
ÎҼǵÃÔÚmysqlÖÐÓиöload data infile Óï¾ä¿ÉÒÔ°ÑwordÎĵµµÄÄÚÈÝ°´Ò»¶¨¸ñʽµ¼ÈëÊý¾Ý¿â£¬ÕâÑùµ¼ÈëµÄÊý¾ÝÀàÐͺÃÏñÖ»ÄÜÊÇÎı¾¸ñʽµÄÊý¾Ý£¬ÇëÎÊÓÐû¸üºÃµÄ·½·¨¿ÉÒÔµ¼ÈëÊý¾Ý¿â¡£
1¡£Èç¹ûÎÒÃÇÒª°ÑÊÔÌâµ¼ÈëÌâ¿â£¬ÄÇôwordÎĵµµÄ¸ñʽ¾ÍÓ¦ºÍÏÂÃæÏàËÆ£º
Ò»¡¢Ñ¡ÔñÌâ
1¡£ËÕ¶«º£·¨¹úÉ̵ê·Ö¹«Ë¾
2¡£ËÕ¶«º£·Ö¹«Ë¾¶«º£
¶ ......
mysql±È½Ï²Ë£¬
×Ö¶ÎÀïÃæÓиö MB ,²»ÊÇÊýÖµÐÍ£¬ÆäËüÓÐЩ¡°Î´Öª¡±£¬Ôõô²ÅÄܵóö×îÖÕÏà¼ÓµÄ½á¹û£¿
SQL code:
mysql> select * from t;
+----------+
| size |
+----------+
| 0.47 MB |
| NULL |
| 10.12 MB |
+----------+
3 rows in set (0.00 sec)
mysql> select sum(left(size,lengt ......