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

ÓйØmysqlÁ½¸ö±íij×Ö¶ÎÊý¾Ýͬ²½µÄÎÊÌâ

ÎÒÓÐÁ½¸ö±í.
a±íÖÐÓлý·Ö×Ö¶Î.
b±íÒ²Óиö»ý·Ö×Ö¶Î.
ÒòΪa±íºÍb±íÊôÓÚ²»Í¬Á½¸öƽ̨.
Èç¹û×öµ½Í¬²½?¾ÍÊÇa±íÐ޸ĵÄʱºòͬʱÐÞ¸Äb±í.ͬʱb±íÐ޸ĵĻ°Ò²ÐÞ¸Äa±í.



±í  1 
bbs_members(ÂÛ̳Óû§±í)
×Ö¶Î
uid(Óû§id),extcredits1(»ý·Ö),extcredits2(½ðÇ®)

±í  2
dede_member
×Ö¶Î
mid(Óû§id),scores(»ý·Ö),money(½ðÇ®)

--------------------------
Ïë¹ýд´¥·¢Æ÷.µ«ÊÇÄÇÑùµÄ»°²»ÊÇËÀÑ­»·Âð?
a±í´¥·¢ÁËb±í.b±íÒòΪÐÞ¸ÄÓÖ´¥·¢a±í¡­¡­

½¨ÒéÓõÚÒ»Öа취

µÚ¶þÖа취Ҳ²»ÊDz»ÐУ¬¿ÉÒÔÔÚ´¥·¢Æ÷ÀïÃæÐ´ifÓï¾äÅжÏÏ£¬ËùνµÄËÀÑ­»·ÊÇ¿ÉÒÔ±ÜÃâµÄ

´ó¸ç.mysqlµÄ´¥·¢Æ÷ÎÒûÓÐÓùý.
Äܲ»Äܰïæָµ¼Ö¸µ¼.˳±ãÎÒҲѧϰѧϰд·¨?

ÒýÓÃ
´ó¸ç.mysqlµÄ´¥·¢Æ÷ÎÒûÓÐÓùý.
Äܲ»Äܰïæָµ¼Ö¸µ¼.˳±ãÎÒҲѧϰѧϰд·¨?


ÕâÖ־Ͳ»ºÃÔÙÎÊÁ˰ɣ¿ ×Ô¼º·­ÊÖ²á°É


Ïà¹ØÎÊ´ð£º

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. 
¿ ......

c#¿ØÖÆMysql ʵÏÖ×Ô¶¯É¾³ý¹¦ÄÜ - .NET¼¼Êõ / C#

Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......

Çë½ÌÒ»¸ömysqlÁ©±íÁ¬½ÓµÄÎÊÌâ

ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£©
ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à
b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......

Mysql ʹÓÃÎÊÌâ - Java / Web ¿ª·¢

ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ 
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£

mysqlÃüÁîÐÐģʽÏÂ: ......

MYSQL ÊÂÎñµÄÎÊÌâ

SQL code:

create PROCEDURE aa(SqlCMD1 varchar(8000),SqlCMD2 varchar(8000),SqlCMD3 varchar(8000))
begin
declare exit handler for sqlexception rollback;
start TRANSACTION;
EXECUTE SqlCMD1;
EXE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ