mysql×Ö¶ÎÌáÈ¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬
Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ
a
the
that
this
of
at
in
to
ÔÎËÀ£¬Â¥ÉϵÄÄãÌ«ÓвÅÁË¡£
ÄĸöÐÖµÜÕý¾À´°ï°ï°¡£¬ÌáÊ®¸ö£¬¾ÍÊÇΪÁ˽«À´ºÃÔÙÈ¥µôÕâЩ ³£¼ûÎÞʵÒâ´Ê
ʵÏÖÆðÀ´ÊÇ¿ÉÒÔ£¬¹Ø¼üÊÇЧÂʾͲ»¸Ò±£Ö¤ÁË¡£
ÎÞ·¨ÓÃSQLÓï¾äÀ´½â¾ö£¬ÐèÒªÓô洢¹ý³Ì¡£
¼òµ¥µÄSQLÓï¾ä£¬²»ÐС£ ÔÚÓ¦ÓóÌÐòÀïÃæÊµÏÖ°É¡£¾ÍËã·Åµ½´æ´¢¹ý³ÌÀïÃæ£¬ÏµÍ³Ò»ÉÏÏߣ¬Äã²¢·¢Ò»´ó£¬ ¾ÍOVERÁË¡£
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......
ÎÒÐèÒª½«Êý¾Ý¿âµÄ±íµ¼³öÀ´£¬ÏÖÔÚ¿âÀïµÄ×Ö·û¼¯ÊÇÂҵģ¬ÎÒÏëÏÈÉèÖÃlatin1¸ñʽµ¼³öÀ´£¬Äܲ»ÄܸæËßÎÒÔõô½øÈëmysqlÃüÁî·ûÏ£¿ºÃÏñÊDZØÐë½øÈëmysqlÃüÁî·ûϲÅÐУ¬ÎÒµÄϵͳÊÇlinux£¬ÎÒÓÃlocate mysql ²éµ½Á˺öàĿ¼£¬²»Öª ......