MYSQL ÕæµÄÄÇôǿ´ó¶øºÃѧ£¿£¿¸ß·Ö̽ÌÖ¡£
ĿǰºÜ¶à·þÎñÉ̶¼¿ªÊ¼Ê¹ÓÃlinux uninx ,²¢Ê¹ÓõÄÊý¾ÝºÃ¶à¶¼ÊÇMYSQL ORACLE¡£ ±¾ÈËÕýºÃѧ Lamp¿ò¼Ü¡£ ²»ÖªµÀMYSQL ÈçºÎ²ÅÄÜѧºÃÄØ£¿ ÓÐûÓÐMS-SQL ÄÇÖÖ²éѯ·ÖÎöÆ÷ »òÕß¹ÜÀíÆ÷ʲôµÄ£¿ ¸Õ½Ó´¥MYSQL Óеã¶ù²»Êì¡£ ÍûʹÓÃMYSQL Õß ¶à¶àÌáµã¶ù¾µä¶ø±¦¹óµÄ¼û½â ºÍ¾Ñé¡£ СµÜ£¬ÏÈллÀ²£¬ºÃµÄÎÊ´ð ÎÒ»á¸ø·Ö¡£ºÇºÇ
ÓÐûÓÐMS-SQL ÄÇÖÖ²éѯ·ÖÎöÆ÷ »òÕß¹ÜÀíÆ÷ʲôµÄ£¿ ͼÐλ¯¹ÜÀí¹¤¾ß£ºSQLYOG ²»ÖªµÀMYSQL ÈçºÎ²ÅÄÜѧºÃÄØ ÏÈ¿´¿´MYSQL¡¡HELP£¬ÔٶදÊÖʵ¼ù MYSQL ÕæµÄÄÇôǿ´ó¶øºÃѧ£¿ NO£¬Ö÷ÒªÊÇMYSQLÊÇFREEµÄ£¬µ«±»ORACLEÊÕ¹ººó£¬¿ª·¢ËÙ¶ÈËÆºõÂýÁËÐí¶à£¬²»ÖªµÀORACLE ÊÇÔõô¿¼Âǵģ¬Ç°Í¾²»Ã÷ÀÊ¡£ ѧϰÖÐ..... ÒýÓà ÓÐûÓÐMS-SQL ÄÇÖÖ²éѯ·ÖÎöÆ÷ »òÕß¹ÜÀíÆ÷ʲôµÄ£¿ ͼÐλ¯¹ÜÀí¹¤¾ß£ºSQLYOG ²»ÖªµÀMYSQL ÈçºÎ²ÅÄÜѧºÃÄØ ÏÈ¿´¿´MYSQL¡¡HELP£¬ÔٶදÊÖʵ¼ù MYSQL ÕæµÄÄÇôǿ´ó¶øºÃѧ£¿ NO£¬Ö÷ÒªÊÇMYSQLÊÇFREEµÄ£¬µ«±»ORACLEÊÕ¹ººó£¬¿ª·¢ËÙ¶ÈËÆºõÂýÁËÐí¶à£¬²»ÖªµÀORACLE ÊÇÔõô¿¼Âǵģ¬Ç°Í¾²»Ã÷ÀÊ¡£ ѧϰÖÐ..... ÒýÓà ѧϰÖÐ..... ÒýÓà 1 Â¥ wwwwa µÄ»Ø¸´: ÓÐûÓÐMS-SQL ÄÇÖÖ²éѯ·ÖÎöÆ÷ »òÕß¹ÜÀíÆ÷ʲôµÄ£¿ ͼÐλ¯¹ÜÀí¹¤¾ß£ºSQLYOG ²»ÖªµÀMYSQL ÈçºÎ²ÅÄÜѧºÃÄØ ÏÈ¿´¿´MYSQL¡¡HELP£¬ÔٶදÊÖʵ¼ù MYSQL ÕæµÄÄÇôǿ´ó¶øºÃѧ£¿ NO£¬Ö÷ÒªÊÇMYSQLÊÇFREEµÄ£¬µ«±»ORACLEÊÕ¹ººó£¬¿ª·¢ËÙ¶ÈËÆºõÂýÁËÐí¶à£¬²»Öª
Ïà¹ØÎÊ´ð£º
mysql>create book( ->id varchar(20) not null,g -> ÒÔÉÏÊÇÔÚmysqlÃüÁîÐÐÀïµÄ²Ù×÷ ÔÚÉÏÃæÖÐÎÒÔÚµ¹ÊýµÚ¶þÐжà´òÁËÒ»¸ö×ÖĸgÈ»ºó°´Á˻سµ¼ü£¬ÇëÎÊ´Óµ¹ÊýµÚÒ»ÐÐÔõô ......
½¨±í£º²å¼Ç¼ SQL code: create table tablename (id int,RQ1 datetime,RQ2 datetime) -- select * from tablename insert into tablename select 1,'2009-01-01 10:00:00','2009-01-02 11:00:00' union ......
ÈçÌ⣬MySQL²»»áÕâÑù°É Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£ http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx MySQL ÖÐÎÄÏÔʾÂÒÂë Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖà ֧³Ö£¬¼ì² ......
SQL code: CREATE PROCEDURE A() BEGIN DECLARE 'Constraint Violation' CONDITION FOR sqlexception; DECLARE EXIT HANDLER FOR 'Constraint Violation' ROLLBACK; BEGIN TRAN ......
ÎÒÓÐÁ½¸ö±í. a±íÖÐÓлý·Ö×Ö¶Î. b±íÒ²Óиö»ý·Ö×Ö¶Î. ÒòΪa±íºÍb±íÊôÓÚ²»Í¬Á½¸öƽ̨. Èç¹û×öµ½Í¬²½?¾ÍÊÇa±íÐ޸ĵÄʱºòͬʱÐÞ¸Äb±í.ͬʱb±íÐ޸ĵĻ°Ò²ÐÞ¸Äa±í. ±í 1 bbs_member ......