É¢·Ö£¬mysqlÖÐÓйØ~·ûºÅÔõôÓã¿
Çë¹ý·ÅóÓѸøµã~·ûºÅµÄʵÀý£¬Ï×ÉÏ50·Ö¡£
·´×ªËùÓбÈÌØ¡£
mysql> SELECT 5 & ~1;
-> 4
ÎÒÖªµÀÊÇתÒâµÄÒâ˼£¬ÎÒÊÇÔÚÍøÉÏÕÒmysqlÔõÑù½«Ò»¾ä´øÓе¥ÒýºÅµÄÓï¾äÊä½øÊý¾Ý¿â£¬È»ºóÓÐÈË˵ÓÃ~תÒ⣬µ«ÎÒ²¢²»ÖªµÀ~Ôõôת£¬ËùÒÔÏëÎÊÏÂ~תÒâµÄÓ÷¨£¬²¢²»ÊÇ·´±ÈÌØµÄÒâ˼¡£
Òª°Ñµ¥ÒýºÅ²åÈëÊý¾Ý¿âÖÐ,ÓÃÁ½¸öµ¥ÒýºÅ¾Í¿ÉÒÔÁË¡£
SQL code:
mysql> select * from test;
Empty set (0.00 sec)
mysql> insert into test values('''');
Query OK, 1 row affected (0.03 sec)
mysql> select * from test;
+------+
| str |
+------+
| ' |
+------+
1 row in set (0.00 sec)
ʹÓÃ\'תÒå¼´¿É¡£
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£
echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿
PHP code:
<?php
$str="select * from product wh ......