Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : mysql

¹ØÓÚMysqlºÍJSPÒ³ÃæµÄÎÊÌâ

֮ǰÎÒµÄjspÍøÒ³ÄÜÕý³£Á¬½ÓmysqlÊý¾Ý¿â£¬
ºóÀ´ÎªÁË×°±ðµÄ£¬ÓÃMySQLInstanceConfigÖØÐÂÅäÖÃÁË £¬°ÑmysqlµÄ¶Ë¿Ú3306¸Ä³É3308ÁË£¬Óû§ÃûºÍÃÜÂëÒ²¸ÄÁË£¬
ÇëÎÊjspÒ³ÃæÒª×öʲôµ÷Õû²ÅÄÜÕý³£Á¬½ÓÊý¾Ý¿â¡£¡£¡£
Ò²ÐíÎÊÌâºÜ°×³Õ£¬Ð¡Å®×Óû½Ó´¥¹ýÕâÖÖ¼¼ÊõÎÊÌ⣬ƽʱ¶¼×öÆ½Ãæ¡£¡£555
ºÃÐÄÈ˰ï°ïæ~
µ±È»ÊǸÃjspÀïÃæÓÐDBÃû×ÖµÄÎļþÁ ......

mysql´óСдÎÊÌâ

ÎÒ
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 ......

mysql ½ØÈ¡×Ö·û´®

±í½á¹¹ÈçÏ£¬ÏÖÔÚÎÒÒª¶Á³öÀ´µÄÊý¾Ý±£Áô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 ......

mssql£¬mysqlÓëmstlq

·´ÕýÎÒÊǾ­³£·Ö²»Çå¡­¡­
¼ÌÐøÉ¢·Ö
µÚÒ»¸ö±ÕÔ´£¬µÚ¶þ¸ö¿ªÔ´£¬µÚÈý¸öûŮÈËÔµ¡­¡­

LZÄ㻹ÓпÉÓ÷Öô£¿

ÒýÓÃ
LZÄ㻹ÓпÉÓ÷Öô£¿
5·Ö

ÒýÓÃ
µÚÒ»¸ö±ÕÔ´£¬µÚ¶þ¸ö¿ªÔ´£¬µÚÈý¸öûŮÈËÔµ¡­¡­

ÓÐÒâ˼¡£¿´±êÌâÎÒ»¹ÒÔΪÊÇmstlqÓëmysqlÄØ£¬½á¹û×îºó»¹ÕæÓÐmstlq£¬ºÇºÇ¡£

Ë­Òª¿ÉÓ÷֣¬ÔõôÔùË͵ġ£

ÎÒÒª^_^
http: ......

mysql²éѯÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÓбíÈç
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` ......

vs2008 Á¬½Ómysql£¿ - MS-SQL Server / »ù´¡Àà

ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐË­ÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿

ÒýÓÃ
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þ ......
×ܼǼÊý:1662; ×ÜÒ³Êý:277; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [35] [36] [37] [38] 39 [40] [41] [42] [43] [44]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ