Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MySQL Ñϸñģʽ sql_mode

ËäȻ˵ÎÒÃǾ¡Á¿ÔÚд³ÌÐòµÄʱºò¿ØÖƲåÈëµ½Êý¾Ý¿âµÄÊý¾Ý£¬¶ø²»ÒªÓÃÊý¾Ý¿âÈ¥ÅжÏÊý¾ÝµÄ¶Ô´í£¬µ«ÊÇÓÐʱºòΪÁË·½±ã»¹ÊÇÐèÒªÊý¾Ý¿â×ÔÉíµÄÈÝ´íÄÜÁ¦À´°ïÖúÎÒÃǴﵽĿµÄµÄ¡£¾ÙÀý˵Ã÷£º
´´½¨ÈçÏÂÊý¾Ý±í
CREATE TABLE `book` (
  `id` int(11) default NULL,
  `num` int(11) unsigned default NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk
insert into bookvalues(1,0),(2,0)
Ö´ÐÐupdate book set num='abc'£¬¾¹È»²»±¨´í£¬Ô­ÒòÊÇûÓÐÆôÓÃÑϸñģʽ¡£ËùÒÔ
ÏÈÖ´ÐÐset sql_mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION",
È»ºóÖ´ÐÐupdate book set num='abc'£¬Êý¾Ý¿â¾Í±¨´íÁË
Èç¹ûÏëÒ»ÀÍÓÀÒÝ£¬ÄǾÍÖ±½Ó°ÑÊý¾Ý¿âÅäÖÃÎļþmy.iniÖеÄÏà¹Ø²ÎÊýÉèÖÃΪ
# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"


Ïà¹ØÎĵµ£º

MySqlµ¼³ösql½Å±¾


mysqlµ¼³ösql½Å±¾ Êղؠ
   ×¢ÒâÊÂÏî:
*±ØÐëÔÚD:\LTSOFT\MYSQL4\bin> mysqldump -u root -p test > c:\a.sql
ÏȵýøÈëmysql°²×°Ä¿Â¼µÄbinÏ£¨¿ÉÒÔ¿´µ½ÀïÃæÓÐmysqldump.exe£©£¬Í¨³£mysqlĬÈϰ²×°ÔÚC:\Program    Files\MySQL\MySQL Server 5.0
* ²»ÄܽøÈëmysql ÃüÁîÀï.
MySQLµ¼³ ......

SQL 2005 ´æ´¢¹ý³Ì·ÖÒ³

create PROCEDURE [dbo].[P_PageTest]
    @SQL Nvarchar(max),  --SQLÓï¾ä²»°üÀ¨ÅÅÐò
    @CurPage int,    --µ±Ç°Ò³
    @PageRows int,    --Ò³Ãæ³ß´ç
 @Order Nvarchar(20),  --ÅÅÐò×Ö¶Î
 @OrderType Nvarchar( ......

mysql °²×°

Ò»¡¢°²×°
#
yum -y install mysql-server
¶þ¡¢ÅäÖÃ
# vi /etc/my.cnf¡¡ ← ±à¼­MySQLµÄÅäÖÃÎļþ
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility pack ......

ÈçºÎд¸ßЧµÄÅúÁ¿²åÈëºÍɾ³ýsqlÓï¾ä

×÷Õߣº²»Ïê ³ö´¦£ºÍøÂç×ªÔØ  2009/11/18 10:35:22 ÔĶÁ 109  ´Î
¡¡¡¡¼¼Êõˮƽ×ÜÄÜÔÚ³¶Æ¤ºÍ´µÃ«Çó´ÃÖеõ½Ìá¸ß¡£Èç¹û´ÓÀ´²»“Çó´Ã”£¬¿ÉÄܾͲ»»áÖªµÀif(str != "")²»Èçif(str != string.Empty)¸ßЧ¡¢ÅúÁ¿²åÈëºÍɾ³ýµÄsqlÓï¾äÊÇÒªÄÇÑùд²ÅÖ´ÐÐ×î¿ì¡¢½Ó¿ÚºÍ³éÏóÀàµÄÇø±ð²»½öÊÇÓïÑÔ²ãÃæ¡¢ ......

´øÄãÉîÈëÁ˽âMySQLÓï¾äÓÅ»¯µÄ»ù±¾Ô­Ôò


 
 
MySQLÓï¾äÓÅ»¯µÄ»ù±¾Ô­Ôò£º
¡ô1¡¢Ê¹ÓÃË÷ÒýÀ´¸ü¿ìµØ±éÀú±í¡£
ȱʡÇé¿öϽ¨Á¢µÄË÷ÒýÊÇ·ÇȺ¼¯Ë÷Òý£¬µ«ÓÐʱËü²¢²»ÊÇ×î¼ÑµÄ¡£ÔÚ·ÇȺ¼¯Ë÷ÒýÏ£¬Êý¾ÝÔÚÎïÀíÉÏËæ»ú´æ·ÅÔÚÊý¾ÝÒ³ÉÏ¡£ºÏÀíµÄË÷ÒýÉè¼ÆÒª½¨Á¢ÔÚ¶Ô¸÷ÖÖ²éѯµÄ·ÖÎöºÍÔ¤²âÉÏ¡£Ò»°ãÀ´Ëµ£º
a.ÓдóÁ¿Öظ´Öµ¡¢ÇÒ¾­³£Óз¶Î§²éѯ£¨ > ,< £¬> =,& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ