oracle£¬mysql ºÍhibernateµÄÎÊÌâ¡£¡£¡£¡£¡£¡£¡£¼±
ÊÇÕâÑùµÄ£¬Ç°Ð©ÌìÎÒ·¢ÁËÒ»¸öoracle¸ÄmysqlµÄÌùô£¬ÏÖÔÚÓÖÓöµ½Á˵ãÎÊÌâ¡£¡£¡£Çë´ó¼Ò°ï°ïæ
oracleÀï±ßµÄlongÐÍ Ó³Éäµ½hibernateÀï±ßÊÇlongÐ굀 £¬µ«Êǵ½ÁËmysqlÓ³ÉähibernateµÄʱºò¾ÍûÓÐlongÐÍÁË £¬¶¼ÊÇintÀàÐ͵쬳ýÁ˸ijÌÐò£¬»¹ÓÐÆäËûµÄ°ì·¨Â𣿣¿£¿¡¢±ÈÈç˵ÔÚÊý¾Ý¿âÀï±ß¸ÄһϠ»òÕßÔÚÄÄÀïд¸ö¼àÌýʲôµÄ¡£¡£¡£¡£¡£Ð»Ð»´ó¼ÒÁË
Ã²ËÆÖ»ÄܸijÌÐòÁË£¬ºÇºÇ¡£
bigintÐÍ
mysqlÀïÃæÓиöbigintÀàÐÍ¡£
bigint
Äã¿ÉÒÔÄÃÒ»±¾MySqlµÄÊé¿´¿´
ÆðÂëŪÇå³þMySqlµÄÒ»°ã×Ö¶ÎÀàÐͰÉ
²»ÒªÕâôÓÐÎÊÌâ¾ÍÎÊ
bigintÀàÐÍÄÜÓ³Éäµ½³ÌÐòÀï±ßÊÇlongÀàÐÍÂ𣿣¿£¿£¿£¿
ллÁË ÕæÊÇ̫ллÁË
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
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. ......
ÎÒÓõÄlikeÄ£ºý²éѯ£¬±ÈÈçmysqlµÄnameÖÐÓС°csdnÂÛ̳ϵͳ¡±Õ⼸¸ö×Ö£¬ÈçºÎÔÚ <input>Öвéѯ¡°csdn ϵͳ¡±Ò²ÄܳöÀ´Õâ¸ö¡°csdnÂÛ̳ϵͳ¡±£¬ÎÒÏÖÔÚÊDz顰csdn¡±»òÕß¡°ÏµÍ³¡±¶¼¿ÉÒÔ¡£Ð»Ð»¸÷λÁË£¡²»ÖªµÀÎÒÕâô±í´ï ......