{"rsdb":{"rid":"157252","subhead":"","postdate":"0","aid":"117968","fid":"57","uid":"1","topic":"1","content":"
\u5173\u4e8e MySQL\u6570\u636e\u7c7b\u578b\u7684\u4e00\u4e9b\u7b14\u8bb0\u3002<\/p>
\u6574\u578b\u7684\u6bcf\u4e00\u79cd\u90fd\u6709\u65e0\u7b26\u53f7\uff08unsigned\uff09\u548c\u6709\u7b26\u53f7\uff08signed\uff09\u4e24\u79cd\u7c7b\u578b\u3002<\/p>
decimal(m,d) \u5b9a\u70b9\u7c7b\u578b\uff1a\u6d6e\u70b9\u578b\u5728\u6570\u636e\u5e93\u4e2d\u5b58\u653e\u7684\u662f\u8fd1\u4f3c\u503c\uff0c\u800c\u5b9a\u70b9\u7c7b\u578b\u5728\u6570\u636e\u5e93\u4e2d\u5b58\u653e\u7684\u662f\u7cbe\u786e\u503c\u3002\u53c2\u6570m\u662f\u5b9a\u70b9\u7c7b\u578b\u6570\u5b57\u7684\u6700\u5927\u4e2a\u6570\uff08\u7cbe\u5ea6\uff09\uff0c\u8303\u56f40~65\uff0cd\u4e3a\u5c0f\u6570\u70b9\u53f3\u4fa7\u6570\u5b57\u7684\u4e2a\u6570\uff0c\u8303\u56f4\u4e3a0~30.\u4f46\u4e0d\u80fd\u8d85\u8fc7m\u3002<\/p>
\u5bf9\u5b9a\u70b9\u6570\u8ba1\u7b97\u80fd\u7cbe\u786e65\u4f4d\u6570\u5b57\u3002<\/p>
char\u548cvarchar\uff1a<\/p>
varchar\u548ctext\uff1a<\/p>
xxxblob\u548cxxxtext\u662f\u5bf9\u5e94\u7684\uff0c\u4e0d\u8fc7\u5b58\u50a8\u65b9\u5f0f\u4e0d\u540c\u3002xxxtext\u662f\u4ee5\u6587\u672c\u65b9\u5f0f\u5b58\u50a8\u7684\uff0c\u5982\u679c\u5b58\u50a8\u82f1\u6587\uff0c\u5e94\u533a\u5206\u5927\u5c0f\u5199\uff1b\u800cxxxblob\u662f\u4ee5\u4e8c\u8fdb\u5236\u65b9\u5f0f\u5b58\u50a8\u7684\uff0c\u4e0d\u533a\u5206\u5927\u5c0f\u5199\u3002<\/p>
xxxblob\u5b58\u50a8\u7684\u6570\u636e\u53ea\u80fd\u6574\u4f53\u8bfb\u51fa\u3002<\/p>
xxxtext\u53ef\u4ee5\u6307\u5b9a\u5b57\u7b26\u96c6\uff0cxxxblob\u4e0d\u80fd\u6307\u5b9a\u5b57\u7b26\u96c6<\/p>
timestamp\u6bd4\u8f83\u7279\u6b8a\uff0c\u5982\u679c\u5b9a\u4e49\u4e00\u4e2a\u5b57\u6bb5\u7684\u7c7b\u578b\u4e3atimestamp\uff0c\u8fd9\u4e2a\u5b57\u6bb5\u7684\u65f6\u95f4\u4f1a\u5728\u5176\u4ed6\u5b57\u6bb5\u4fee\u6539\u7684\u65f6\u5019\u81ea\u52a8\u5237\u65b0\u3002\u6240\u4ee5\u8fd9\u4e2a\u6570\u636e\u7c7b\u578b\u7684\u5b57\u6bb5\u53ef\u4ee5\u5b58\u653e\u8fd9\u6761\u8bb0\u5f55\u6700\u540e\u88ab\u4fee\u6539\u7684\u65f6\u95f4\uff0c\u800c\u4e0d\u662f\u771f\u6b63\u7684\u5b58\u653e\u65f6\u95f4\u3002<\/p>
\u5728\u5b9a\u4e49\u8868\u65f6\uff0c\u53ef\u4ee5\u6307\u5b9a\u6bcf\u4e2a\u5b57\u6bb5\u7684\u4e00\u4e9b\u5c5e\u6027\u3002<\/p>
","orderid":"0","title":"\u5173\u4e8e MySQL\u6570\u636e\u7c7b\u578b","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"7155","pages":"1","comments":"0","posttime":"2017-05-27 17:35:58","list":"1495877758","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"\u5173\u4e8e<\/A> MySQL<\/A> \u6570\u636e<\/A> \u7c7b\u578b<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"218.17.197.194","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"\u5173\u4e8e MySQL\u6570\u636e\u7c7b\u578b","lastview":"1695739183","digg_num":"9771","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}