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

Mysql°²×°°æÓëÃâ°²×°°æµÄÇл»Ê¹ÓÃ

Èç¹ûͬÒâϵͳÖÐͬʱ´æÔÚinstall mysqlºÍno—install mysql£¬ÄÇôÔõÑù½øÐÐÁ½¸ö°æ±¾µÄÇл»Ê¹ÓÃÄØ£¿ÓÖ»áÓöµ½Ê²Ã´ÑùµÄÎÊÌâÄØ£¿
Ê×ÏÈ£¬install mysqlµÄmysql·þÎñÊÇĬÈÏÆô¶¯µÄ£¬ÔÚÈÎÎñ¹ÜÀíÆ÷½ø³ÌÖпÉÒÔ¿´µ½¼¸ÌõsqlµÄ×ÖÑÛ£¬Èçmysqld.exe,sqlbrowser¡£ÕâÊÇinstall mysqlµÄ·þÎñ¡£ÄÇôͨ¹ý¿ì½Ý·½Ê½»ònavicat¾ÍÄÜÆô¶¯Ê¹ÓÃinstall mysqlÁË¡£
Çл»no-install mysql£º
1¡¢°ÑÎñ¹ÜÀíÆ÷½ø³ÌÖÐmysqlld.exe,sqlbrowseµÈ½ø³Ì¹Øµô¡£
2¡¢ÕÒµ½no-install mysqlµÄ·¾¶½øÈë¸ùĿ¼£¬ÓÐStartMysql.batºÍStopMysql.bat,·Ö±ðÊÇÆô¶¯ºÍ¹Ø±ÕmysqlµÄÅú´¦ÀíÎļþ£¬Ë«»÷StartMysql.bat¡£
3¡¢´ò¿ªdosÔËÐд°¿Ú£¬½øÈëno-install mysqlµÄ·¾¶ÏµÄbinµÄÎļþ¼ÐÔËÐÐmysql -uroot -pÃüÁOkÊäÈëÃÜÂë°É¡£¿ÉÒÔ¿ªÊ¼Ê¹ÓÃno-install mysqlÁË¡£
Çл»»Øinstall mysql
1¡¢ÕÒµ½no-install mysqlµÄ·¾¶½øÈë¸ùĿ¼£¬ÓÐStartMysql.batºÍStopMysql.bat,·Ö±ðÊÇÆô¶¯ºÍ¹Ø±ÕmysqlµÄÅú´¦ÀíÎļþ£¬Ë«»÷StopMysql.bat¡£
2¡¢ÕÒµ½install mysqlµÄ°²×°Â·¾¶½øÈëbinÎļþ¼Ð£¬Ë«»÷mysqld.exe.
3¡¢okÓֻص½ÁËinstall mysql״̬


Ïà¹ØÎĵµ£º

mysql dataÎļþ¼ÐϵÄibdata1 Îļþ×÷ÓÃ


Õâ¸öÎļþ³¬¼¶´ó£¬ ²éÁËһϣ¬ ´ó¸ÅµÄ×÷ÓÃÈçÏÂ
ÊÇ´¢´æµÄ¸ñʽ
INNODBÀàÐÍÊý¾Ý״̬Ï£¬
ibdataÓÃÀ´´¢´æÎļþµÄÊý¾Ý
¶ø¿âÃûµÄÎļþ¼ÐÀïÃæµÄÄÇЩ±íÎļþÖ»Êǽṹ¶øÒÑ
ÓÉÓÚmysql4.1ĬÈÏÊÔinnodb£¬ËùÒÔÕâ¸öÎļþĬÈϾʹæÔÚÁËhttp://man.chinaunix.net/database/mysql/inonodb_zh/2.htm Õâ¸öÁ´½ÓÊÔinnodbµÄÖÐÎIJο¼£¬ innodbµÄ¶« ......

Ìí¼Ó/ɾ³ýMySQLÊý¾Ý¿â±íÖеÄ×Ö¶Î

Ìí¼Ó×ֶεĸñʽ
ALTER [ONLINE | OFFLINE] [IGNORE] TABLE tbl_name alter_specification [, alter_specification] ...alter_specification: table_option ... | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name ]
eg.
ALTER TABLE myTbl ADD COLUMN newItem VARCHAR(20) DEFAULT "0"  ......

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 ......

ÓÉMySQLÖÐcharºÍvarcharЧÂÊÏëµ½µÄ

¶Ô±ÈcharºÍvarcharËæ±ãÔÚgoogle»ò°Ù¶ÈÖÐËÑһϵõ½µÄ½áÂÛ´ó¸Å¶¼ÊÇ"char¶¨³¤,varchar²»¶¨³¤,charÒª±ÈvarcharÕ¼Óøü¶àµÄ¿Õ¼ä,ÓÉÓÚ¶¨³¤charµÄЧÂʸßÓÚvarchar,char×î´ó255,varchar×î´ó65536"¸ü¸ß¼¶Ò»µãµÄÊý¾ÝÊÇ"charÔÚ´æÈëºÍÈ¡³öµÄʱºò,»á×Ô¶¯°ÑĩβµÄ¿Õ¸ñÈ¥µô,varchar»á¶îÍâµÄ¶àÓÃ1-2¸ö×Ö½ÚÀ´´æ·Å×Ö·û³¤¶È,ÁÐÖÐÓÐÒ»¸övarchar» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ