ÓйØ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µÄ´¥·¢Æ÷ÎÒûÓÐÓùý. Äܲ»Äܰïæָµ¼Ö¸µ¼.˳±ãÎÒҲѧϰѧϰд·¨? ÕâÖ־Ͳ»ºÃÔÙÎÊÁ˰ɣ¿ ×Ô¼º·ÊÖ²á°É
Ïà¹ØÎÊ´ð£º
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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. ¿ ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÓÐÒ»Ìõ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 ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ 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 ......