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

mysql¶àÏ̵߳÷Óô洢¹ý³ÌµÄÎÊÌâ

ÔÚͬһ¸öÊý¾Ý¿âÖУ¬Í¬Ò»¸ö´æ´¢¹ý³Ì£¬Äܲ»ÄÜͨ¹ý¶à¸öÏß³Ìͬʱµ÷Ó㬿ÉÒÔͨ¹ý´«Èë²ÎÊýÀ´¸Ä±ä´æ´¢¹ý³ÌÄÚ²Ù×÷µÄ±í£¬ÕâÑù¾Í²»´æÔÚÔÚ±í»¥³âµÄÎÊÌâÁË£¬ÇëÎÊÕâÑù×ö»áÓÐʲôÎÊÌ⣬ÎÒÔÝʱûÓвâÊÔ¹ý£¬ÏëÌýÌý´ó¼ÒµÄÒâ¼û£¬ºÍ¿ÉÄÜ´æÔÚµÄÇé¿ö
ÒýÓÃͨ¹ý´«Èë²ÎÊýÀ´¸Ä±ä´æ´¢¹ý³ÌÄÚ²Ù×÷µÄ±í


ûÀí½âÄãÏëʵÏÖʲô¹¦ÄÜ£¬ÄÜ·ñ¾ÙÀý˵Ã÷£¿

ÔÚÊý¾Ý¿âdbtestÖУ¬ÓÐÒ»¸ö´æ´¢¹ý³Ì
create procedure sp_protest(in tablename varchar(16))
begin
  ¶Ô´«Èë±íÃûµÄ±í½øÐвåÈëÓë¸üеIJÙ×÷
end;
¶àÏ̵߳÷ÓÃÕâ¸ö´æ´¢¹ý³Ì£¬»á²»»áÓÐʲôÎÊÌâ

»áÓÐÎÊÌâ

Äã²»·Á°ÑÕâ¸ö sp_protest дÍêÕû£¬ÕâÑùÄã»áÓõ½Ò»¸öSESSION¼¶±äÁ¿¡£³ý·ÇÄãµÄÕâЩÏ̸߳÷¿ªÒ»¸öеÄconnection ,·ñÔòÕâ¸ö±äÁ¿Êǹ²ÏíµÄ¡£
create procedure sp_protest(in tablename varchar(16))
begin
¶Ô´«Èë±íÃûµÄ±í½øÐвåÈëÓë¸üеIJÙ×÷
end;


ÎÒÃ÷°×ÄãµÄÒâ˼£¬ÎÒ¶àÏ̷߳ÃÎÊÊý¾Ý¿â£¬µ÷ÓÃÕâ¸ö´æ´¢¹ý³Ì£¬ÊÇͨ¹ý²»Í¬µÄÊý¾Ý¿âÁ¬½ÓÀ´µ÷ÓõÄ

ÒýÓÃÊÇͨ¹ý²»Í¬µÄÊý¾Ý¿âÁ¬½ÓÀ´µ÷ÓõÄ


ÄǾÍûÎÊÌâ¡£ ·ÃÎʲ»Í¬µÄ±í£¬²»»áÓÐËøÉϵÄÎÊÌâ¡£

ÄÇÈç¹ûÎÒÊÇʹÓò»Í¬µÄMYSQLµÄÊÂÎñµ÷¶ÈÆ÷À´µ÷ÓÃÕâ¸ö´æ´¢¹ý³ÌÄØ£¿

ÒýÓÃMYSQLµÄÊÂÎñµ÷¶ÈÆ÷


MYSQLµÄÊÂÎñµ÷¶ÈÆ÷ ÄãÊÇָʲô£¿²»Ã÷°×ÄãµÄÕâ¸öÊõÓï¡£

Èç¹û˵³É¶¨Ê±Æ÷£¬ÄãÓ¦¸Ã¿ÉÒÔÀí½âÁ˰ɣ¬ÔÚ5.1.12°æ±¾Ö®ºó¾Í¿ÉÖ§³ÖÕâ¸ö¹¦ÄÜ£¬ÎÒÏÖÔÚÓõÄÊÇ5.1.38ÒѾ­³õÑé³É¹¦

create event ? MYSQLʼþ£¿

Õâ¸öÊÇÓÉMYSQLÀ´µ÷¶ÈÖ´ÐУ¬²


Ïà¹ØÎÊ´ð£º

ÓÃPHPÅÅÐòmysqlÎÊÌâ

²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......

ΪʲôMySQL²»Ö§³ÖÖÐÎİ¡£¿£¿

ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë

Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ

Ö§³Ö£¬¼ì² ......

Sqlserver Óï¾äת³ÉMySqlÓï¾ä

Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......

mysql root¸ÄÁËÃÜÂ룬ÓÖ×Ô¶¯±äÁË

¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
  1.ÒÔϵͳ¹ ......

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: ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ