mysqlµÄsql_mode½éÉÜ
mysql¿ÉÒÔÔËÐÐÔÚ²»Í¬sql modeģʽÏÂÃ棬sql modeģʽ¶¨ÒåÁËmysqlÓ¦¸ÃÖ§³ÖµÄsqlÓï·¨£¬Êý¾ÝУÑéµÈ£¡
²é¿´Ä¬ÈϵÄsql modeģʽ£º
select @@sql_mode;
ÎÒµÄÊý¾Ý¿âÊÇ£º
STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
ÔÚ´ËģʽÏÂÃ棬Èç¹û²åÈëµÄÊý¾ÝµÄ³¤¶È´óÓÚ¶¨ÒåµÄ³¤¶È£¬ÄÇô¾Í»á±¨´í£¡
set session sql_mode='REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI';
ÔÚÕâÖÖģʽÏÂÃ棺²åÈëµÄÊý¾ÝµÄ³¤¶È´óÓÚ¶¨ÒåµÄʱºò£¬¾Í»á½ØÈ¡£¬²¢¾¯¸æ£¬µ«ÊÇ¿ÉÒÔ²åÈë½øÈ¥
session±íʾֻÔÚ±¾´ÎÖÐÓÐЧ
global£º±íʾÔÚ±¾´ÎÁ¬½ÓÖв»ÉúЧ£¬¶ø¶ÔÓÚеÄÁ¬½Ó¾ÍÉúЧ
ÆôÓÃNO_BACKSLASH_ESCAPESģʽ£¬Ê¹·´Ð±Ïß³ÉΪÆÕͨ×Ö·û£¬ÔÚµ¼ÈëÊý¾Ýʱºò£¬Èç¹ûÊý¾ÝÖÐÓз´Ð±Ïߣ¬ÆôÓÃÕâ¸öģʽÊǸö²»´íµÄÑ¡Ôñ
ÆôÓÃPIPES_AS_CNCATģʽ£¬½«||¿´³ÉÊÇÆÕͨ×Ö·û´®
³£ÓõÄsql mode£º
sql modeÖµ ˵Ã÷
ANSI 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACEºÍANSI×éºÏ'£¬ÕâÖÖģʽʹÓï·¨ºÍÐÐΪ¸ü·ûºÏ±ê×¼µÄsql
STRICT_TRANS_TABLES ʹÓÃÓëÊÂÎñºÍ·ÇÊÂÎñ±í£¬Ñϸñģʽ
TRADITIONAL Ò²ÊÇÑϸñģʽ£¬¶ÔÓÚ²åÈë²»ÕýÈ·µÄÖµ¸ø³ö´íÎó¶ø²»ÊǾ¯¸æ¡£ÓÃÔÚÊÂÎñʱ£¬Ö»Òª·¢Éú´íÎó¾ÍÁ¢¼´»Ø¹ö
±¾ÎÄÀ´×Ô: (www.91linux.com) Ïêϸ³ö´¦²Î¿¼£ºhttp://www.91linux.com/html/article/database/mysql/20081127/13955.html
Ïà¹ØÎĵµ£º
ÈçºÎ´´½¨ SQL Server 2005 ÐÂÕË»§£¿
Ê×ÏÈÒªÉèÖÃSQL Server 2005µÄ·ÃÎÊ·½Ê½
1´ò¿ªSQL Server Management Studio
2·þÎñÆ÷Ãû³ÆÉÏÓÒ¼üÑ¡Ôñ“ÊôÐÔ”£¬´ò¿ª“·þÎñÆ÷ÊôÐÔ”¶Ô»°¿ò£¬ÔÚ“Ñ¡ÔñÒ³”ÀïÑ¡Ôñ“°²È«ÐÔ”£¬ÔÚ“·þÎñÆ÷Éí·ÝÑéÖ¤”ÀïÑ¡Ôñ“SQL ServerºÍWindows É ......
SQL Server 2005 ·þÎñÆ÷½ÇÉ«ºÍÊý¾Ý¿â½ÇÉ«ÃûÈ«½â
/*·þÎñÆ÷½ÇÉ«*/
sysadmin
--ÔÚ SQL Server ÖнøÐÐÈκλ¡£¸Ã½ÇÉ«µÄȨÏÞ¿çÔ½ËùÓÐÆäËü¹Ì¶¨·þÎñÆ÷½ÇÉ«¡£
serveradmin
--ÅäÖ÷þÎñÆ÷·¶Î§µÄÉèÖá£
setupadmin
--Ìí¼ÓºÍɾ³ýÁ´½Ó·þÎñÆ÷£¬²¢Ö´ÐÐijЩϵͳ´æ´¢¹ý³Ì£¨Èç sp_serveroption£©¡£
securityadmin
--¹ÜÀí·þÎñÆ÷ ......
1Ð޸Ļù±¾±í
Ìí¼ÓÁÐ alter table tableName add<ÐÂÁÐÃû><Êý¾ÝÀàÐÍ>[ÍêÕûÐÔÔ¼Êø]
ɾ³ýÁÐ alter table tableName drop<ÐÂÁÐÃû><Êý¾ÝÀàÐÍ>[ÍêÕûÐÔÔ¼Êø]
2´´½¨
½¨±ícreate table tableName(
id primary key AUTO_INCREMENT(mysql);
id primary key identity(1,1)(s ......
½â¾ö·½·¨Ò»:(×îÖØÒªµÄÒ»ÖÖ·½·¨)
Äã¿´ÏÂmy.ini£¬ÓÐÎÞ
[mysql]
default-character-set=utf8
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
È»ºó½¨Á¢±íʱ£¬Ò²ÒªÓ㨱ÈÈ磩
DROP TABLE IF EXISTS `Company`;
CREATE &nb ......
¹ýÂËÆ÷Ìõ¼þ
mysql.query contains "SELECT"
..
..
..
..
MySQL Protocol
Packet Length: 168
Packet Number: 0
Command
Command: Query (3)
State ......