¿ÉÁ¯µÄSun¹«Ë¾£¬ÒòΪÊÕ¹ºÁËMySQL£¬ÏëÂô×Ô¼º¶¼Âô²»ÁËÁË
write by ¾ÅÌìÑãôá(JTianLing) -- blog.csdn.net/vagrxie ÌÖÂÛÐÂÎÅ×é¼°Îļþ ½ñÌì¿´µ½CSDNÉϵÄÒ»ÔòÐÂÎÅ¡¶Å·ÃËÕýʽ·ñ¾ö¼×¹ÇÎÄÊÕ¹ºSun ¼×¹ÇÎľÝÀíÁ¦Õù¡·ºóÕæÊǸÐ̾°¡¡£¡£¡£¡£ SunÒ²ËãÊÇÊ¢¼«Ò»Ê±µÄ´ó¹«Ë¾ÁË£¬ÒòΪJAVAÓïÑÔ¶øÎÅÃûÓÚÊÀ£¬ºóÀ´¹ÉƱ´úÂ붼¸Ä³ÉJAVAÁË£¬ËäÈ»JAVAʵ¼ÊÉÏûÓÐΪÆä´øÀ´Ì«¶àµÄÀûÈ󣬵«ÊÇSunÒ²ËãÊÇÄܹ»×Ô¼ºÌṩӲ¼þ+Èí¼þÈ«Ì×µÄÆóÒµ¼¶½â¾ö·½°¸µÄÉÙÊý¹«Ë¾Ö®Ò»ÁË£¬µ±ÄêÊÕ¹ºMySQLµÄʱºò»¹ÊÇ·ç·ç»ð»ð°¡£¬ÍêÉÆÁË×Ô¼º²úÆ·Á´ÖÐ×îºóµÄÈõ»·£¬³É¾ÍÁË¿ªÔ´ÊÀ½ç×î´óµÄÒ»±ÊÊÕ¹º°¸£¬SunÒ²´Ó´ËÓÐÁË´ÓSPARC´¦ÀíÆ÷ £¬´æ´¢É豸µÈÓ²¼þ£¬µ½JAVAÓïÑÔ£¬Solaris²Ù×÷ϵͳ£¬MySQLÊý¾Ý¿âµÈÈí¼þµÄÍ걸²úÆ·Á´£¬Ò»Ê±¼äËƺõ³ÉΪÁ˳ýIBMÒÔÍ⣬·þÎñÆ÷£¬¹¤×÷Õ¾£¬ÆóÒµ¼¶½â¾ö·½°¸ÖÐ×îÅ£µÄ¹«Ë¾£¬¿Éϧ°¡¿Éϧ¡£¡£¡£¡£¡£ µ±Äê¾¼ÃÇé¿öºÃµÄʱºò£¬´óÆóÒµºÜHappyµÄÉÕÇ®£¬×ÌÈóÁËSunÕâÑùµÄ¹«Ë¾£¬µ«ÊÇ£¬¾¼ÃΣ»úÒ»µ½£¬´ó¼ÒÊÕËõÁËÒø¸ù£¬Sun¾Í²»ºÃ¹ýÁË£¬¿ªÔ´µÄJAVAºÍMySQL¶¼²»¿ÉÄÜÕü¾ÈSun¡£ ×î×î¿ÉÁ¯µÄÊÇ£¬½ñÌìSunÏë°Ñ×Ô¼ºÂô¸øOracle£¬µ«ÊÇÈ´ÒòΪMySQLµÄÔÒò£¬µ¼ÖÂÔÚÅ·ÃËÕâÀïͨ²»¹ý£¬ÕæÊÇÈÃÈ˸Ð̾°¡¡£¡£¡£¡£¡£¡£ »ù±¾ÉÏ£¬ÕâÒ²¿ÉÒÔ¿´×öÊÇITÀúÊ·ÉÏÁíÒ»ÆðÒòΪӯÀûģʽ̫µ¥Ò»µ¼ÖµĴàÈõ°É£¬ÄÄÅÂÊÇSunÕâÑùµÄ¹«Ë¾£¬·¸ÁË´Ë´í£¬Ò²ÌÓ²»Á˿ɱ¯µÄÃüÔË¡£ µ±Ä꣬ËÓÖÄÜÏëµ½£¬ÄÇÊÇSun¶ÔMySQLµÄÊÕ¹º°¸»áµ¼ÖÂÏÖÔÚÕâÑùµÄºó¹ûÄØ£¿Ö»Ì¸ÀúÊ·µÄÏ·¾çÐÔ°¡¡£ Ô´´ÎÄÕÂ×÷Õß±£Áô°æȨ תÔØÇë×¢Ã÷Ô×÷Õß ²¢¸ø³öÁ´½Ó write by ¾ÅÌìÑãôá(JTianLing) -- blog.csdn.net/vagrxie var sitebro_tracker_atc_kw = {u:'http://www.sitebot.com.cn/754892/',w:'NzU0ODky',bt:'#804000',bg:'#EEEEDD',fs:1,ca:'#770000',bh:'#f4f4c6',cp:'',l:10,s:1,lang:'zh_CN'};
Ïà¹ØÎĵµ£º
Ìí¼Ó×ֶΣº
MYSQL
alter table tb add col2 varchar(10)
MSSQL2000
alter table tb add col2 varchar(10)
ÐÞ¸Ä×ֶΣº
MYSQL
alter table tb modify col2 varchar(20)
MSSQL2000
alter table tb alter column col2 varchar(20)
ɾ³ý×ֶΣº
MYSQL
alter table tb drop column col ......
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......
½¨Á¢Ò»¸öÖ÷Íâ¼ü¹Øϵ
create table t_dept(
id int(4) not null, name varchar(50) not null,
primary key(id))type=innodb;
create table t_emp (
id int(6) not null,
name char(255) not null,fk_id int(4) not null,
primary key(id),
foreign key (fk_id) references t_dept (id)) type=innodb; ......
×ÔÖú½¨Õ¾ÔËÓª/ÔËάϵͳ(jboss)°²×°Î¬»¤ÊÖ²á
1.Èí¼þ¸ÅÊö
1.1×ÔÖú½¨Õ¾ÔËÓª/ÔËάϵͳÊÇ»ùÓÚASPÔËӪģʽµÄÆóÒµÔËÓª¹ÜÀíƽ̨ϵͳ£¬ÓɶÀÁ¢µÄÓ¦Ó÷þÎñÆ÷·Ö±ðÌṩͳһÔËÓª¹ÜÀí¹¦ÄÜ¡¢
¸÷²úÆ·ÔËӪϵͳµÄ¹¦ÄÜ¡£
1.2¿ª·¢ÓïÑÔ
±¾ÏµÍ³²ÉÓÃJ2EE¼¼Êõ¼Ü¹¹£¬Ê¹Óõ½java, xml, xsl£¬javascript£¬htmlµÈ¸÷Ïî¼¼Êõ£¬Êý¾Ý¿âÊ¹Ó ......
Ê×ÏÈÄãÒªÀí½â,innodbµÄÖ÷¼üË÷Òý¶¼ÊǾ۴ØË÷Òý,ËüµÄ¸¨ÖúË÷ÒýÀïÃ涼°üº¬ÓбíµÄÖ÷¼ü,¶øÇÒÖ÷¼ü¶¼ÔÚ¸¨ÖúË÷ÒýµÄ×îºóÒ»ÁÐ.¶ømyisamµÄË÷Òý,¶¼ÊÇÆÕͨË÷Òý,´æ´¢µÄÊÇÁеÄÖµ,»¹ÓÐÁÐÔÚÔ±íÖеĵØÖ·Öµ---²»´æ´¢Ö÷¼üÖµ.
ºÃÁË,ÏÂÃæÎÒÃÇ¿ªÊ¼:
ÏÈ´´½¨Á½¸ö±í:Ò»¸öÊÇinnodbÒýÇæµÄ,Ò»¸öÊÇmyisamÒýÇæµÄ
CREATE TABLE `innodb` ( `id` in ......