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±ê×¼¡£
Ïà¹ØÎĵµ£º
unixODBC°²×°
Õ⼸ÌìÕæÊÇÓôÃÆËÀÁË£¬»ù±¾Ã¿Ìì¶¼ÔÚ±àÒë°²×°QTºÍunixODBC£¬ÎÞÄÎ×Ü»á³öÏÖЩĪÃûÆäÃîµÄ´íÎó¡£Ê×ÏÈ£¬ÎÒ³ÐÈÏÎÒLinuxÍæµØ²»Ê죬µ«ÕâЩ¿ªÔ´Èí¼þ²úÉÌÖ®¼äµÄ¼æÈÝÐÔҲ̫²îÁ˰ɡ£ËùÒÔ»¹ÊÇÖÆ¶¨¸ö±ê×¼±È½ÏºÃ£¬´ó¼Ò¶¼×ñÊØÒ»¸öÔ¼¶¨¡£´ÓÕâ¸öÒâÒåÀ´Ëµ£¬Î¢ÈíµÄ¢¶Ï£¬»¹ÊÇÓÐÒ»¶¨µÄºÃ´¦µÄ¡£
......
1. Êý¾Ý¿â
Çл»Êý¾Ý¿â£º use mydb
2. ʼþ
²é¿´Ê¼þ£º show events
Æô¶¯µ÷¶ÈÆ÷: set global event_scheduer = 1;
²é¿´ÊÇ·ñÆô¶¯£º show variables like 'event_scheduler';
3. ±¸·Ý
ÔÚadministatorÖеÄbackupÖÐÎÞ·¨±¸·ÝÊý¾Ý¿âµÄʼþ¡£ÐèÒªÊÖ¶¯½«´´½¨Ê¼þµÄ½Å±¾Ìí¼Óµ½sql±¸ ......
Èí¼þ°æ±¾:
php-5.2.13-Win32
apache_2.2.9-win32-x86-no_ssl-r2.msi(×¢Ò⣺APACHE 2.2.X°æ±¾ÒÔÉÏÒªÔö¼Ó²å¼þ²ÅÖ§³ÖPHP 5µÄ)
mysql-5.1.44-win32.msi
ÏÈ×°µÄphp5,Ö±½Ó½âѹÎļþµ½C:\php(°²×°µ½ÄÄÀï²¢²»»áÓÐÓ°Ï죬ƾ¸öÈËϲºÅ£¬±¾ÎÄÖеÄËùÓз¾¶¶¼ÒÔÎҵݲװ·¾¶£¬Çë´ó¼ÒÔÚ×Ô¼ºµÄ»úÆ÷Éϰ²×°µÄʱºò×¢ÒâÐÞ¸ÄΪ×Ô¼ºµÄ·¾¶)
½Ó× ......
µÚÒ»²½£¬ÏÂÔØMysqlµÄJDBCÇý¶¯³ÌÐò£¬ÃûΪconnectorJ¡£ÏÂÔØÍøÖ·£ºhttp://dev.mysql.com/downloads/connector/j/
½âѹËõzipÎļþºó£¬½«Îļþmysql-connector-java-5.1.12-bin.jarµ½Ä¿Â¼d:\Software\MySQL\MySQL Server 5.1\jdbcdriver\ÖÐ
µÚ¶þ²½£¬ÐÞ¸ÄÎļþd:\Software\bea\WebLogic 9.23\user_projects\domains\MyDomain\bin\s ......
°²×°»·¾³£º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 (½øÈëѹËõ°ü ......