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°²×°³É¹¦¡£
Ïà¹ØÎĵµ£º
Unixʱ¼ä´Á×îСµ¥Î»ÊÇÃ룬¿ªÊ¼Ê±¼äΪ¸ñÁÖÍþÖαê׼ʱ¼ä1970-01-01 00:00:00
ConvertIntDateTime·½·¨µÄ»ù±¾Ë¼Â·ÊÇͨ¹ý»ñÈ¡±¾µØÊ±Çø±íʾUnixk¿ªÊ¼Ê±¼ä£¬¼ÓÉÏUnixʱ¼äÖµ£¨¼´¹ýÈ¥µÄÃëÊý£©.
ConvertDateTimeInt·½·¨µÄ»ù±¾Ë¼Â·ÊÇͨ¹ý¿Ì¶ÈÊý²î£¬Ôٰѿ̶ÈÊýת»»ÎªÃëÊý£¬µ±È»ÒªËµÃ÷µÄÊÇ£¬ÎÒÕâÀï·µ»ØµÄÊÇdoubleÀàÐÍ£¬ÒâÒåÉϲ¢·ÇÊÇÕæ ......
mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
Ò».´´½¨´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
create procedure sp_name()
begin
………
end
2.²ÎÊý´«µÝ
¶þ.µ÷Óô洢¹ý³Ì
1.»ù±¾Óï·¨£ºcall sp_name()
×¢Ò⣺´æ´¢¹ý³ÌÃû³ÆºóÃæ±ØÐë¼ÓÀ¨ºÅ£¬ÄÄŸô洢¹ý³ÌûÓвÎÊý´«µÝ
Èý.ɾ³ý´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
drop procedure sp_na ......
¸ù¾ÝÄãµÄʹÓÃÄ¿µÄÎÒ¾õµÃÕâ¸öº¯ÊýÓÐÁ½·½ÃæµÄÓÃ;£º
·ÀÖ¹SQL Injection¹¥»÷£¬Ò²¾ÍÊÇÄã±ØÐëÑéÖ¤Óû§µÄÊäÈë
²Ù×÷Êý¾ÝµÄʱºò±ÜÃâ²»±ØÒªµÄ×Ö·ûµ¼Ö´íÎó
mysql_real_escape_string() º¯ÊýתÒå SQL Óï¾äÖÐʹÓõÄ×Ö·û´®ÖеÄÌØÊâ×Ö·û¡£
ÏÂÁÐ×Ö·ûÊÜÓ°Ï죺
\x00
\n
\r
\
'
"
\x1a
Èç¹û³É¹¦£¬Ôò¸Ãº¯Êý·µ»Ø±»×ªÒåµÄ×Ö·û´ ......
1£¬½«6.0°æ±¾µÄmysql¼¯ÈºÈí¼þÉÏ´«µ½Linux»òÊÇSolarisÉÏ£¬½âѹ
1>£¬ÎªÁË·½±ãµ÷Óý«Æä¸ÄÃûΪmysql£¬²¢ÇÒ·ÅÓÚ/usr/local/ÏÂ
2>£¬´´½¨Á¬½ÓÎļþ£¬½øÈë/usr/local/ÏÂ
ln -s ..../mysql mysql
2£¬´´½¨×飬Ìí¼ÓÓû§
groupadd mysql
useradd -g mysq ......
×òÌìÉè¼ÆÊý¾Ý¿â±íµÄʱºò£¬ÒòΪʹÓÃvarchar²úÉúÁËÒìÒ飬½á¹ûÒ»²é·¢ÏÖÎÒÃÇÁ½¸ö˶¼Ã»´í¡£
MySQLÊý¾Ý¿âµÄvarcharÀàÐÍÔÚ4.1ÒÔϵİ汾ÖеÄ×î´ó³¤¶ÈÏÞÖÆÎª255£¬ÆäÊý¾Ý·¶Î§¿ÉÒÔÊÇ0~255»ò1~255£¨¸ù¾Ý²»Í¬°æ±¾Êý¾Ý¿âÀ´
¶¨£©¡£
ÔÚMySQL5.0ÒÔÉϵİ汾ÖУ¬varcharÊý¾ÝÀàÐ͵ij¤¶ÈÖ§³Öµ½ÁË65535£¬Ò ......