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״̬
Ïà¹ØÎĵµ£º
Õâ¸öÎļþ³¬¼¶´ó£¬ ²éÁËһϣ¬ ´ó¸ÅµÄ×÷ÓÃÈçÏÂ
ÊÇ´¢´æµÄ¸ñʽ
INNODBÀàÐÍÊý¾Ý״̬Ï£¬
ibdataÓÃÀ´´¢´æÎļþµÄÊý¾Ý
¶ø¿âÃûµÄÎļþ¼ÐÀïÃæµÄÄÇЩ±íÎļþÖ»Êǽṹ¶øÒÑ
ÓÉÓÚmysql4.1ĬÈÏÊÔinnodb£¬ËùÒÔÕâ¸öÎļþĬÈϾʹæÔÚÁËhttp://man.chinaunix.net/database/mysql/inonodb_zh/2.htm Õâ¸öÁ´½ÓÊÔinnodbµÄÖÐÎIJο¼£¬ innodbµÄ¶« ......
Ìí¼Ó×ֶεĸñʽ
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Êý¾Ý¿â£º
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> 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 ......
¶Ô±ÈcharºÍvarcharËæ±ãÔÚgoogle»ò°Ù¶ÈÖÐËÑһϵõ½µÄ½áÂÛ´ó¸Å¶¼ÊÇ"char¶¨³¤,varchar²»¶¨³¤,charÒª±ÈvarcharÕ¼Óøü¶àµÄ¿Õ¼ä,ÓÉÓÚ¶¨³¤charµÄЧÂʸßÓÚvarchar,char×î´ó255,varchar×î´ó65536"¸ü¸ß¼¶Ò»µãµÄÊý¾ÝÊÇ"charÔÚ´æÈëºÍÈ¡³öµÄʱºò,»á×Ô¶¯°ÑĩβµÄ¿Õ¸ñÈ¥µô,varchar»á¶îÍâµÄ¶àÓÃ1-2¸ö×Ö½ÚÀ´´æ·Å×Ö·û³¤¶È,ÁÐÖÐÓÐÒ»¸övarchar» ......