»¹Ã»ÓнӴ¥MYSQL, ÏÈÇë½ÌÒ»¸öMYSQLµÄSelectÓï¾ä¡£
ÕâÊÇSQL SERVERÖеÄÒ»ÌõÓï¾ä(×¢Òâ±íÃûºÍÁÐÃû¶¼ÊÇÓ÷ûºÅ¿ªÊ¼µÄ)£¬Èç¹û¸ÄÓÃMYSQL£¬Ó¦¸ÃÈçºÎд£º
SELECT [_±íA].[_µÚÒ»ÁÐ], [_±íA].[_µÚ¶þÁÐ], [_±íB].[_µÚÈýÁÐ] from [_±íA] INNER JOIN [_±íB] ON [_±íA].[_µÚÒ»ÁÐ] = [_±íB].[_µÚÒ»ÁÐ]
ÎÒÖ÷ÒªÊÇÏëÖªµÀ£¬ÔÚMySQLµÄSelectÓï¾äÖУ¬ÊÇÈçºÎ´¦ÀíÕâÖÖÌØÊâµÄ±íÃûºÍÁÐÃûµÄ£¬Ð»Ð»¸÷λ¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒ¿ª·¢ASP.netʱ
²åÈëÍâÎÄÂÒÂë
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8
character_set_connection utf8
character_set_database utf8
ch ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿
PHP code:
<?php
$str="select * from product wh ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......