oracle£¬mysql ºÍhibernateµÄÎÊÌâ¡£¡£¡£¡£¡£¡£¡£¼±
ÊÇÕâÑùµÄ£¬Ç°Ð©ÌìÎÒ·¢ÁËÒ»¸öoracle¸ÄmysqlµÄÌùô£¬ÏÖÔÚÓÖÓöµ½Á˵ãÎÊÌâ¡£¡£¡£Çë´ó¼Ò°ï°ïæ
oracleÀï±ßµÄlongÐÍ Ó³Éäµ½hibernateÀï±ßÊÇlongÐ굀 £¬µ«Êǵ½ÁËmysqlÓ³ÉähibernateµÄʱºò¾ÍûÓÐlongÐÍÁË £¬¶¼ÊÇintÀàÐ͵쬳ýÁ˸ijÌÐò£¬»¹ÓÐÆäËûµÄ°ì·¨Â𣿣¿£¿¡¢±ÈÈç˵ÔÚÊý¾Ý¿âÀï±ß¸ÄһϠ»òÕßÔÚÄÄÀïд¸ö¼àÌýʲôµÄ¡£¡£¡£¡£¡£Ð»Ð»´ó¼ÒÁË
Ã²ËÆÖ»ÄܸijÌÐòÁË£¬ºÇºÇ¡£
bigintÐÍ
mysqlÀïÃæÓиöbigintÀàÐÍ¡£
bigint
Äã¿ÉÒÔÄÃÒ»±¾MySqlµÄÊé¿´¿´
ÆðÂëŪÇå³þMySqlµÄÒ»°ã×Ö¶ÎÀàÐͰÉ
²»ÒªÕâôÓÐÎÊÌâ¾ÍÎÊ
bigintÀàÐÍÄÜÓ³Éäµ½³ÌÐòÀï±ßÊÇlongÀàÐÍÂ𣿣¿£¿£¿£¿
ллÁË ÕæÊÇ̫ллÁË
Ïà¹ØÎÊ´ð£º
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º
Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£
Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¾ÍÕÒÒ»±¾ºÜ»ù´ ......
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. ......
ÓÉÓÚÒÔǰûÓÐinnodbµÄÓ¦ÓþÑ飬ÔÚÅäÖÃinnodbµÄinnodb_data_file_pathÑ¡ÏîʱÓõÄÊÇĬÈÏÅäÖã¨ibdata1:10M:autoexte
nd£© ,½ñÌì·¢ÏÖ´ËÊý¾Ý¿âÔÚͬ²½Ö÷Êý¾Ý¿âÊý¾Ýʱ£¨´ËinnodbÊÇ×÷Ϊһ̨myisam dbµÄÀ䱸»úÆ÷£©£¬ibda ......