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

MySQLÓÅ»¯Ó²¼þÌá¸ßÐÔÄÜ

ÓÅ»¯MySQL·þÎñÆ÷µÄÅäÖòÎÊý£¬¿ÉÒÔÌá¸ßMySQLÊý¾Ý¿âµÄÐÔÄÜ£¬µ«ÊǶÔÓÚÅäÖýϵ͵ķþÎñÆ÷À´Ëµ£¬ÄãÎÞÂÛÔõôÓÅ»¯ÅäÖ㬶¼²»»áµÃµ½ÀíÏëµÄЧ¹û£¬ÄǾÍÖ»ÄÜÌá¸ßÄãÓ²¼þÅäÖã¬À´³¹µ×ÓÐЧµØ¸ÄÉÆ·þÎñÆ÷µÄÐÔÄÜ¡£
¾ßÌåµÄ·½·¨ÈçÏ£º
Ò»¡¢ÔÚÉèÖÃMySQL ʱ£¬Ó¦¸ÃÅäÖÃÆäʹÓþ²Ì¬¿â¶ø²»Êǹ²Ïí¿â¡£Ê¹Óù²Ïí¿âµÄ¶¯Ì¬¶þ½øÖÆϵͳ¿É½ÚÊ¡´ÅÅ̿ռ䣬µ«¾²Ì¬¶þ½øÖÆϵͳ¸ü¿ì£¨È»¶ø£¬Èç¹ûÏ£Íû×°ÈëÓû§×Ô¶¨ÒåµÄº¯Êý£¬Ôò²»ÄÜʹÓþ²Ì¬¶þ½øÖÆϵͳ£¬ÒòΪUDF »úÖÆÒÀÀµÓÚ¶¯Ì¬Á¬½Ó£©¡£
¶þ¡¢Ôö¼Ó¸ü¿ìµÄ´ÅÅÌÒÔ¼õÉÙI/O µÈ´ýʱ¼ä¡£Ñ°µÀʱ¼äÊÇÕâÀï¾ö¶¨ÐÔÄܵÄÖ÷ÒªÒòËØ¡£Öð×ÖµØÒƶ¯´ÅÍ·ÊǺÜÂýµÄ£¬Ò»µ©´ÅÍ·¶¨Î»£¬´Ó´ÅµÀ¶Á¿éÔò½Ï¿ì¡£
Èý¡¢ÔÚ²»Í¬µÄÎïÀíÉ豸ÉÏÉè·¨ÖØзÖÅä´ÅÅ̻¡£Èç¹û¿ÉÄÜ£¬Ó¦½«ÄúµÄÁ½¸ö×æµÄÊý¾Ý¿â´æ·ÅÔÚ²»Í¬µÄÎïÀíÉ豸ÉÏ¡£Çë×¢Ò⣬ʹÓÃͬһÎïÀíÉ豸ÉϵIJ»Í¬·ÖÇøÊDz»¹»µÄ¡£ÕâÑùûÓаïÖú£¬ÒòΪËüÃÇÈÔ½«ÕùÓÃÏàͬµÄÎïÀí×ÊÔ´£¨´ÅÅÌÍ·£©¡£
ÔÚ½«Êý¾ÝÖØзŵ½²»Í¬É豸֮ǰ£¬Ó¦¸Ã±£Ö¤Á˽â¸ÃϵͳµÄ×°ÔØÌØÐÔ¡£Èç¹ûÔÚÌض¨µÄÎïÀíÉ豸ÉÏÒѾ­ÓÐÁËijЩÌض¨µÄÖ÷Òª»î¶¯£¬½«Êý¾Ý¿â·Åµ½¸Ã´¦Êµ¼ÊÉÏ¿ÉÄÜ»áʹÐÔÄܸü»µ¡£ÀýÈ磬²»Òª°ÑÊý¾Ý¿âÒƵ½´¦Àí´óÁ¿Web ͨÐŵÄWeb ·þÎñÆ÷É豸ÉÏ¡£
ËÄ¡¢ÔÚ»úÆ÷Öа²×°¸ü¶àµÄÄÚ´æ¡£ÕâÑùÄܹ»Ôö¼Ó·þÎñÆ÷µÄ¸ßËÙ»º´æºÍ»º³åÇøµÄ³ß´ç£¬Ê¹·þÎñÆ÷¸ü¾­³£µØʹÓôæ·ÅÔÚÄÚ´æÖеÄÐÅÏ¢£¬½µµÍ´Ó´ÅÅÌÈ¡ÐÅÏ¢µÄÒªÇó¡£
Îå¡¢Èç¹ûÓÐ×ã¹»µÄRAM ʹËùÓн»»»ÔÚÄÚ´æÎļþϵͳÖÐÍê³É£¬ÄÇôӦ¸ÃÖØÐÂÅäÖÃϵͳ£¬È¥µôËùÓдÅÅ̽»»»ÉèÖ᣷ñÔò£¬¼´Ê¹ÓÐ×ãÒÔÂú×ã½»»»µÄR A M£¬Ä³Ð©ÏµÍ³ÈÔȻҪÓë´ÅÅ̽øÐн»»»¡£


Ïà¹ØÎĵµ£º

³¬¼¶¼òµ¥µÄphp+mysqlÁôÑÔ±¾Ô´Âë

 ¹²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
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQLÖÐÁË£¬MYSQLµÄÌáʾ·ûÊÇ£ºmysql>
2¡¢Àý2£ºÁ¬½Óµ½Ô ......

¾­Ñé×ܽ᣺mysql µÄһЩ»ù±¾Ó¦ÓÃ


»ù±¾²éѯ
SELECTÓï¾äÓÃÓÚ²éѯÊý¾Ý¿âºÍSQLÖеÄËùÓÐÊä³ö²Ù×÷¡£
SELECTc_u_name, emailfromcooya_users;
Êä³öcooya_users±íÖÐËùÓÐÐУ¨»ò¼Ç¼£©µÄÊôÐÔc_u_nameºÍemailµÄÖµ¡£
Èç¹ûÐèÒªËùÓÐÊôÐÔ£¬¿ÉÒÔʹÓÃÐǺţ¨*£©µÄ¿ì½Ý·½Ê½¡£
SELECT* from cooya_users;
SELECTÓï¾ä»¹¿ÉÒÔÊä³ö²»ÊÇÊý¾Ý¿âÖеÄÊý¾Ý¼°¿ÉÒÔÓÃ×÷¼òµ¥µÄ¼ÆËã·û ......

tomcat+mysqlÁ¬½Ó³ØµÄÅäÖÃ

ÔÚTOMCAϵÄCatalina\localhostĿ¼µÄ¹¤³Ìxml£¬±àдÈçÏ´úÂ룺
<Context path="/testProject" docBase="E:\project\TestProject\WebContent" reloadable="true"  debug="0" privileged="true">
<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name=" ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ