MYSQLÊý¾Ý»Ö¸´ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
ÎÒĿǰÓÐÒ»·ÝMS SQLµÄÊý¾Ý±¸·Ý£¬ÒòΪ»»·þÎñÆ÷ÁË£¬ÄǸö·þÎñÆ÷ÉÏÓõÄMYSQL£¬Ïë°ÑÄǸö±¸·ÝÎļþÖ±½Ó»Ö¸´µ½MYSQLÖУ¬ÎÒ¸ÃÈçºÎ²Ù×÷£¬ÄÄλ°ïÏ£¬Ð»Ð»ÁË¡£
ÎÒÄǸöÊý¾Ý±¸·ÝÎļþÊÇ.bakµÄ£¬»¹ÓÐÒ»¸ö.sqlµÄÎļþÒ»ÆðµÄ¡£
лл¸÷룬ÓÃ°Ù¶È googleÁËһϣ¬ÕÒµ½¸ö´ó¸ÅµÄ·½·¨£¬ÏÈÔÝʱֻÄܰÑMSSQLÊý¾Ý»Ö¸´µ½MSÖÐÁË£¬ÔÙͨ¹ýNavicatתµ½MYSQL°É¡£»¹ÓÐÎÊÌâÎÒÔÙÀ´ÎÊ´ó¼Ò£¬Ð»Ð»°¡¡£
ºÇºÇ¡£GOOD LUCK¡¡
½áÌûÀ²£¬Ð»Ð»¸÷λ¡£
Ïà¹ØÎÊ´ð£º
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......
CREATE PROCEDURE dowhile()
BEGIN
DECLARE v1 INT DEFAULT 5;
WHILE v1 > 0 DO
SET v1 = v1 - 1;
END WHILE;
END
ÎÒÔËÐÐmysql°ïÖúÀïÃæµÄ³ÌÐò»á±¨´í£¬²»ÖªµÀΪʲô£¬Çë ......