MySql¼òÒױʼÇ
MySql¼òÒױʼÇ
1£º°²×°http://download.mysql.cn/src/2006/0710/5543.html£»
2£º´ò¿ªmysqlµÄCMD
3£º´´½¨Ò»¸öÊý¾Ý¿â¼°±í£º
mysql> CREATE DATABASE bbs;
mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
4£º²é¿´£º
show databases;
show tabales;
describe pet;
5:µ¼³ö³É*.sqlÎļþ
ÔÚϵͳcmdÏÂʹÓÃÃüÁmysqljump -u root –p test > c:\test.sql
»ù±¾¹¦ÄܾʹËOK£¡
Ïà¹ØÎĵµ£º
²éѯ¼°É¾³ýÖØ¸´¼Ç¼µÄ·½·¨
(Ò»)
1¡¢²éÕÒ±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖØ¸´¼Ç¼£ ......
Á½¸öÔÂǰ£¬Ò²¾ÍÊÇ9Ô·ݣ¬ÐÄѪÀ´³±ÔÚwindowsÏÂʵÏÖÁËÓÃCÁ¬½ÓÊý¾Ý¿â£¬µ±Ê±ºÜÊÇÓаÑlinuxÏÂÒ»²¢¸øÊµÏÖÁË¡£µ«ÊÇûÓÐÏëµÃÄÇô¼òµ¥¡£Õâ¸öÈÎÎñÒ»Ö±ÍÆ³Ùµ½ÁËÏÖÔÚ²ÅÍê³É£¬¾¿ÆäÔÒò£º1.ÎÒÖ±½ÓÓÃeclipse¿ª·¢¹¤¾ß£¬¶ÔÓÚ»·¾³±äÁ¿µÄÉèÖò»ÊǺÜÊì¡£2.linuxϵͳ¿âÎļþ½á¹¹²»ÊìϤ£¬¶ÔÓÚmysqlÌṩµÄ¿âÎļþûÓÐ·Å¶Ô ......
http://blog.csdn.net/iamstillzhang/archive/2007/04/01/1548377.aspx
ÓÃmysqlÔ´Âë½øÐÐSQL½âÎö
MysqlÊÇͨ¹ýyacc½øÐÐSQLÓï¾ä½âÎöµÄ£¬ÕâÀï½éÉÜÒ»ÏÂÈçºÎʹÓÃmysqlµÄÔ´Âë½øÐÐSQLÓï¾ä½âÎö¡£ÓÉÓÚMysqlµÄÔ´´úÂë×¢ÊͱȽÏÉÙ£¬¶øÇÒȱÉÙ×ÊÁÏ£¬ËùÓÐЩµØ·½Ñо¿²»¹»ÉîÈë¡£
1 Filed½éÉÜ
MY ......
×ÔÖú½¨Õ¾ÔËÓª/ÔËάϵͳ(jboss)°²×°Î¬»¤ÊÖ²á
1.Èí¼þ¸ÅÊö
1.1×ÔÖú½¨Õ¾ÔËÓª/ÔËάϵͳÊÇ»ùÓÚASPÔËӪģʽµÄÆóÒµÔËÓª¹ÜÀíÆ½Ì¨ÏµÍ³£¬ÓɶÀÁ¢µÄÓ¦Ó÷þÎñÆ÷·Ö±ðÌṩͳһÔËÓª¹ÜÀí¹¦ÄÜ¡¢
¸÷²úÆ·ÔËӪϵͳµÄ¹¦ÄÜ¡£
1.2¿ª·¢ÓïÑÔ
±¾ÏµÍ³²ÉÓÃJ2EE¼¼Êõ¼Ü¹¹£¬Ê¹Óõ½java, xml, xsl£¬javascript£¬htmlµÈ¸÷Ïî¼¼Êõ£¬Êý¾Ý¿âÊ¹Ó ......
Ê×ÏÈÄãÒªÀí½â,innodbµÄÖ÷¼üË÷Òý¶¼ÊǾ۴ØË÷Òý,ËüµÄ¸¨ÖúË÷ÒýÀïÃæ¶¼°üº¬ÓбíµÄÖ÷¼ü,¶øÇÒÖ÷¼ü¶¼ÔÚ¸¨ÖúË÷ÒýµÄ×îºóÒ»ÁÐ.¶ømyisamµÄË÷Òý,¶¼ÊÇÆÕͨË÷Òý,´æ´¢µÄÊÇÁеÄÖµ,»¹ÓÐÁÐÔÚÔ±íÖеĵØÖ·Öµ---²»´æ´¢Ö÷¼üÖµ.
ºÃÁË,ÏÂÃæÎÒÃÇ¿ªÊ¼:
ÏÈ´´½¨Á½¸ö±í:Ò»¸öÊÇinnodbÒýÇæµÄ,Ò»¸öÊÇmyisamÒýÇæµÄ
CREATE TABLE `innodb` ( `id` in ......