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

oracle£¬mysql ºÍhibernateµÄÎÊÌâ¡£¡£¡£¡£¡£¡£¡£¼±

ÊÇÕâÑùµÄ£¬Ç°Ð©ÌìÎÒ·¢ÁËÒ»¸öoracle¸ÄmysqlµÄÌùô£¬ÏÖÔÚÓÖÓöµ½Á˵ãÎÊÌâ¡£¡£¡£Çë´ó¼Ò°ï°ïæ
oracleÀï±ßµÄlongÐÍ Ó³Éäµ½hibernateÀï±ßÊÇlongÐ͵Ġ £¬µ«Êǵ½ÁËmysqlÓ³ÉähibernateµÄʱºò¾ÍûÓÐlongÐÍÁË £¬¶¼ÊÇintÀàÐ͵쬳ýÁ˸ijÌÐò£¬»¹ÓÐÆäËûµÄ°ì·¨Â𣿣¿£¿¡¢±ÈÈç˵ÔÚÊý¾Ý¿âÀï±ß¸ÄһϠ »òÕßÔÚÄÄÀïд¸ö¼àÌýʲôµÄ¡£¡£¡£¡£¡£Ð»Ð»´ó¼ÒÁË
Ã²ËÆÖ»ÄܸijÌÐòÁË£¬ºÇºÇ¡£

bigintÐÍ

mysqlÀïÃæÓиöbigintÀàÐÍ¡£

bigint
Äã¿ÉÒÔÄÃÒ»±¾MySqlµÄÊé¿´¿´
ÆðÂëŪÇå³þMySqlµÄÒ»°ã×Ö¶ÎÀàÐͰÉ
²»ÒªÕâôÓÐÎÊÌâ¾ÍÎÊ

ÒýÓÃ
bigint
Äã¿ÉÒÔÄÃÒ»±¾MySqlµÄÊé¿´¿´
ÆðÂëŪÇå³þMySqlµÄÒ»°ã×Ö¶ÎÀàÐͰÉ
²»ÒªÕâôÓÐÎÊÌâ¾ÍÎÊ


bigintÀàÐÍÄÜÓ³Éäµ½³ÌÐòÀï±ßÊÇlongÀàÐÍÂ𣿣¿£¿£¿£¿

ÒýÓÃ
mysqlÀïÃæÓиöbigintÀàÐÍ¡£



ллÁË  ÕæÊÇ̫ллÁË


Ïà¹ØÎÊ´ð£º

mysqlÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

MySQLÈëÃÅ

MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

¾ÍÕÒÒ»±¾ºÜ»ù´ ......

mysqlÓï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

SELECT a.tguildname ,SUM(a.ct) +  if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT  tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......

Çë½Ìmysql innodbÊý¾ÝÎļþ´óС³¬¹ýϵͳÏÞÖÆµÄÎÊÌâ

ÓÉÓÚÒÔǰûÓÐinnodbµÄÓ¦Óþ­Ñ飬ÔÚÅäÖÃinnodbµÄinnodb_data_file_pathÑ¡ÏîʱÓõÄÊÇĬÈÏÅäÖã¨ibdata1:10M:autoexte
nd£© ,½ñÌì·¢ÏÖ´ËÊý¾Ý¿âÔÚͬ²½Ö÷Êý¾Ý¿âÊý¾Ýʱ£¨´ËinnodbÊÇ×÷Ϊһ̨myisam dbµÄÀ䱸»úÆ÷£©£¬ibda ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ