mysql °²×°°ü
MySQL-client-community-5.0.41-0.rhel4.i386.rpm # ¿Í»§¶Ë
MySQL-devel-community-5.0.82-0.rhel4.i386.rpm #¿ª·¢Ê±ÒªÓõÄÍ·ÎļþºÍCÎļþ
MySQL-server-community-5.0.41-0.rhel4.i386.rpm #·þÎñ¶Ë
MySQL-shared-community-5.0.82-0.rhel4.i386.rpm #һЩ¿âÎļþ
perl-DBD-MySQL-2.9004-3.1.i386.rpm
perl-DBI-1.40-5.i386.rpm
Ïà¹ØÎĵµ£º
Ìí¼Ó×ֶεĸñʽ
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" ......
1. ¸ÅÊö
MySQLÊý¾Ý¿âµÄµ¼È룬ÓÐÁ½ÖÖ·½·¨£º
1) Ïȵ¼³öÊý¾Ý¿âSQL½Å±¾£¬ÔÙµ¼È룻
2) Ö±½Ó¿½±´Êý¾Ý¿âĿ¼ºÍÎļþ¡£
ÔÚ²»Í¬²Ù×÷ϵͳ»òMySQL°æ±¾Çé¿öÏ£¬Ö±½Ó¿½±´ÎļþµÄ·½·¨¿ÉÄÜ»áÓв»¼æÈݵÄÇé¿ö·¢Éú¡£
ËùÒÔÒ»°ãÍÆ¼öÓÃSQL½Å±¾ÐÎʽµ¼Èë¡£ÏÂÃæ·Ö±ð½éÉÜÁ½ÖÖ·½·¨¡£
Linux주
2. ·½·¨Ò» SQL½Å±¾ÐÎʽ
²Ù×÷²½ÖèÈçÏ£º
2 ......
Èç¹ûͬÒâϵͳÖÐͬʱ´æÔÚinstall mysqlºÍno—install mysql£¬ÄÇôÔõÑù½øÐÐÁ½¸ö°æ±¾µÄÇл»Ê¹ÓÃÄØ£¿ÓÖ»áÓöµ½Ê²Ã´ÑùµÄÎÊÌâÄØ£¿
Ê×ÏÈ£¬install mysqlµÄmysql·þÎñÊÇĬÈÏÆô¶¯µÄ£¬ÔÚÈÎÎñ¹ÜÀíÆ÷½ø³ÌÖпÉÒÔ¿´µ½¼¸ÌõsqlµÄ×ÖÑÛ£¬Èçmysqld.exe,sqlbrowser¡£ÕâÊÇinstall mysqlµÄ·þÎñ¡£ÄÇôͨ¹ý¿ì½Ý·½Ê½»ònavicat¾ÍÄÜÆô¶¯Ê¹ÓÃinstall ......
1 ÄÚ´æ±íµÄ±í»ú¹¹»¹ÊÇÔÚÊý¾Ý¿âÖеģ¬Ö»ÊÇÊý¾Ýʱ·ÅÔÚÄÚ´æÖеġ£
2 ÄÚ´æ±íÖв»¿ÉÒÔʹÓÃTEXTºÍBLOBÀàÐ͵Ä×ֶΡ£
3 ÄÚ´æ±í¿ÉÒÔͨ¹ýmax_heap_table_size = 2048MÀ´¼Ó´óʹÓõÄÄÚ´æ¡£
1 ÁÙʱ±íµÄ±í»ú¹¹ºÍÊý¾Ý¶¼ÊÇ·ÅÔÚÄÚ´æÖеÄ
¾ßÌå¼ûÏ£º
ÄÚ´æ±íʹÓùþϣɢÁÐË÷Òý°ÑÊý¾Ý±£´æÔÚÄÚ´æÖУ¬Òò´Ë¾ßÓм«¿ìµÄËÙ¶È£¬Êʺϻº´æÖÐСÐÍÊý¾Ý¿ ......