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

mysqlʹÓÃС¼Ç

       ×î½üÓÃmysqlдÁ˼¸¸ö¸´ÔÓµÄÓï¾ä£¬¸Ð¾õÔÚ¹ØÏµºÜ¸´ÔÓµÄʱºòÏÈÀíÇå¹ØÏµÔÙÑ¡ÔñÓõIJéѯ·½·¨ÊǺÜÖØÒªµÄ£¬ÒòΪͬһ¸öÐèÇó¿ÉÄÜÓò»Í¬µÄ·½·¨À´²é³öÀ´£¬µ«ÊǸ´ÔÓ¶È£¬ÐÔÄܶ¼²»Ò»Ñù¡£
      ÏÂÃæËµÒ»ÏÂÄÜʵÏÖ¸´ÔÓ²éѯµÄһЩһ°ã·½·¨£º
Ò».withÓï·¨£¨Ê×ÏÈ˵Ã÷£¬ºÃÏñMysql²»Ö§³ÖÕâ¸öÓï·¨£¬µ«ÊÇsqlserverÊÇÖ§³ÖµÄ£©£¬¼´with tableA as select .... from table B¡£Ï൱ÓÚÔÚÊý¾Ý¿âÖн¨Á¢ÁËÒ»¸öÁÙʱ±í¡£ÆäʵÎÒϲ»¶ÕâÖÖÓï·¨£¬ÒòΪ¿´ÆðÀ´ÏñÊÇÃæÏò¶ÔÏóµÄ£¬½á¹¹ÇåÎú¡£
¶þ.½¨Á¢ÁÙʱ±í£¬¼´create temporary table{...},ÆäËûÀàËÆÁË£¬µ«ÊÇÍøÉÏ˵ÕâÖÖ·½·¨¿ªÏúºÜ´ó£¬½¨Ò鿼ÂÇÐÔÄܵÄÓ¦ÓÃÉ÷Óá£
Èý.ǶÌײéѯ£¬¼´select a,b from (select a* as a, b* as b from A*) as A...,ÕâÊǺܳ£Óõķ½·¨£¬Ò²ºÜºÃÓã¬ÐÔÄÜÓ¦¸ÃÒ²²»´í¡£
ËÄ.¸÷ÖÖÁ¬½Ó£¬¼´select a ,b,c from A inner join B inner join C, ÕâÖֽṹÉϵ¹ÊÇÒ²ºÜÇåÎú£¬µ«ÊÇ×î´óµÄȱµã¾ÍÊÇÈßÓàÊý¾ÝÌ«¶à£¬Ôö¼Óϵͳ¸ºµ££¬ÒòΪ±íÖеÄÁÐÄã¶¼¸øÁ¬½Ó¹ýÀ´ÁË£¬¶øÊµ¼ÊÉÏÊǸù±¾Óò»ÁËÕâô¶àµÄ£¨¿ÉÄÜÖ»ÐèҪÿ¸ö±íÖÐÌØ¶¨µÄ¼¸ÁУ©£¬ÕâÑùÔì³ÉÁ¬½ÓºóµÄ±íÌ«ÅÓ´óÁË£¬ÐÔÄÜÓ¦¸ÃºÜ²î ¡£ ËùÒÔÔÚÄãÈ·¶¨ÈßÓàÊý¾Ý²»¶àʱ£¬¿ÉÒÔÓÃÕâÖÖ·½·¨¡£
×Ô¼ºµÄÐĵ㬿ÉÄÜÒ²²»ÍêÈ«¡£ÆäÊµÕæÕýÓõÄʱºòÊǼ¸ÖÖ·½·¨½áºÏÆðÀ´¸üºÃ£¬±ÈÈç
select a,b from (select a* as a from A*) as A inner join (select b* as b from B*) as B on A.some=B.some where a='hello';


Ïà¹ØÎĵµ£º

C# ODBC·ÃÎÊMySQLÊý¾Ý¿â

·Ï»°²»ËµÁË£¬Ö±½Ó½øÈëÖ÷Ì⣬C# ODBC·ÃÎÊMySQLÊý¾Ý¿â£º
1.°²×°Microsoft ODBC.net£ºÎÒ°²×°µÄÊÇmysql-connector-odbc-3.51.22-win32.msi
2.°²×°MDAC 2.7»òÕ߸ü¸ß°æ±¾£ºÎÒ°²×°µÄÊÇmdac_typ.exe 2.7¼òÌåÖÐÎİæ
3.°²×°MySQLµÄODBCÇý¶¯³ÌÐò£ºÎÒ°²×°µÄÊÇ odbc_net.msi
4.¹ÜÀí¹¤¾ß -> Êý¾ÝÔ´ODBC –>ÅäÖÃDSN… ......

MySQLɾ³ýÖ¸¶¨ÐÐ

mysql> select * from tx;
+------+
| id   |
+------+
|    4 |
|    7 |
|    3 |
|    9 |
|    5 |
+------+
5 rows in set (0.05 sec)
mysql> delete a from tx a inner join (select * from tx limit 2,2) b ......

.netÁ´½ÓmysqlÊý¾Ý¿â£¬²Ù×÷Ôöɾ¸Ä²é¡£

ÁíÍâMySql¹Ù·½³öÁËÒ»¸öÔÚcsharpÀïÃæÁ¬½ÓMySqlµÄConnector£¬¿ÉÒÔÊÔÊÔ
http://dev.mysql.com/downloads/#connector-net
<add name="mysql" connectionString="server=125.46.37.170;uid=root;pwd=;"/>
±¨´í£ºUnable to connect to any of the specified MySQL hosts.
½ñÌì×öÏîĿʱºò¾ÍÓöµ½ÕâÎÊ ......

ʵÏÖPHP·ÃÎÊMYSQLÊý¾Ý¿âµÄÀà

PHPµÄÒ»¸öÊý¾Ý¿â²Ù×÷Àà,ÒÔUTF8¸ñʽдÈë,Êý¾Ý¿âÄÚÖ±½ÓÏÔʾÕý³£ÖÐÎÄ,·ÀÖ¹²éѯ³ö´í
/**
* @author xggxnn
* ±¾ÀàÓÃÓÚʵÏÖÓйØÊý¾Ý¿âµÄ·ÃÎÊ
*
*/
class DBConnection {
private $host = "";
private $user = "";
private $pass = "";
private $DBname = "";
public $isConnected = false;
/**
* ¹¹Ôìº ......

MySQL ±àÂë»úÖÆ

Ò»°ãÔÚMYSQLʹÓÃÖÐÎIJéѯ
¶¼ÊÇÓà set NAMES character
character_set_client £¬ÕâÊÇÓû§¸æËßMySQL²éѯÊÇÓõÄʲô×Ö·û¼¯¡£
character_set_connection £¬MySQL½ÓÊܵ½Óû§²éѯºó£¬°´ÕÕcharacter_set_client½«Æäת»¯Îªcharacter_set_connectionÉ趨µÄ×Ö·û¼¯¡£
character_set_results £¬ MySQL½«´æ´¢µÄÊý¾Ýת»»³Écharact ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ