MySQLתÒå
MySQLʶ±ðÏÂÁÐתÒå×Ö·û£º
\0
Ò»¸öASCII 0 (NUL)×Ö·û¡£
\n
Ò»¸öÐÂÐзû¡£
\t
Ò»¸ö¶¨Î»·û¡£
\r
Ò»¸ö»Ø³µ·û¡£
\b
Ò»¸öÍ˸ñ·û¡£
\'
Ò»¸öµ¥ÒýºÅ(“'”)·û¡£
\"
Ò»¸öË«ÒýºÅ(“"”)·û¡£
\\
Ò»¸ö·´Ð±Ïß(“\”)·û¡£
\%
Ò»¸ö“%”·û¡£ËüÓÃÓÚÔÚÕýÎÄÖÐËÑË÷“%”µÄÎÄ×ÖʵÀý£¬·ñÔòÕâÀï“%”½«½âÊÍΪһ¸öͨÅä·û¡£
\_
Ò»¸ö“_”·û¡£ËüÓÃÓÚÔÚÕýÎÄÖÐËÑË÷“_”µÄÎÄ×ÖʵÀý£¬·ñÔòÕâÀï“_”½«½âÊÍΪһ¸öͨÅä·û¡£
×¢Ò⣬Èç¹ûÄãÔÚijЩÕýÎÄ»·¾³ÖÐʹÓÓ\%”»ò“\%_”£¬ÕâЩ½«·µ»Ø×Ö·û´®“\%”ºÍ“\_”¶ø²»ÊÇ“%”ºÍ“_”¡£
Óм¸ÖÖ·½·¨ÔÚÒ»¸ö×Ö·û´®ÄÚ°üÀ¨ÒýºÅ£º
Ò»¸ö×Ö·û´®ÄÚÓÓ'”¼ÓÒýºÅµÄ“'”¿ÉÒÔ±»Ð´×÷Ϊ“''”¡£
Ò»¸ö×Ö·û´®ÄÚÓÓ"”¼ÓÒýºÅµÄ“"”¿ÉÒÔ±»Ð´×÷Ϊ“""”¡£
Äã¿ÉÒÔ°ÑÒ»¸öתÒå×Ö·û£¨“\”£©·ÅÔÚÒýºÅÇ°Ãæ¡£
Ò»¸ö×Ö·û´®ÄÚÓÓ"”¼ÓÒýºÅµÄ“'”²»ÐèÒªÌØÊâ¶Ô´ý¶øÇÒ²»±Ø±»Öظ´»òתÒ塣ͬÀí£¬Ò»¸ö×Ö·û´®ÄÚÓÓ'”¼ÓÒýºÅµÄÓë“"”Ò²²»ÐèÒªÌØÊâ¶Ô´ý¡£
Ïà¹ØÎĵµ£º
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MySQLDriverCS;
&nb ......
MysqlÊý¾Ý¿âÌṩÁ½ÖÖÀàÐ͵ÄË÷Òý£¬Èç¹ûûÕýÈ·ÉèÖã¬Ë÷ÒýµÄÀûÓÃЧÂÊ»á´ó´òÕÛ¿ÛÈ´ÍêÈ«²»ÖªÎÊÌâ³öÔÚÕâ¡£
CREATE TABLE test (
id INT NOT NULL,
last_name CHAR(30) NOT NULL,
first_name CHAR(30) NOT NULL,
PRIMARY KEY (id),
INDEX name (last_name,first_name)
);
ÒÔÉÏ´ ......
......
mysql Æð¶¯´íÎó½â¾ö°ì·¨- -
Access denied for user ''@'localhost' to d ......