MySQLºÍSQL×ֶνضÌ©¶´
×ªÔØ×Ô£ºhttp://www.neatstudio.com/index-4.shtml
ÎÄÕÂÀ´×Ô¼Åįhacker,http://hi.baidu.com/isbx/blog/item
/08ef48547ef1ad58574e00bf.html:
µ±Ç°µÄWeb¿ª·¢ÕßÖп϶¨Óв»ÉÙÈËûÓÐ×¢Òâµ½×÷ÕßËùÌáµ½µÄÕâÁ½¸öÎÊÌâµÄ¡£
µÚÒ»¸öÎÊÌâÊÇÕâÑùµÄ£¬MySQLĬÈÏÓÐÒ»¸öÅäÖòÎÊý
max_packet_size£¬Õâ¸ö²ÎÊýÊÇÓÃÓÚÏÞÖÆMySQL¿Í»§¶ËºÍMySQL·þÎñÆ÷¶ËÊý¾ÝͨÐŵÄÊý¾Ý°ü´óС£¬MySQLµÄĬÈÏÅäÖÃÊÇ1MB¡£Èç¹û¿Í
»§¶Ë·¢Ë͵ÄÊý¾Ý³¬¹ýÁË1MB£¬ÔòMySQL·þÎñÆ÷¶Ë»áºöÂÔµôÕâ¸öÇëÇóÊý¾Ý¡£×÷Õß½ÓÏÂÀ´¾ÙÁËÁ½¸öÀûÓÃÕâ¸öȱÏݵÄÀý×Ó£¬µÚÒ»¸öÊÇÀûÓ󬳤Êý¾ÝÀ´Ê¹MySQLµÄ
ÈÕÖ¾¼Ç¼³ÌÐòʧЧ£¬µÚ¶þ¸öÊÇÔÚPHP+MySQLµÄ»·¾³Ï£¬PHPµÄSessionÇåÀí³ÌÐò»áÓÉÓÚÒ»´Î·¢Ë͵ÄÇåÀísessionÊý¾ÝµÄÇëÇóÊý¾Ý°ü³¬¹ý
max_packet_sizeµÄÏÞÖÆ£¬¶øµ¼ÖÂÇåÀísessionʧ°Ü¡£
¶øÊµ¼ÊÉÏ£¬ÓÉÓںܶàPHP+MySQLµÄ³ÌÐò¶¼»áÔËÐÐÓû§ÉÏ´«¸½¼þÖ®À࣬¶øÒ»°ãµÄPHP+MySQLµÄÉÏ´«¸½¼þÏÞÖÆ¶¼ÊÇ´óÓÚ1MBµÄ£¬ËùÒÔPHPµÄ
³ÌÐò¿ª·¢ÈËÔ±Ò»°ãÊÇ»áÈ¥ÐÞ¸Ämax_packet_sizeµÄֵΪ´óÓÚ1MB¡£Õâ¾Í¸øÎÒÃǵÄ©¶´ÀûÓôøÀ´ÁËÒ»¶¨µÄÂé·³£¬±Ï¾¹ÔÚµ±Ç°µÄÍøÂç×´¿öÏ£¬¹¹Ôì
1MB¶àµÄÊý¾ÝÈ¥ÉÏ´«»¹ÊÇ¿ÉÒÔÈÌÊܵġ£µ«ÊÇÌ«´óµÄÊý¾ÝÁ¿¾Í±È½Ï¿¼ÑéÎÒÃǵÄÄÍÐÄÁË£¬ºÇºÇ¡£
µÚ¶þ¸öÎÊÌâ¾Í±È½ÏÑÏÖØÁË£¬MySQL¶ÔÓÚ³¬¹ý×ֶγ¤¶ÈµÄÊý¾Ý²åÈë²Ù×÷»á½øÐÐĬÈϵÄ×Ö·û´®½Ø¶Ì¡£ÀýÈçÒ»¸ö×ֶζ¨ÒåµÄ³¤¶ÈΪ10£¬Èç¹û²åÈëµÄ×Ö·û´®³¤¶È
³¬¹ý10£¬MySQL»á½«³¤¶È³¬¹ý10µÄ²¿·Ö×Ö·û´®×Ô¶¯ÉáÈ¥ºó²åÈëµ½Êý¾Ý±íÖС£Ä¬ÈÏÅäÖÃÌõ¼þÏ£¬MySQL»á²úÉúÒ»¸ö¾¯¸æÐÅÏ¢£¬µ«ÊÇÕâ¸ö¾¯¸æÐÅÏ¢²»»á±»
WebÓ¦ÓóÌÐò²¶»ñµ½¡£ËùÒÔ£¬´Ó±íÃæÉÏÀ´¿´£¬³¬³¤Êý¾ÝÒ²ÊÇ¿ÉÒÔ“³É¹¦”²åÈëÊý¾Ý±íµÄ¡£×÷ÕßÔÚÏÂÃæ¾ÙµÄÕâ¸öÀý×ӾͺÜÓдú±íÐÔÁË£¬Ê×ÏÈÊÇÒ»¸ö³¡¾°¼ÙÉ裺
The application is a forum where new users can register
The administrator’s name is known e.g. ‘admin’
MySQL is used in the default mode
There is no application restriction on the length of new user
names
The database column username is limited to 16 characters
Óû§Èç¹û³¢ÊÔ×¢²áÒ»¸öÓû§ÃûΪadminµÄÓû§£¬»áÓÉÓÚWebÓ¦ÓóÌÐòÖеÄisAlreadyRegisteredº¯ÊýµÄУÑé¶ø×¢²áʧ°Ü¡£
SELECT * from user WHERE username='admin'
µ«Èç¹ûÓû§Ê¹ÓÃÓû§Ãû’admin x’À´×¢²á£¨×¢ÒâadminºÍxÖ®¼äÓÐ11¸ö¿Õ¸ñ£©£¬Ôò×¢²áÁ÷³Ì»áÊÇÕâÑùµÄ£º
i
Ïà¹ØÎĵµ£º
IF NOT EXISTS (SELECT * from ::fn_listextendedproperty
(N'MS_Description' , N'SCHEMA',N'dbo',
N'TABLE',N'±íÃû', N'COLUMN',N'ÁÐÃû'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description',
@value=N'˵Ã÷ÄÚÈÝ' , @level0type=N'SCHEMA',@level0name=N'dbo',
@level1type=N'TABLE',@level1name=N'±íà ......
ÕâÀïÊÇʹÓÃODBCÀ´×ª»»Êý¾Ý¿âµÄ¡£
1.°²×°mysqlÊý¾Ý¿âµÄODBCÇý¶¯£¬mysql¹ÙÍøÓÐÏÂÔØhttp://dev.mysql.com/downloads/connector/odbc/
2.´ò¿ª¿ØÖÆÃæ°å\¹ÜÀí¹¤¾ß\Êý¾ÝÔ´ODBC£¬ÔÚÓû§DSNÖÐÌí¼ÓÒ»¸öMySQL ODBC Êý¾ÝÔ´¡£
3.½Ó×ÅÔÚÏÂÃæµÄ´°ÌåÖÐÊäÈëÊý¾ÝÔ´Ãû³Æ£¬Èçmysqlodbc£»È»ºóÊäÈë·þÎñÆ÷ServerµØÖ·£¨localhost»òÆäËû£©£¬Óû§Us ......
Êý¾Ý¿â²Ù×÷Àࣺ
¸´ÖÆ´úÂë ´úÂëÈçÏÂ:
/// <summary>
/// È¡µÃ×ÜÊý
/// </summary>
/// <returns></returns>
public string getTotal()
{
StringBuilder sb = new StringBuilder();
sb.Append("select count(*) total from Test");
DataTable dt = DBHelper.ExecuteDt(sb.ToString ......