ÕæµÄºÜ¼±£¬ºÜ¼±£¡mysql ÁªºÏ²éѯ
SQL code:
select `product_hardware_view`.`ProductID`,`product_hardware_view`.`Version`,
`product_hardware_view`.`Price` , `product_software_view`.`Price`
from `product_hardware_view`,`product_software_view`
where `product_hardware_view`.`ProductID` = `product_software_view`.`ProductID`
²éѯ³öÀ´µÄ½á¹û
id version price price_1
1 1.0.1.1 12 null
2 1.0.2.2 13 null
3 1.0.3.3 14 null
4 1.0.4.4 null 12
5 1.0.5.5 null 13
6 1.0.6.6 null null
7 1.0.7.7 null null
ÓÃʲôÑùµÄÓï¾ä¿ÉÒÔ°ÑpriceºÍprice_1ÔÚÒ»¸öÁÐÖÐÏÔʾ
´óϺ°ï°ï棬СµÜÔÚÏßµÈ
ÓÃʲôÑùµÄÓï¾ä¿ÉÒÔ°ÑpriceºÍprice_1ÔÚÒ»¸öÁÐÖÐÏÔʾ
¾ÙÀý˵Ã÷
id version price
1 1.0.1.1 12
2 1.0.2.2 13
3 1.0.3.3 14
4 1.0.4.4 12
5 1.0.5.5 13
6 1.0.6.6 null
7 1.0.7.7 null
ÎÒÏëÒªµÄ½á¹ûÊÇÕâÑùµÄ¡£
¸÷λ´óϺ°ï°ïæ
Ïà¹ØÎÊ´ð£º
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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.
¿ ......
ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿
¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º
SQL code:
update tb_blog set memo=concat( ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë
Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ
Ö§³Ö£¬¼ì² ......