Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

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 ÈçºÎÐÞ¸ÄBLOBÀàÐ͵ÄÊý¾Ý?

ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿

¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º
SQL code:
update tb_blog set memo=concat( ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ