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

MysqlµÄ°²×°

  ÏÂÔØmysql-4.1.14-win32.zip½âѹºóµÃµ½mysql-4.1.14-win32Îļþ¼Ð£¬´ò¿ª´ËÎļþ¼ÐÔËÐÐsetup.exeÎļþ£¬Next£¬Custom¡¢Next£¬Change£¬½«Â·¾¶¸ÄΪd:\MySQL\MySQL Server 4.1\£¬OK£¬Next£¬Install£¬Íê³ÉºóÌø³ö´°¿ÚÈçͼ£º
µãÒ»ÏÂCancel£¬ÔÙÖ±µãFinish¡£ÏÖÔÚÌø³öÉèÖÃmysqlµÄ´°¿Ú£¬Èçͼ£º
Next£¬Next£¬Next£¬next£¬Next£¬Èçͼ£º
½«Concurrent commections:ºóÃæµÄ15¸ÄΪ1400£¬Next£¬port£º3306¡¢Next£¬Next£¬Ö±½ÓNext£¬Èçͼ£º
ÔÚNew root password ºóÃæÊäÈëÃÜÂ룬ConfirmÖØ¸´ÊäÈëÒ»´ÎÃÜÂ룬Next£¬Execute£¬ÏµÍ³×Ô¶¯ºË¶Ô£¬µ±ËĸöÑ¡ÏîÈ«
²¿¶¼ÓÐÁËÂÌÉ«µÄ¹´ºó£¬ÔÙµãÒ»ÏÂFinish£¬mysql°²×°³É¹¦¡£


Ïà¹ØÎĵµ£º

mysqlÊý¾ÝUnixʱ¼ä´ÁÓëC# DateTimeʱ¼äÀàÐÍ»¥»»

Unixʱ¼ä´Á×îСµ¥Î»ÊÇÃ룬¿ªÊ¼Ê±¼äΪ¸ñÁÖÍþÖαê׼ʱ¼ä1970-01-01 00:00:00
ConvertIntDateTime·½·¨µÄ»ù±¾Ë¼Â·ÊÇͨ¹ý»ñÈ¡±¾µØÊ±Çø±íʾUnixk¿ªÊ¼Ê±¼ä£¬¼ÓÉÏUnixʱ¼äÖµ£¨¼´¹ýÈ¥µÄÃëÊý£©.
ConvertDateTimeInt·½·¨µÄ»ù±¾Ë¼Â·ÊÇͨ¹ý¿Ì¶ÈÊý²î£¬Ôٰѿ̶ÈÊýת»»ÎªÃëÊý£¬µ±È»ÒªËµÃ÷µÄÊÇ£¬ÎÒÕâÀï·µ»ØµÄÊÇdoubleÀàÐÍ£¬ÒâÒåÉϲ¢·ÇÊÇÕæ ......

mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá

mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
Ò».´´½¨´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
create procedure sp_name()
begin
………
end
2.²ÎÊý´«µÝ
¶þ.µ÷Óô洢¹ý³Ì
1.»ù±¾Óï·¨£ºcall sp_name()
×¢Ò⣺´æ´¢¹ý³ÌÃû³ÆºóÃæ±ØÐë¼ÓÀ¨ºÅ£¬ÄÄŸô洢¹ý³ÌûÓвÎÊý´«µÝ
Èý.ɾ³ý´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
drop procedure sp_na ......

PHPÖеÄmysql_real_escape_stringº¯Êý

¸ù¾ÝÄãµÄʹÓÃÄ¿µÄÎÒ¾õµÃÕâ¸öº¯ÊýÓÐÁ½·½ÃæµÄÓÃ;£º
·ÀÖ¹SQL Injection¹¥»÷£¬Ò²¾ÍÊÇÄã±ØÐëÑéÖ¤Óû§µÄÊäÈë
²Ù×÷Êý¾ÝµÄʱºò±ÜÃâ²»±ØÒªµÄ×Ö·ûµ¼Ö´íÎó
mysql_real_escape_string() º¯ÊýתÒå SQL Óï¾äÖÐʹÓõÄ×Ö·û´®ÖеÄÌØÊâ×Ö·û¡£
ÏÂÁÐ×Ö·ûÊÜÓ°Ï죺
\x00
\n
\r
\
'
"
\x1a
Èç¹û³É¹¦£¬Ôò¸Ãº¯Êý·µ»Ø±»×ªÒåµÄ×Ö·û´ ......

MySQL¼¯Èº

1£¬½«6.0°æ±¾µÄmysql¼¯ÈºÈí¼þÉÏ´«µ½Linux»òÊÇSolarisÉÏ£¬½âѹ
 
 1>£¬ÎªÁË·½±ãµ÷Óý«Æä¸ÄÃûΪmysql£¬²¢ÇÒ·ÅÓÚ/usr/local/ÏÂ
 2>£¬´´½¨Á¬½ÓÎļþ£¬½øÈë/usr/local/ÏÂ
  
  ln -s ..../mysql mysql
2£¬´´½¨×飬Ìí¼ÓÓû§
 
 groupadd mysql
 useradd -g mysq ......

mysql Êý¾ÝÀàÐÍvarchar ×ÓжàÉÙ

  ×òÌìÉè¼ÆÊý¾Ý¿â±íµÄʱºò£¬ÒòΪʹÓÃvarchar²úÉúÁËÒìÒ飬½á¹ûÒ»²é·¢ÏÖÎÒÃÇÁ½¸öË­¶¼Ã»´í¡£
   MySQLÊý¾Ý¿âµÄvarcharÀàÐÍÔÚ4.1ÒÔϵİ汾ÖеÄ×î´ó³¤¶ÈÏÞÖÆÎª255£¬ÆäÊý¾Ý·¶Î§¿ÉÒÔÊÇ0~255»ò1~255£¨¸ù¾Ý²»Í¬°æ±¾Êý¾Ý¿âÀ´
¶¨£©¡£
  
ÔÚMySQL5.0ÒÔÉϵİ汾ÖУ¬varcharÊý¾ÝÀàÐ͵ij¤¶ÈÖ§³Öµ½ÁË65535£¬Ò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ