ÂòµÄ¿Õ¼ä,Ö§³ÖPHPµÄ
Ö®¼äÂòÁËMYSQLÊý¾Ý¿â,µ«ÊǺܲ»Îȶ¨,ÏÖÔÚ¹ýÆÚÁË,¾ÍûÐë·ÑÁË
ÏÖÔÚPHP³ÌÐò,ûÓÐÊý¾Ý¿â,ÅóÓÑÓиö·þÎñÆ÷,¿ÉÒÔÈÃÎÒ°ÑÊý¾Ý¿â·Åµ½ËûµÄ·þÎñÆ÷ÉÏ Ëû·þÎñÆ÷IP:9.9.9.9(¼ÙÉè)
ÎÒÂòµÄ¿Õ¼ä IPÊÇ 1.1.1.1(¼ÙÉè)
ËûµÄ·þÎñÆ÷µÄrootÃÜÂë¶¼¸øÎÒÁË,¿ÉÊÇÎÒÔõôÉèÖÃÒ²Á¬½Ó²»ÉÏÊý¾Ý¿â
¸ßÊִͽÌ,²»ÒªÔÚÍø ......
jsp+mysql¶ÁÈ¡Êý¾Ý¿âÐÅÏ¢£¬µ±¶Áµ½Ò»¸öÈÕÆÚ×ֶεÄʱºòÌáʾÊý¾Ý¿âÁ¬½Óʧ°Ü£¬²éÕÒÊý¾Ý¿âÖиÃÈÕÆÚ×ֶεÄÖµ£º0000-00-00£¬¸ÄΪ£º2009-01-19 ºó³ÌÐò¶Á³öÊý¾ÝÕý³££¬²»ÖªµÀ¸ÃÔõô½â¾öÕâ¸öÎÊÌ⣬¿´ÁËһϣ¬Êý¾ÝÖÐÓкܶàÕâÖÖÈÕÆÚ×ֶεÄֵΪ0000-00-00
ÇëÎÊ´ó¼Ò¸ÃÔõô½â¾öÕâ¸öÎÊÌ⣿
ÓÃgetString()´úÌægetDate()ÊÔÊÔ¡£
ÎÒÒ²Óöµ½ ......
mysqlÔõÑùɾ³ýǰnÌõ¼Ç¼
ÇósqlÓï¾ä
лл
MYSQL ºÃÏóÊÇlimit
SQL code:
limit
SQL code:
delete from [tabName] where [colname] limit [n] order by [colName]
SQL code:
delete TB from TB where COL limit [n] order by COL
delete TB from TB where COL limit [n] order by COL
ÊÇlimit ......
ÎÒÏëÔÚshellÖе÷ÓÃmysql, Éú³ÉinsertÓï¾ä, ÔÙ°ÑÕâ¸öinsertÓï¾äÖ´ÐÐ.
ÎÊÌâÊÇÎÒÔÚÉú³ÉinsertÓï¾äµÄʱºòÀïÃæÓзÇÓ¢ÎĵÄÖµ. Õâ¸öÖµ×ÜÊÇÏÔʾ³ÉÂÒÂë. ²»ÖªµÀ¸ÃÔõô½â¾ö.
ÕâÊÇÎÒUnixÀïµÄ.
+--------------------------+----------------------------+
| Variable_name &nbs ......
mysqlµÄÖ´ÐÐinsertÊÇ·ñÓзµ»ØÖµ£¿ÏñoracleµÄ·µ»ØÖµÊÇsqlcode£¬
mysqlÓзµ»ØÖµÃ´£¿Âé·³ÄÄλ¸æËßһϡ£
°ï¶¥ MYSQL½¨ÒéÈ¥ÆäËûÊý¾Ý¿â¿ª·¢°æ¿é
mysqlÓзµ»ØÖµÃ´£¿
---
ÎÒÖªµÀmssqlÓУ¬@@error
²»ÖªµÀÓÐûÓÐÀàËÆ05ÒÔÉϵÄINSERT OUTPUTµÄÓï¾ä²ÎÊý
mysqlûÕâÑùÓùý¡£¡£
SQL code:
mysql> select row_coun ......
ÎÊÌ⣺µ±Ê¹ÓÃEditPlusÔËÐÐjava³ÌÐòʱ£¬ÌáʾÎÞ·¨ÕÒµ½Çý¶¯£º com.mysql.jdbc.Driver
¶øµ±ÎÒ°ÑÇý¶¯£¨mysql-connector-java-3.1.10-bin.jar£©Ìí¼Óµ½»·¾³±äÁ¿
classpathÖУ¨D:\java\javahomework\mysqlDriver\mysql-connector-java-3.1.10-bin.jar£©
ºóÔÙ´ÎÔËÐиÃjava³ÌÐò,½á¹ûÈÔÈ»ÎÞ·¨ÕÒµ½¸ÃÇý¶¯¡£ºóÀ´ÎÒÖ ......