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

vs2005Á¬½ÓmysqlÊý¾Ý¿â

Vs2005Á¬½ÓmysqlÊý¾Ý¿â
Ò»¡¢ÏÂÔØÖ§³ÖmysqlµÄ΢ÈíµÄͨÓÃÀàmysql-connector-net-1.0.7-noinstall.zip
¶þ¡¢ÏÂÔØµØÖ·http://www.cnblogs.com/eugenewu0808/archive/2006/10/11/mysqldata.html
Èý¡¢½âѹÎļþ
ËÄ¡¢Ìí¼ÓÒýÓÃÕÒµ½binÎļþ¼ÐÕÒµ½net-2.0 vs2005µÄ£¨ºÍvsÏàÓ¦°æ±¾µÄ£©ÕÒµ½MySql.Data.dll
Îå¡¢ÔÚÀàÖÐÒýÓÃusing MySql.Data.MySqlClient;µÄÃüÃû¿Õ¼ä
Áù¡¢¾ßÌåÁ¬½Ó£º
1. Á¬½Ó×Ö·û´®1
string connStr = String.Format("server={0};user id={1}; password={2}; database={3}; pooling=false;port=3306", "127.0.0.1", "test", "test", "test");
2. Á¬½Ó×Ö·û´®2
string connecStr=“Database='testdb';Data Source='localhost';User Id='db';Password='apple';charset='utf8'”
3.Ó¦ÓÃ
 MySqlConnection myConn = new MySqlConnection(connStr);
           myConn.Open();
           MySqlCommand cmd = myConn.CreateCommand();


Ïà¹ØÎĵµ£º

ÊÕ¼¯Ò»Ð©mysqlʹÓ÷½·¨

1.linuxÏÂÆô¶¯mysqlµÄÃüÁ
  mysqladmin start
/ect/init.d/mysql start (Ç°ÃæÎªmysqlµÄ°²×°Â·¾¶)
2.linuxÏÂÖØÆômysqlµÄÃüÁ
  mysqladmin restart
/ect/init.d/mysql restart (Ç°ÃæÎªmysqlµÄ°²×°Â·¾¶)
3.linuxϹرÕmysqlµÄÃüÁ
  mysqladmin shutdown
  /ect/init.d/mysql&nbs ......

MYSQl left joinÁªºÏ²éѯЧÂÊ·ÖÎö

user±í:
id | name
———
1 | libk
2 | zyfon
3 | daodao
user_action±í:
user_id | action
—————
1 | jump
1 | kick
1 | jump
2 | run
4 | swim
sql:
select id, name, action from user as u
left join user_action a on u.id = a.user_id
result:
id | ......

ÎÞ·¨ÔØÈë mysql À©Õ¹£¬Çë¼ì²é PHP ÅäÖá­¡­½â¾ö°ì·¨

PS:ÎÒ½ñÌìÅäÖà ·þÎñÆ÷µÄʱºò³öÏÖµÄÎÊÌâ¾ÍÊÇÕâ¸ö£¬µ«ÊÇÕÕ×Å·½·¨¶¼×öÁË£¬Ñ¾µÄ¡£¡£»¹ÊÇûÓ㬼«¶ÈÓôÃÆËÀ¡£¡£°¥¡£¡£¡£ÎÒÒ²²»ÖªµÀʲôԭÒòÄØ¡£¡£¿ÉÄܵÄÔ­Òò¶¼ÕÒ¹ýÁË¡£¡£ÓôÃÆ°¡`~
apache2+mysql+php5+phpmyadminÅäÖÃÎÊÌ⣺ÎÞ·¨¼ÓÈëmysqlÀ©Õ¹£¬Çë¼ì²éphpÅäÖÃ...
°²×°Íêapache2+mysql+php5ºó£¬°²×°phpmyadmin²¢ÅäÖúÃÒÔºó£¬ÔÚä¯À ......

MySQL Êý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´

 
mysql,mysqldump,µ¼³ö,µ¼³ö±í,ѹËõµ¼³ömysql,mysqlhotcopy,mysql»¹Ô­±í
±¾ÎÄÌÖÂÛ MySQL µÄ±¸·ÝºÍ»Ö¸´»úÖÆ£¬ÒÔ¼°ÈçºÎά»¤Êý¾Ý±í£¬°üÀ¨×îÖ÷ÒªµÄÁ½ÖÖ±íÀàÐÍ£ºMyISAM
ºÍ Innodb
£¬ÎÄÖÐÉè¼ÆµÄ MySQL °æ±¾Îª 5.0.22¡£
Ŀǰ MySQL Ö§³ÖµÄÃâ·Ñ±¸·Ý¹¤¾ßÓУºmysqldump¡¢mysqlhotcopy
£¬»¹¿ÉÒÔÓà SQL Óï·¨½øÐб¸·Ý£ºBACK ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ