mysqlÁ¬½Ó - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
mysqlÔõôÓëmyeclipseÁ¬½Ó
¸½£ºmysqlÊDz»ÊÇÖ»ÄÜÔÚDOSÏÂÔËÐÐ
лл£¡
jackham0 (jackham0)
'½ØÖÁ2010-05-04 12:37:34 Óû§½áÌûÂÊ0.00%
µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
Ïà¹ØÎÊ´ð£º
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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: ......
ÎÒÏÖÔÚÏëÓÃJSPʵÏÖQQÓÊÏäÀïµÄ¶¨Ê±·¢ËÍ£¬ÎÒÏëͨ¹ýÊý¾Ý¿â½øÐж¨Ê±²åÈëÊý¾Ý¡£
µ«²»ÖªµÀÈçºÎʵÏÖ£¬»òÕß´ó¼ÒÓиüºÃµÄ·½·¨£¬²»Ò»¶¨ËµÊÇÊý¾Ý¿â¡£
Çë´ó¼Ò¸øµãÒâ¼û£¬°ÝлÀ²¡£
quataz¶¨Ê±Æ÷×é¼þÊǸöºÜºÃµÄ½â¾ö·½°¸¡£
È ......
CREATE PROCEDURE dowhile()
BEGIN
DECLARE v1 INT DEFAULT 5;
WHILE v1 > 0 DO
SET v1 = v1 - 1;
END WHILE;
END
ÎÒÔËÐÐmysql°ïÖúÀïÃæµÄ³ÌÐò»á±¨´í£¬²»ÖªµÀΪʲô£¬Çë ......
begin
insert into userInfo(userName,userCode,delOrNot) values(in_userName,in_userCode,0);
end
´æ´¢¹ý³Ì£¬Á¬MYSQL NAVICATÀïÃæÐ´µÄ£¬²âÊÔ£¬²ÎÊý²»ÊÇÖÐÎľÍOK£¬¿ÉÒÔÔËÐÐ
±ÈÈçÎÒ²ÎÊý: 'wangwu','cctv-2010'ÔË ......
ÎÒÓÃSQL code:
\C utf8
ÃüÁMySqlµÄ×Ö·û¼¯Éè³ÉÁËutf8£¬ÎªÊ²Ã´»¹ÊDz»ÄÜÊäÈëÖÐÎÄ£¿
\C utf8
ÕâÊÇʲôÃüÁ
http://www.chinaz.com/Program/Mysql/05262c342008.html
......