Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysql ´´½¨±í²¢ÉèÖÃÖ÷¼ü×ÔÔö

mysql ´´½¨±í£º
mysql> create table user(
    -> userid int(4) primary key not null auto_increment,
    -> username varchar(16) not null,
    -> userpassword varchar(32) not null
    -> );
create table log(
logid int(4) primary key not null auto_increment,
logtitle varchar(32) not null,
logcontent varchar(160) not null,
logtime datetime not null,
userip varchar(64) not null
);


Ïà¹ØÎĵµ£º

mysqlÖÐIN×Ó²éѯÅÅÐò

Õ⼸Ìì×öÒ»¸ö²éѯ£¬ÐèÒªÔÚÒ»¸öÖ¸¶¨µÄ½á¹û¼¯ÖнøÐвéѯ£¬ÀýÈ磺
select * from table_name where doc_id IN ('1dba', 'c20a', '907b')
ÆäÖÐIN×Ó¾äÖеÄdoc_idÁбíÊÇͨ¹ýµ÷ÓÃÒ»¸öÍⲿ½Ó¿Ú»ñµÃÒ»×édoc_id³£Á¿ÁÐ±í£¬È»ºóÔÚ±¾µØ¿âÖÐËÑË÷·ûºÏÕâ¸öÁбíµÄÊý¾Ý
¼Ç¼¡£ºóÀ´·¢ÏÖmysql·µ»ØµÄ½á¹û¼¯µÄÅÅÐòÊǰ´ÕÕÈë¿â˳Ðò¸ø³öµÄ£¬µ«ÊÇÎÒ ......

MysqlÃüÁî

MySQL ÃüÁîÐÐ
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö² ......

¡¶PHPºÍMySQL Web¿ª·¢¡·±Ê¼Ç֮ʹÓÃPHP£¨¶þ£©


µÚÎåÕ ´úÂëÖØÓÃÓ뺯Êý±àд
require()»òinclude()¿ÉÒÔ½«Ò»¸öÎļþÔØÈëµ½php½Å±¾ÖС£
ÕâÁ½¸öº¯Êý¼¸ºõµÈ¼Û£¬Î¨Ò»µÄÇø±ðÊǵ÷ÓÃʧ°Üºórequire()¸ø³öÒ»¸öÖÂÃü´íÎ󣬶øinclude()Ö»¸ø³öÒ»¸ö¾¯¸æ¡£
Èç¹ûWebÒ³Ãæ¾ßÓÐÒ»ÖµÄÍâ¹Û£¬¿ÉÒÔ½«ÏàͬµÄ²¿·Ö·ÖÀëµ½µ¥¶ÀµÄÒ³ÃæÖУ¬È»ºó¿ÉÒÔÔÚphpÖÐʹÓÃrequire()Óï¾ä½«Ä£°åÔªËØ¼ÓÈëµ½Ò³ÃæÖС£ ......

phpѧϰ±Ê¼Ç£¨9£©:Mysql¼ò½éºÍ´´½¨ÐµÄÊý¾Ý¿â

 
 Ò»¡¢MySql¼ò½é¸ÅÒª
MySQLÊÇÒ»¸öСÐ͹ØÏµÐÍÊý¾Ý¿â¹ÜÀíϵͳ£¬¿ª·¢ÕßΪÈðµäMySQL AB¹«Ë¾£¬ºóÀ´
±»Sun¹«Ë¾ÊÕ¹º£¬ÏÖÔÚÕýÔÚ±»¼×¹ÇÎÄÊÕ¹º£¬Ö§³ÖFreeBSD¡¢Linux¡¢MAC¡¢Windows
µÈ¶àÖÖ²Ù×÷ϵͳ ÓëÆäËûµÄ´óÐÍÊý¾Ý¿âÀýÈçOracle¡¢DB2¡¢SQL ServerµÈÏà±È¹¦ÄÜÉÔÈõ
һЩ  ÌâÍâ»°£ºPostgresql&n ......

ʹÓÃabatorÅäÖÃiBatis£¬¹ÜÀíÊý¾Ý¿â£¨ÒÔMySqlΪÀý£©

ÏàÐźܶàµÄÅóÓѶÔʹÓÃiBatis¹ÜÀíÊý¾Ý¿âºÜ²»Ï°¹ß£¬ÒòΪÎÒÃÇÒªÊÖд´úÂë£¬ÌØ±ðÊÇdynamic
query²¿·Ö¸üÊDz»ÖªÈçºÎǶÌ×£¬¶øÕâЩÊÇ¿ÉÒÔÓù¤¾ßµÄ£¡ÏÂÃæ½éÉÜÒ»ÖÖ×î³£Óõ졲»·Ï»°ÁË£¬Ö±½ÓÉÏÅäÖùý³Ì£¡
1¡¢»ñµÃ  http://ibatis.apache.org/abator.html
    
Eclipse¿ÉÒÔ×Ô¶¯µÄ½øÐÐUpdate»ñÈ¡´ËPlugin ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ