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

MYSQL °²È«ÎÊÌâ

×î½üÔÚÑо¿Êý¾Ý¿âµÄ°²È«ÎÊÌ⣬·¢ÏÖMYSQLÓкܶలȫ©¶´£¬ÏëÇë½Ì´ó¼Ò£¬ÔÚ¹ÜÀí·½ÃæÈçºÎÀ´·ÀÖ¹°²È«Òþ»¼¡£

ÎÒÁ˽⵽ÓÐ×¢Èë¹¥»÷£¬¸ÃÈçºÎ·ÀÖ¹£¿

»¹ÓйØÓÚÕ˺š¢ÃÜÂëµÄ¹ÜÀí¡¢ÎļþÊôÐÔµÈ
1. ²Ù×÷ϵͳµÄ°²È«£¬±ÈÈç windows »ò linux µÄ°²È«¡£
2. MySQL ×ÔÉíµÄȨÏÞÉèÖÃ

http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html#security
5.6. Ò»°ã°²È«ÎÊÌâ
5.6.1. ͨÓð²È«Ö¸ÄÏ
5.6.2. ʹMySQLÔÚ¹¥»÷ÕßÃæÇ°±£³Ö°²È«
5.6.3. Mysqld°²È«Ïà¹ØÆô¶¯Ñ¡Ïî
5.6.4. LOAD DATA LOCAL°²È«ÎÊÌâ
5.7. MySQL·ÃÎÊȨÏÞϵͳ
5.7.1. ȨÏÞϵͳµÄ×÷ÓÃ
5.7.2. ȨÏÞϵͳ¹¤×÷Ô­Àí
5.7.3. MySQLÌṩµÄȨÏÞ
5.7.4. ÓëMySQL·þÎñÆ÷Á¬½Ó
5.7.5. ·ÃÎÊ¿ØÖÆ, ½×¶Î1£ºÁ¬½ÓºËʵ
5.7.6. ·ÃÎÊ¿ØÖÆ, ½×¶Î2£ºÇëÇóºËʵ
5.7.7. ȨÏÞ¸ü¸ÄºÎʱÉúЧ
5.7.8. ¾Ü¾ø·ÃÎÊ´íÎóµÄÔ­Òò
5.7.9. MySQL 4.1ÖеÄÃÜÂë¹þÏ£´¦Àí
5.8. MySQLÓû§ÕË»§¹ÜÀí
5.8.1. MySQLÓû§ÃûºÍÃÜÂë
5.8.2. ÏòMySQLÔö¼ÓÐÂÓû§ÕË»§
5.8.3. ´ÓMySQLɾ³ýÓû§ÕË»§
5.8.4. ÏÞÖÆÕË»§×ÊÔ´
5.8.5. ÉèÖÃÕË»§ÃÜÂë
5.8.6. ʹÄãµÄÃÜÂ밲ȫ
5.8.7. ʹÓð²È«Á¬½Ó
5.9. ±¸·ÝÓë»Ö¸´
5.9.1. Êý¾Ý¿â±¸·Ý
5.9.2. ʾÀýÓñ¸·ÝÓë»Ö¸´²ßÂÔ
5.9.3. ×Ô¶¯»Ö¸´
5.9.4. ±íά»¤ºÍ±ÀÀ£»Ö¸´
5.9.5. myisamchk£ºMyISAM±íά»¤ÊµÓù¤¾ß
5.9.6. ½¨Á¢±íά»¤¼Æ»®
5.9.7. »ñÈ¡¹ØÓÚ±íµÄÐÅÏ¢


µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html


Ïà¹ØÎÊ´ð£º

phpÈçºÎµ÷ÓÃmysql´æ´¢¹ý³Ì?

ÎÒ´æ´¢¹ý³ÌÏë
begin
select * from newsys;
end

µ«´æ´¢¹ý³ÌµÄ²ÎÊýÓ¦¸ÃÔõôд?


phpÓÖÔõôµ÷Óã¬Çë¸øÎÒÍêÕûµÄʵÀý£¬ÎÒÔÚÍøÉÏËÑÁËÒ»´ó¶Ñ£¬½á¹û¶¼Ã»³É¹¦£¬Ð»Ð»¸÷λ£¡

ûÓùý£¬¶¥Ò»Ï£¡ ......

php¶ÁÈ¡mysqlÊý¾Ý±íÖеÄͼƬÎÞ·¨ÏÔʾ

°´µÀÀíÀ´Ëµ£¬Í¼Æ¬ÊÇÓ¦¸Ã°´ÕÕ·¾¶´æÔÚÊý¾Ý±íÖеģ¬ÓÉÓÚ¹¤×÷ÐèÒª£¬ÐèÒª½«Í¼Æ¬ÒÔ¶þ½øÖÆÁ÷µÄÇé¿ö´æÈëÊý¾Ý¿â£¬ÏÖÔÚ½«Êý¾Ý±ítableÖÐÒ»¸ö×Ö¶Îpicture£¬ÀàÐ͸ÄΪ longblob£¬ÒѾ­Äܳɹ¦½«¶þ½øÖÆÁ÷дÈë¸Ã×ֶΣ¬¿ÉÊÇÎÒÐèÒª½«¸ÃÍ ......

javaµ÷ÓÃmysqlÃüÁîµ¼ÈëÊý¾Ý

Java code:

public static void load(String filename) {
try {
@SuppressWarnings("unused")
Process process = Runtime.getRuntime().exec(
......

mysqlµÄ sequence µÄÎÊÌâ¡£ÔÚÏߵȴý¡£¡£

ÇëÎÊһϣ¬mysqlµÄsequenceÊÇ×Ô¶¯µÝÔöµÄ£¬²»ÐèÒª½øÐвÙ×÷¡£
ÄÇÎÒÔÚ²åÈëÒ»ÌõÖ÷¼Ç¼µÄʱºò£¬Í¬Ê±Òª¸øÕâ¸öÖ÷¼üµÄÆäËû±í½øÐвåÈëÊý¾Ý¡£Õâʱºò£¬ÎÒ¸ù±¾È¡²»µ½Õâ¸öµÝÔöµÄsequence°¢¡£¡£

Õâ¸öÎÊÌâÔõô½â¾ö°¢¡£¡£ ......

MySQL±àÂëµÄÎÊÌâ

ÎÒµÄMySQL±àÂ룬ÎÒÔÚmy.iniÖÐÉèÖõÄΪutf8,ÔÚ´´½¨Êý¾Ý¿âʱѡÔñµÄ±àÂëΪutf8_Unicode_ci£¬ÎÒÔÚ¡¢´ÓÒ³Ãæ²åÈëÊý¾Ý¿â£¬ÔÚÒ³ÃæÉÏÏÔʾÕý³££¬µ«´ÓphpmyadminÖУ¬²é¿´Ê±£¬ÏÔʾΪÂÒÂ루ÎÒÎÒ¡£& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ