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£¡
Ïà¹ØÎĵµ£º
×¢Ò⣺֮ǰÎÒÔÚÍøÉÏÕÒÁ˺öàµÄ×ÊÁÏ NND¶¼²»ÄÜÕý³£ÅäÖóɹ¦ ¸ãµÃÎÒÊǷdz£µØÓôÃÆ£¡
ÕÒµ½ÕâÆªÎÄÕÂÖ®ºóÎÒÖÕÓÚÅäÖóɹ¦ÁË£¡ÍÛºÃˬѽ£¡Ö»Òª°´ÕÕ ÉÏÃæµÄ²½Öè¾ÍÒ»¶¨Äܹ»³É¹¦µÄ£¡
´ËÎÄյݲװ·½·¨ÊÊÓÃÓÚWindows XPϵÄApache+PHP+MySQL°²×°£¬Í¬Ê±Ò²ÊÊÓÃÓÚWindows 2003ϵͳϵݲװºÍÅäÖá£
1. °²×°»·¾³
²Ù×÷ϵͳÊÇ Window ......
¹²3¸öÎļþ
IncDB.phpÊý¾Ý¿âÁ¬½Ó
index.phpÊ×Ò³
InsetToDB.phpÊý¾Ý¿â²Ù×÷
Êý¾Ý¿âlguestbookÀïÃæ½¨±í
CREATE TABLE `intd` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) character set utf8 collate utf8_bin N ......
Ò»¡¢Á¬½ÓMYSQL
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQLÖÐÁË£¬MYSQLµÄÌáʾ·ûÊÇ£ºmysql>
2¡¢Àý2£ºÁ¬½Óµ½Ô ......
×ÔÖú½¨Õ¾ÔËÓª/ÔËάϵͳ(jboss)°²×°Î¬»¤ÊÖ²á
1.Èí¼þ¸ÅÊö
1.1×ÔÖú½¨Õ¾ÔËÓª/ÔËάϵͳÊÇ»ùÓÚASPÔËӪģʽµÄÆóÒµÔËÓª¹ÜÀíÆ½Ì¨ÏµÍ³£¬ÓɶÀÁ¢µÄÓ¦Ó÷þÎñÆ÷·Ö±ðÌṩͳһÔËÓª¹ÜÀí¹¦ÄÜ¡¢
¸÷²úÆ·ÔËӪϵͳµÄ¹¦ÄÜ¡£
1.2¿ª·¢ÓïÑÔ
±¾ÏµÍ³²ÉÓÃJ2EE¼¼Êõ¼Ü¹¹£¬Ê¹Óõ½java, xml, xsl£¬javascript£¬htmlµÈ¸÷Ïî¼¼Êõ£¬Êý¾Ý¿âÊ¹Ó ......
Ê×ÏÈÄãÒªÀí½â,innodbµÄÖ÷¼üË÷Òý¶¼ÊǾ۴ØË÷Òý,ËüµÄ¸¨ÖúË÷ÒýÀïÃæ¶¼°üº¬ÓбíµÄÖ÷¼ü,¶øÇÒÖ÷¼ü¶¼ÔÚ¸¨ÖúË÷ÒýµÄ×îºóÒ»ÁÐ.¶ømyisamµÄË÷Òý,¶¼ÊÇÆÕͨË÷Òý,´æ´¢µÄÊÇÁеÄÖµ,»¹ÓÐÁÐÔÚÔ±íÖеĵØÖ·Öµ---²»´æ´¢Ö÷¼üÖµ.
ºÃÁË,ÏÂÃæÎÒÃÇ¿ªÊ¼:
ÏÈ´´½¨Á½¸ö±í:Ò»¸öÊÇinnodbÒýÇæµÄ,Ò»¸öÊÇmyisamÒýÇæµÄ
CREATE TABLE `innodb` ( `id` in ......