֮ǰÎÒµÄjspÍøÒ³ÄÜÕý³£Á¬½ÓmysqlÊý¾Ý¿â£¬
ºóÀ´ÎªÁË×°±ðµÄ£¬ÓÃMySQLInstanceConfigÖØÐÂÅäÖÃÁË £¬°ÑmysqlµÄ¶Ë¿Ú3306¸Ä³É3308ÁË£¬Óû§ÃûºÍÃÜÂëÒ²¸ÄÁË£¬
ÇëÎÊjspÒ³ÃæÒª×öʲôµ÷Õû²ÅÄÜÕý³£Á¬½ÓÊý¾Ý¿â¡£¡£¡£
Ò²ÐíÎÊÌâºÜ°×³Õ£¬Ð¡Å®×Óû½Ó´¥¹ýÕâÖÖ¼¼ÊõÎÊÌ⣬ƽʱ¶¼×öÆ½Ãæ¡£¡£555
ºÃÐÄÈ˰ï°ïæ~
µ±È»ÊǸÃjspÀïÃæÓÐDBÃû×ÖµÄÎļþÁ ......
ÎÒ
insert into Users (account) values ("test"); ¿ÉÒÔ¡£
È»ºóÔÙÖ´ÐÐ
insert into Users (account) values ("Test");
¾Í±¨´íDuplicate entry 'Test' for key x
linux»·¾³£¬ ÇëÎÊÈçºÎÈÃmysql Àïvarchar ×Ö¶ÎÖ§³Ö´ó²»Ð´Çø·Ö£¿
²Î¿¼ÏÂÌùÖÐÓйØ×Ö·û¼¯µÄ½éÉÜ¡£
http://blog.csdn.net/ACMAIN_CH ......
±í½á¹¹ÈçÏ£¬ÏÖÔÚÎÒÒª¶Á³öÀ´µÄÊý¾Ý±£Áô1λСÊý£¬sqlÓï¾äÒªÔõÃ´Ð´ÄØ£¿£¨Ö»ÄÜÔÚsqlÓï¾äÖÐʵÏÖ£¬²»¿ÉÓÃjava¡¢phpµÈÀ´ÊµÏÖ£©
lat lng
20.14 113.45
20.15 113.46
10 100.04
д³ÉÕâÑùµÄ»°
SELECT substr( lat, 1, instr( lat, '.' ) +1 ) AS lat1, substr( lng, 1, instr( lng, '.' ) +1 ) AS lng1
fr ......
·´ÕýÎÒÊǾ³£·Ö²»Çå¡¡
¼ÌÐøÉ¢·Ö
µÚÒ»¸ö±ÕÔ´£¬µÚ¶þ¸ö¿ªÔ´£¬µÚÈý¸öûŮÈËÔµ¡¡
LZÄ㻹ÓпÉÓ÷Öô£¿
ÒýÓÃ
LZÄ㻹ÓпÉÓ÷Öô£¿
5·Ö
ÒýÓÃ
µÚÒ»¸ö±ÕÔ´£¬µÚ¶þ¸ö¿ªÔ´£¬µÚÈý¸öûŮÈËÔµ¡¡
ÓÐÒâ˼¡£¿´±êÌâÎÒ»¹ÒÔΪÊÇmstlqÓëmysqlÄØ£¬½á¹û×îºó»¹ÕæÓÐmstlq£¬ºÇºÇ¡£
ËÒª¿ÉÓ÷֣¬ÔõôÔùË͵ġ£
ÎÒÒª^_^
http: ......
ÓбíÈç
CREATE TABLE `testtable` (
`PlayerID` int(11) NOT NULL,
`LastSevID` int(11) NOT NULL default '0',
`Mark` decimal(16,1) NOT NULL default '0.0',
`Level` int(11) NOT NULL default '1',
PRIMARY KEY (`PlayerID`,`LastSevID`),
KEY `Mark` (`Mark` ......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þ ......