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Êý¾Ý¿â£©,ż¶û»á³öÏÖÉÏÊö´íÎóÌáʾ£»³ÌÐòÒ²ÎÞ·¨ÔÙÔËÐÐ
{{
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
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 ......
hql = "select left('adfsadfasgsadgagsda',2)";
¾ÍÓÃÕâ¾äÓï¾ä ÔÚÊý¾Ý¿âÖÐÖ´ÐÐ
µ«ÊÇÔÚjava´úÂëÖÐ ÓÃHibernate Ö´ÐÐ ¾Í²»ÄÜÖ´ÐÐ £¿
ÕâÊÇʲôÎÊÌ⣡£¡£¡
ÎÒÒѾ֪µÀÁË£¡
&n ......
ͨ¹ýODBCÁ¬½ÓMySQLÊý¾Ý¿â£¬Á¬½Ó³É¹¦£¬µ«²»ÄܲéѯÊý¾Ý£¬²»ÖªµÀΪʲô
'Á¬½ÓmysqlÊý¾Ý¿â
str = "dsn=test;driver={MySQL odbc 3.51 Driver};server=localhost;port=3306;uid=root;pwd=;database=officesyst ......
CREATE PROCEDURE dowhile()
BEGIN
DECLARE v1 INT DEFAULT 5;
WHILE v1 > 0 DO
SET v1 = v1 - 1;
END WHILE;
END
ÎÒÔËÐÐmysql°ïÖúÀïÃæµÄ³ÌÐò»á±¨´í£¬²»ÖªµÀΪʲô£¬Çë ......