MySQLÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
ÎÞͼÎÞÕæÏà
²»ºÃÒâ˼£¬Í¼Ã»´«ÉÏÀ´£¿ ÖØ·¢ÁËÒ»±é¡£
windows server 2003ϵͳ
´íÎóÌáʾÈçÏ£º
uhandled exception has occurr in your application£¬If you Click countie£¬the
application will ignore this error and attempt to countie£¬If Click quite£¬the
application will close immediately¡£
MySQLdriveCS exception £ºMySQLdriveCS Error£ºCan't connect.Can't create new
thread £¨errno 12£©if you not out of available memory£¬you can consult the
manual for a possible OS-dependent bug.
ÕâÊÇʲôÎÊÌ⣬ÈçºÎ½â¾ö£¿
ʲôÇé¿öϳöÏÖÕâÖÖ¹ÊÕÏ£¿
ÎÞ·¨°²×°£¿ °²×°Õý³££¬ÎÞ·¨Æô¶¯£¿ Æô¶¯Õý³£ÎÞ·¨Á¬½Ó£¿ £¿£¿£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
²¹³ä£º°²×°£¬Æô¶¯£¬Á¬½ÓÕý³££¬
¾ÍÊÇÔÚ Ó¦ÓóÌÐòÔËÐÐʱ£¨Ó¦ÓóÌÐòÐè²»¶Ï¶ÁÈ¡£¬¸üÐÂMySQLÊý¾Ý¿â£©,ż¶û»á³öÏÖÉÏÊö´íÎóÌáʾ£»³ÌÐòÒ²ÎÞ·¨ÔÙÔËÐÐ
{{
Ïà¹ØÎÊ´ð£º
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......
CREATE PROCEDURE dowhile()
BEGIN
DECLARE v1 INT DEFAULT 5;
WHILE v1 > 0 DO
SET v1 = v1 - 1;
END WHILE;
END
ÎÒÔËÐÐmysql°ïÖúÀïÃæµÄ³ÌÐò»á±¨´í£¬²»ÖªµÀΪʲô£¬Çë ......