MYSQLÊý¾Ý»Ö¸´ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
ÎÒĿǰÓÐÒ»·ÝMS SQLµÄÊý¾Ý±¸·Ý£¬ÒòΪ»»·þÎñÆ÷ÁË£¬ÄǸö·þÎñÆ÷ÉÏÓõÄMYSQL£¬Ïë°ÑÄǸö±¸·ÝÎļþÖ±½Ó»Ö¸´µ½MYSQLÖУ¬ÎÒ¸ÃÈçºÎ²Ù×÷£¬ÄÄλ°ïÏ£¬Ð»Ð»ÁË¡£
ÎÒÄǸöÊý¾Ý±¸·ÝÎļþÊÇ.bakµÄ£¬»¹ÓÐÒ»¸ö.sqlµÄÎļþÒ»ÆðµÄ¡£
лл¸÷룬ÓÃ°Ù¶È googleÁËһϣ¬ÕÒµ½¸ö´ó¸ÅµÄ·½·¨£¬ÏÈÔÝʱֻÄܰÑMSSQLÊý¾Ý»Ö¸´µ½MSÖÐÁË£¬ÔÙͨ¹ýNavicatתµ½MYSQL°É¡£»¹ÓÐÎÊÌâÎÒÔÙÀ´ÎÊ´ó¼Ò£¬Ð»Ð»°¡¡£
ºÇºÇ¡£GOOD LUCK¡¡
½áÌûÀ²£¬Ð»Ð»¸÷λ¡£
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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: ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......