mysql µ¥ÒýºÅ Ë«ÒýºÅ
½ñÌìÔÚдһÌõsqlÓï¾äµÄʱºò£¬ÓõÄË«ÒýºÅ£¬sqlÓï¾äÖ´ÐдíÎ󡣼ǵÄͬÊÂÎÊÎÒmysqlÓï¾äÖеĵ¥ÒýºÅºÍË«ÒýºÅÓÐÇø±ðÂ𣿻شðÊÇûÓÐÇø±ð¡£
½ñÌìÌØµØ²éÁ˲飬»¹ÊÇÓеãÇø±ðµÄ¡£
mysqlÖеÄÒ»¶Î˵Ã÷£º
ÔÚmysqlÖУ¬Ê¹Óõ¥ÒýºÅºÍË«ÒýºÅÁ©ÖÖ±í´ï·½·¨ÊÇÒ»ÑùµÄ£¬¾¡¹ÜʹÓõ¥ÒýºÅµÄ±í´ï·½·¨·ûºÏANSI-SQL/92±ê×¼¡£
Èç¹ûÔÚ×Ö·û´®ÀïÓÐÒýºÅ£¬ÔòÒªÓÃÒÔϵIJ»Í¬·½Ê½À´±íʾ£º
"abc'abc" ¼´ abc'abc
"abc""abc" ¼´ abc“abc
"abc\'abc" ¼´ abc'abc
"abc\"abc" ¼´ abc"abc
'abc"abc' ¼´ abc"abc
'abc''abc' ¼´ abc'abc
'abc\"abc' ¼´ abc"abc
‘abc\'abc' ¼´ abc'abc
¿ÉÒÔ¿´³ö£¬¾¡Á¿»¹ÊÇʹÓõ¥ÒýºÅ¡£
µ±ÐÞ¸ÄÁËmysqlµÄsqlģʽµÄʱºò£¨set @@global.sql_mode£©µÄʱºò£¬Ñ¡Ôñ²»Í¬sqlģʽ£¬¿ÉÄÜ»á³öÏÖµ¥ÒýºÅºÍË«ÒýºÅµÄÇø±ð¡£ANSI-SQL±ê×¼¡£
Ïà¹ØÎĵµ£º
MySQLÓï¾äÓÅ»¯µÄÔÔò
1¡¢Ê¹ÓÃË÷ÒýÀ´¸ü¿ìµØ±éÀú±í¡£
¡¡¡¡È±Ê¡Çé¿öϽ¨Á¢µÄË÷ÒýÊÇ·ÇȺ¼¯Ë÷Òý£¬µ«ÓÐʱËü²¢²»ÊÇ×î¼ÑµÄ¡£ÔÚ·ÇȺ¼¯Ë÷ÒýÏ£¬Êý¾ÝÔÚÎïÀíÉÏËæ»ú´æ·ÅÔÚÊý¾ÝÒ³ÉÏ¡£ºÏÀíµÄË÷ÒýÉè¼ÆÒª½¨Á¢ÔÚ¶Ô¸÷ÖÖ²éѯµÄ·ÖÎöºÍÔ¤²âÉÏ¡£Ò»°ãÀ´Ëµ£º
¡¡¡¡a.ÓдóÁ¿Öظ´Öµ¡¢ÇÒ¾³£Óз¶Î§²éѯ£¨ > ,< ......
ÓÃMySQL´´½¨Êý¾Ý¿âºÍÊý¾Ý¿â±í
Á˽âÁËһЩ×î»ù±¾µÄ²Ù×÷ÃüÁîºó£¬ÎÒÃÇÔÙÀ´Ñ§Ï°ÈçºÎ´´½¨Ò»¸öÊý¾Ý¿âºÍÊý¾Ý¿â±í¡£
¡¡¡¡1¡¢Ê¹ÓÃSHOWÓï¾äÕÒ³öÔÚ·þÎñÆ÷Éϵ±Ç°´æÔÚʲôÊý¾Ý¿â£º
mysql> SHOW DATABASES; +----------+
| Database | +----------+ | mysql |
| test | +----------+ 3 rows in set (0.00 sec)
¡¡¡¡2¡¢´´½¨Ò ......
°²×°»·¾³£ºVMware Workstation 5.5.0 build-18463
Linux°æ±¾£ºRed Hat Enterprise Linux AS (2.6.9-42.EL)
Èí¼þ°æ±¾£ºMySQL5 - mysql-5.0.37.tar.gz
¡¡¡¡¡¡¡¡¡¡Apache2 - httpd-2.2.4.tar.gz
¡¡¡¡¡¡¡¡¡¡PHP5 - php-5.2.1.tar.gz
¡¡¡¡¡¡¡¡¡¡(½«ÒÔÉÏÎļþ±£´æÖÁ/home/tmpĿ¼)
[MySQL]
# cd /home/tmp (½øÈëѹËõ°ü ......
1 MYSQLÖеÄ×Ö·û¼¯¸ÅÄî
MysqlµÄ×Ö·û¼¯ÀïÓÐÁ½¸ö¸ÅÄһ¸öÊÇ"Character set£¨×Ö·û¼¯£©"£¬ÁíÒ»¸öÊÇ"Collations"¡£
1.1 Collations
Collations·³ÉÖÐÎÄÊÇ"УÑé"£¬ÔÚÍøÒ³¿ª·¢µÄ¹ý³ÌÖУ¬Õâ¸ö´Ê»ã£¬Ö»ÔÚMysqlÀïʹÓã¬Ö÷Òª×÷ÓÃÊÇÖ¸µ¼Mysql¶Ô×Ö·ûµÄ±È½Ï£¬±ÈÈ磬 ASCII×Ö·û¼¯ÀCol ......
Äê³õµÄʱºòÒ»Ö±ÔÚ×öÒ»¸öÍøÕ¾MSSQL2000->MySQL5µÄÇ¨ÒÆ¹¤×÷£¬ÒòΪ²ÉÓÃÁ˲»Í¬µÄ³ÌÐòϵͳ£¬ËùÒÔÖ÷ÒªÎÊÌâÔÚÊý¾ÝµÄÇ¨ÒÆ¡£ÓÉÓÚ2¸öϵͳÊý¾Ý¿â½á¹¹²îÒì·Ç³£´ó£¬²»·½±ã²ÉÈ¡SQLSERVERÀïµ¼ÈëMYSQLµÄODBCÊý¾ÝÔ´µÄ¹¦ÄÜ£¨Ò²²»ÍƼöÕâô×ö£¬×Ö¶ÎÀàÐ͵Ȳ»Í¬µã»á¸ãËÀÈ˵ġ«£©£¬Òò´Ë¾ÍÔÚWINDOWSÏÂ×Ô¼ºÐ´PHP½Å±¾´ÓSQLSERVERÀï¶ÁÊý¾Ý£¬È»ºó°´ÕÕ ......