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

¹ØÓÚMYSQL´æ´¢¹ý³Ì

  Ò»Ö±ÒÔÀ´Ð´´æ´¢¹ý³Ì¶¼ÊÇÓõÄMSSQL£¬MSSQLд´æ´¢¹ý³ÌºÜ·½±ã£¬·½±ãÐ޸ġ£
½ñÌìÏÂÎçдMYSQLµÄ´æ´¢¹ý³ÌÏëÂîÈËÁË£¬·ÇµÃÔÚÃüÁîÌáʾ·ûÏ´´½¨´æ´¢¹ý³Ì£¬´´½¨ÒÔºóÓÖ²»ÄÜÖ±½ÓÔÚÃüÁîÐÐÏÂÐ޸쬻¹µÃ½èÖúͼÐι¤¾ßÐ޸ġ£ÎÒÓÃPHPMYADMINÐ޸ģ¬Ò»ÓдíÎó¾ÍÂíÉϰÑÎÒ֮ǰдµÄȫɾ³ýÁË£¬ÓôÃÆ£¡²»ÖªµÀ¸÷λÓÐʲôºÃµÄ·½·¨ºÍ¹¤¾ß£¡
Õ¦¾ÍûÈËÀ´ÁËÄØ£¿Ë«Ðݶ¼ÅÜÁË£¡

ÎÒÒ»°ãÊÇÖ±½ÓÔÚÃüÁîÐÐÏÂдµÄ£¬Ïȷŵ½¼Çʱ¾ÖУ¬ÓдíÎóÔÚ¼Çʱ¾ÖÐÐÞ¸ÄÔÙÌùµ½ÃüÁîÐУ¬¹þ¹þ¡£

ÕҺõãµÄ¹¤¾ßѽ£¬sqlyog²»´í¡£

ÒýÓÃ
ÕҺõãµÄ¹¤¾ßѽ£¬sqlyog²»´í¡£


SQLYogÓ¦¸Ã±È½ÏºÏÊÊ

ÎÒÒ»°ã¶¼ÊÇÓÃMysql-front
Ö»ÓÐÉÙÊýÇé¿öϲÅÓÃÃüÁîÐÐ

´´½¨Ò»¸ösqlÎļþ£¬ дºÃµ¼È룬 »òдºÃÔÙÕ³Ìù½øÈ¥£¬ ÎÒÒ²ÊÇÕâÑùµÄ


»¹ÓÐ "ÎÒÓÃPHPMYADMINÐ޸ģ¬Ò»ÓдíÎó¾ÍÂíÉϰÑÎÒ֮ǰдµÄȫɾ³ýÁË"  Õâ¸öÎÊÌ⣬ ÄãµãÏÂÃæµÄÓиö "back"


µÄÁ¬½Ó£¬ ¿ÉÒÔ·µ»Ø£¬ ²»»áɾ³ýÄã´úÂëµÄ£¬ Èç¹ûûÓУ¬ ÄÇÊÇÄã°æ±¾µÍµã°É

àÅ  ±¾µØ¿ª·¢²»ÓÃPHPMYADMINºÜ¶àÄê

ÃüÁîÐаɣ¬£¬¶àºÃ°¡£¬¹¤¾ßÓöàÁ˲»ºÃ£¬£¬

¶ª¸öÒÔǰµÄÁÐ×ÓÉÏÀ´
PHP code:

--
--´æ´¢¹ý³Ì `dkpAddMember`
--
delimiter //
create procedure dkpAddMember(belong int,playerName varchar(16),playerClass varchar(16))
begin
declare a int;
select id into a from dkp_member where belongId=belong and name=playerName;
if a is null then
insert into d


Ïà¹ØÎÊ´ð£º

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

mysqlµÄÇý¶¯³ÌÐò

ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ÉÊÇÎÒÕÒ ......

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ