Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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

mysql±¸·Ý»ò²éѯµÄʱºò¡£¡£Èç¹ûÉèÖõĻº´æÄÚ´æ²»¹»£¬ÊDZ¨´í¡£»¹ÊÇ°Ñ»º´æÀïÃæµÄÊý¾ÝÊä³öÔÚÀ´½ÓÊÜеÄÄÚÈÝ£¿
Ó¦¸ÃÊDZ¨´í¡£×îºÃ×Ô¼ºÊÔһϣ¬ÄÇÑù¸ÐÊÜ»á¸üÉîһЩ¡£

ÆäʵÄã×Ô¼ºÏëһϾÍÃ÷°×ÁË¡£

¼ÙÉèÄãÔÚһ̨ÎïÀíÄÚ´æÖ»ÓÐ 128MµÄ»úÆ÷ÉϲéÒ»¸ö´ó±í(3G)£¬½á¹û»á±¨´íÂð£¿

ÒýÓÃ
ÆäʵÄã×Ô¼ºÏëһϾÍÃ÷°×ÁË¡£

¼ÙÉèÄãÔÚһ̨ÎïÀíÄÚ´æÖ»ÓÐ 128MµÄ»úÆ÷ÉϲéÒ»¸ö´ó±í(3G)£¬½á¹û»á±¨´íÂð£¿


 ÎÒÈÏΪ¿ÉÒÔ¼ÓÒ»¸ö»º´æ 50M ¡£¡£È¡50M¡£¾Í¶Áµ½ÎļþÖÐÈ¥¡£¡£
 Õâ¸öÓ¦¸Ã¿ÉÒÔ°É£¿

ÒýÓÃÒýÓà 2 Â¥ acmain_chm µÄ»Ø¸´:
ÆäʵÄã×Ô¼ºÏëһϾÍÃ÷°×ÁË¡£

¼ÙÉèÄãÔÚһ̨ÎïÀíÄÚ´æÖ»ÓÐ 128MµÄ»úÆ÷ÉϲéÒ»¸ö´ó±í(3G)£¬½á¹û»á±¨´íÂð£¿


ÎÒÈÏΪ¿ÉÒÔ¼ÓÒ»¸ö»º´æ 50M ¡£¡£È¡50M¡£¾Í¶Áµ½ÎļþÖÐÈ¥¡£¡£
Õâ¸öÓ¦¸Ã¿ÉÒÔ°É£¿


ÏÔÈ»²»»á±¨´í¡£


Ïà¹ØÎÊ´ð£º

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......

mysqlÎÊÌ⣡ - Java / Java SE

String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......

sqlÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÔõôÑù²éѯÁ¬½Ó2¸ö±íÖ®ºó µÃ³öµÄбí
ÀýÈç A±í£º·¢¼þÈËID Óʼþ±àºÅ ÓʼþÄÚÈÝ ÊÕ¼þÈËID ·¢¼þʱ¼ä
  B±í£ºÊÕ¼þÈËID Óʼþ±àºÅ ÊÕ¼þʱ¼ä
  Ê×ÏÈ×öA BµÄÁ¬½Ó²éѯ ¼´ Óʼþ±àºÅÏàµÈ
  ²é³ö£ ......

MySQLÊý¾Ý¿â´æ·ÅÔÚÄÄ°¡£¿ - MS-SQL Server / »ù´¡Àà

ÔõôÕÒµ½Êý¾Ý¿âµÄλÖ𡣿Çë¸÷λǰ±²Ö¸½Ìһϣ¿Ð¡µÄ·Ç³£¸Ðл£¡
ÏÈÕÒµ½my.cnfÎļþ£¬´ò¿ªºó¿´[data]ϵÄdatadir


2¡¢½øÈëmysqlÖնˣº
mysql>show variables like '%datadir%';

ÔÙ²»ÐÐÈ«ÅÌËÑË÷£º¡¡frmÎļþ ......

Ò»¸ömysqlÖйØÓÚin×Ó²éѯµÄÎÊÌâ - Java / Web ¿ª·¢

SELECT * from alarms where id in (select resource_id from res_products where product=22)
Õâ¸öÓï¾äÔÚmysqlÖÐΪʲô²»ÄÜÖ´ÐУ¿ÎÒµÄmysqlÊý¾Ý¿âÊÇ5.0.27°æ±¾µÄ£¡
Èç¹ûʵÔÚ²»ÐÐÄÇô¸ÃÓøöʲôÓï¾ä´úÌæЧÂʸü¸ßÄØ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ