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

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»Ã÷°×£¡


Ïà¹ØÎÊ´ð£º

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

MYSQL Êý¾Ý½ØÈ¡

MYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï.
ÇóʵÏÖÕâ¸öЧ¹ûµÄÃüÁî
SQL code:
update ±í set introtxt=left(`fulltext`,300);

¶¥£¬Ñ§Ï°

SQL code: ......

mysql´¢´æ¹ý³ÌµÄÎÊÌâ

ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£

http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......

mysqlÉÏÏÞÎÊÌâ

  ÇëÎÊһϴó¼ÒÓÐûÓÐÈËÅäÖùýmysqlµÄiniµÄÅäÖÃÎļþ£¬ÏÖÔÚÎÒÓÐÒ»¸öÎÊÌâ¾ÍÊÇ.ÏÖÔÚ±íÖÐ35ÍòÌõµÄÊý¾Ý²éѯ³öÀ´ÊÇûÓÐÎÊÌâµÄ£¬µ«Êǵ±Êý¾Ý¿â´ïµ½°ÙÍòÒÔÉÏÊý¾Ý¾Í²éѯ²»³öÀ´ÁË£¬£¨Ç°ÌáÊÇͬÑùµÄÌõ¼þÀ´×öÕâÁ½´ÎÊý¾Ý²éѯ² ......

mysql like ÎÊÌâ

select * from table where '123456789' like '%'+×ֶαí+'%'


Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ