mysqlºÍmssqlÓÐÊ²Ã´Çø±ð£¿
ͨ¹ýODBC½¨Á¢ÎļþDSN£¬²âÊÔʱ±¨¾¯£ºcan't connect to mysql sercer on '192.168.12.101' (10061). ÊDz»ÊÇÒªÏÂÔØMYSQLÊý¾Ý¿â£¬²»ÄÜÓÃMSSQLÊý¾Ý¿â£¿
mssql-> microsoft sql mysqlÓÃmysqlconnectionÒýÓà mysqlÓÃmysqlconnection ÒýÓà mssql-> microsoft sql ÄãÏÖÔÚÓÃµÄ ÊÇ mysqlµÄÁ´½Ó£¬mysqlÊǸö¿ªÔ´µÄÓÃÓÚÖÐСÐ͵ÄÊý¾Ý¿â£¬ÏÖÔÚ±»sunÊÕ¹ºÁË mssq=mssqlserver ÊÇ΢ÈíµÄsql server Äã¾õµÃÊÇÒ»ÑùµÄ£¿ 1.Ò»¸ö´óÒ»¸öС¡£2.Ò»¸öרҵ£¬°²È«£¬Ò»¸ö¼¶±ðµÍ ÉèÖÃDSNʱѡÔñµÄÊý¾ÝÔ´²»¶Ô°É£¬ÒªÁ¬½ÓʲôÊý¾Ý¿â¾ÍÑ¡ÔñÏàÓ¦µÄÊý¾ÝÔ´£¬Òª¶ÔÓ¦ »¹ÊDz»Ã÷°×£¡
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂ𣿠ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡ ×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£ win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£ µ±È»Äã×î ......
MYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï. ÇóʵÏÖÕâ¸öЧ¹ûµÄÃüÁî SQL code: update ±í set introtxt=left(`fulltext`,300); ¶¥£¬Ñ§Ï° SQL code: ......
ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл ½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£ http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......
ÇëÎÊһϴó¼ÒÓÐûÓÐÈËÅäÖùýmysqlµÄiniµÄÅäÖÃÎļþ£¬ÏÖÔÚÎÒÓÐÒ»¸öÎÊÌâ¾ÍÊÇ.ÏÖÔÚ±íÖÐ35ÍòÌõµÄÊý¾Ý²éѯ³öÀ´ÊÇûÓÐÎÊÌâµÄ£¬µ«Êǵ±Êý¾Ý¿â´ïµ½°ÙÍòÒÔÉÏÊý¾Ý¾Í²éѯ²»³öÀ´ÁË£¬£¨Ç°ÌáÊÇͬÑùµÄÌõ¼þÀ´×öÕâÁ½´ÎÊý¾Ý²éѯ² ......
select * from table where '123456789' like '%'+×ֶαí+'%' Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ SQL code: select * from table whe ......