mysqlÊý¾Ý¿â·þÎñÆ÷ÉÏÏßǰµÄÒÉÎÊ
ÈÕIPÊýǧ ÒÔºó»áÉÏÍò Ò²ÊÇflex+javaÓÎÏ·ÀàÐ͵ÄÍøÕ¾ ¼¯ÖÐÔڸ߷åÆÚÍíÉÏ
ÇëÎÊÊý¾Ý¿â·þÎñÆ÷µÄ»úÆ÷ÓÃÊ²Ã´Æ·ÅÆºÃ£¿ÍƼöÒ»¸öÅäÖã¿
ÏÖÔÚÊý¾Ý¿âÊÇʹÓÃmysql5.0 ÊDz»ÊÇÊʺϣ¿ ¸Ã²»¸Ã»»³ÉOralce(ÏÖÔÚ»»»¹À´µÃ¼°)
Èç¹û¼ÌÐøÊ¹ÓÃmysql 1̨µçÄÔ×öÖ÷·þÎñÆ÷ һ̨×öÈȱ¸ ºÏÊʲ» ?
»¹ÊÇ2̨һÆð×ö ¼¯Èº ÁíÍâһ̨×ö¹ÜÀí½Úµã
ÏÖÔÚÊý¾Ý¿âÊÇʹÓÃmysql5.0 ÊDz»ÊÇÊʺϣ¿ ¸Ã²»¸Ã»»³ÉOralce(ÏÖÔÚ»»»¹À´µÃ¼°)
Èç¹ûÄÜÓÃORACLE£¬Ôò¸ù±¾²»ÐèÒªÔÚ¿ªÊ¼½×¶ÎÀ´¿¼ÂÇ mysql, ²»Ñ¡ORACLEµÄΨһÔÒò¾ÍÊǼ۸ñ¡£
Èç¹û¿ÉÒÔ£¬ÇëÂíÉϸü»»ÎªORACLE
Èç¹û¼ÌÐøÊ¹ÓÃmysql 1̨µçÄÔ×öÖ÷·þÎñÆ÷ һ̨×öÈȱ¸ ºÏÊʲ» ?
ÓÐЩΣÏÕ£¬Èç¹û¼á³ÖʹÓÃMYSQL£¬½¨Ò鿴һϠmysql cluster£¬Ò»Ì¨µÄ»°Ñ¹Á¦ÓÐЩ´óÁË¡£
ÈÕIPÊýǧ ÒÔºó»áÉÏÍò Ò²ÊÇflex+javaÓÎÏ·ÀàÐ͵ÄÍøÕ¾ ¼¯ÖÐÔڸ߷åÆÚÍíÉÏ£º
ͬʱµÇ¼£¿ ±È½Ï³ÔÁ¦
ÇëÎÊÊý¾Ý¿â·þÎñÆ÷µÄ»úÆ÷ÓÃÊ²Ã´Æ·ÅÆºÃ£¿ÍƼöÒ»¸öÅäÖã¿
ÓÃÆóÒµ¼¶µÄ·þÎñÆ÷£¬HP¡¢DELL¶¼²»´í£¬Ë«CPU£¬Äڴ澡¿ÉÄÜ´ó16G£¬¶øÇÒË«»úÈȱ¸·Ý£¬ÓôÅÅ̳ÂÁÐ
ÏÖÔÚÊý¾Ý¿âÊÇʹÓÃmysql5.0 ÊDz»ÊÇÊʺϣ¿ ¸Ã²»¸Ã»»³ÉOralce(ÏÖÔÚ»»»¹À´µÃ¼°)
²»ÖªµÀ·¢Õ¹Ç°¾°¼°MONEYÊÇ·ñ³ä×㣬Èç¹û·¢Õ¹µÃºÃ£¬ÓÃORACLE
????????¾ªÈËÏàËÆ¡£wwwwbºÍWWWWAÊDz»ÊÇͬһ¸öÈ˰¡?
mysql ÉìËõÐԱȽϴó ËùÒÔÒª¼á³ÖÓÃmysqlµÄ»°·þÎñÆ÷µÄÄÚ´æÒª×ã¹»´ó
¶ÔÓÚÖ÷´Ó·þÎñÆ÷ Èç¹ûÄãÊý¾ÝÁ¿²»ÊǺܴó ¿ÉÒÔ¼á³ÖÓÃ
µ«ÊÇÈç¹ûÊý¾ÝÁ¿¹ý¶àÓÖÒª±¸·Ý´æ´¢ ¿ÉÒÔ¿¼ÂǼ¯Èº
oracle»¹ÊDz»ÓÃÁË°É Ì«¹ó ¾¡¹ÜËüÊÕ¹ºÁËmysql mysql»¹ÊǺÜÇ¿´ó
лл¥ÉϵĸçÃÇ£¬ÄÜ·ñÍÆ¼öÒ»¿î×Ô¼ºÏ
Ïà¹ØÎÊ´ð£º
ÔÚmysqlÖÐrepair table xxxxx;Ìáʾ
mysql> repair table recordTbl;
+-----------------+--------+----------+----------------------------------------------+
| Table   ......
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()
SQL code:
sqlÀïÊÇ£º
getdate()
ÒýÓÃ
now()
ѧϰ
SQL code:
select now();
SQL code:
TODAY()
?
SQL code:
select now();
/* ......