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

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ÖкóÍËÃüÁ

mysql>create book(
    ->id varchar(20) not null,g
    ->
ÒÔÉÏÊÇÔÚmysqlÃüÁîÐÐÀïµÄ²Ù×÷
ÔÚÉÏÃæÖÐÎÒÔÚµ¹ÊýµÚ¶þÐжà´òÁËÒ»¸ö×ÖĸgÈ»ºó°´Á˻سµ¼ü£¬ÇëÎÊ´Óµ¹ÊýµÚÒ»ÐÐÔõô ......

MYSQL 5.0£¬ÊÂÎñ»Ø¹öµÄÎÊÌâ

½¨±í£º²å¼Ç¼
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²»Ö§³ÖÖÐÎİ¡£¿£¿

ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë

Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ

Ö§³Ö£¬¼ì² ......

MYSQLÊÂÎñ»Ø¹öµÄÎÊÌâ

SQL code:

CREATE PROCEDURE A()
BEGIN
DECLARE 'Constraint Violation'
CONDITION FOR sqlexception;
DECLARE EXIT HANDLER FOR
'Constraint Violation' ROLLBACK;
BEGIN TRAN ......

ÓйØmysqlÁ½¸ö±íij×Ö¶ÎÊý¾Ýͬ²½µÄÎÊÌâ

ÎÒÓÐÁ½¸ö±í.
a±íÖÐÓлý·Ö×Ö¶Î.
b±íÒ²Óиö»ý·Ö×Ö¶Î.
ÒòΪa±íºÍb±íÊôÓÚ²»Í¬Á½¸öƽ̨.
Èç¹û×öµ½Í¬²½?¾ÍÊÇa±íÐ޸ĵÄʱºòͬʱÐÞ¸Äb±í.ͬʱb±íÐ޸ĵĻ°Ò²ÐÞ¸Äa±í.



±í  1 
bbs_member ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ