<\/span><\/h2>\n\n\n\n\u5206\u522binsert\u957f\u5ea6\u4e3a3\uff0c4\uff0c9\uff0c10\u7684\u6570\u5b57\uff0c\u5747\u6b63\u5e38\u5165\u5e93\u3002\u957f\u5ea6\u4e3a11\u7684\uff0c\u62a5\u8d85\u8fc7\u6570\u5b57\u8303\u56f4\u7684\u9519\u8bef\u3002\u800c2\u768431\u6b21\u65b9\uff0c\u957f\u5ea6\u4e3a10\uff0c\u7b97\u4e0a\u8d1f\u53f7\uff0c\u6b63\u597d11\u4f4d\u3002<\/p>\n\n\n\n
gbase> insert into t1 values(123);\nQuery OK, 1 row affected (Elapsed: 00:00:00.09)\n\ngbase> insert into t1 values(1234);\nQuery OK, 1 row affected (Elapsed: 00:00:00.10)\n\ngbase> insert into t1 values(123456789);\nQuery OK, 1 row affected (Elapsed: 00:00:00.09)\n\ngbase> insert into t1 values(1234567890);\nQuery OK, 1 row affected (Elapsed: 00:00:00.09)\n\ngbase> insert into t1 values(12345678901);\nERROR 1264 (22003): Out of range value for column 'id' at row 1\ngbase> select power(2,31);\n+-------------+\n| power(2,31) |\n+-------------+\n| 2147483648 |\n+-------------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<\/span>\u6d4b\u8bd5int(3)\u52a0\u8f7d<\/span><\/h2>\n\n\n\n\u53ef\u4ee5\u6b63\u5e38\u52a0\u8f7d\uff0c\u4e0d\u4f1a\u56e0\u4e3a\u957f\u5ea6\u8d85\u8fc73\u800c\u62a5\u9519\u3002<\/p>\n\n\n\n
gbase> select * from t1;\n+------------+\n| id |\n+------------+\n| 123 |\n| 1234 |\n| 123456789 |\n| 1234567890 |\n+------------+\n4 rows in set (Elapsed: 00:00:00.02)\n\ngbase> load data infile 'ftp:\/\/gbase:gbase1234@10.0.2.101\/t1_2.txt' into table t1;\nQuery OK, 10 rows affected (Elapsed: 00:00:00.40)\nTask 21 finished, Loaded 10 records, Skipped 0 records\n\ngbase> select * from t1;\n+------------+\n| id |\n+------------+\n| 123 |\n| 1234 |\n| 123456789 |\n| 1234567890 |\n| 13700 |\n| 7748 |\n| 27384 |\n| 32486 |\n| 10580 |\n| 1371 |\n| 10886 |\n| 28139 |\n| 12636 |\n| 25419 |\n+------------+\n14 rows in set (Elapsed: 00:00:00.01)\n<\/code><\/pre>\n\n\n\n<\/span>\u6d4b\u8bd5\u9ed8\u8ba4int<\/span><\/h2>\n\n\n\n\u957f\u5ea6\u4f4d11\u4f4d\uff0c\u8981\u5305\u542b\u8d1f\u53f7\u3002<\/p>\n\n\n\n
gbase> create table t2(id int);\nQuery OK, 0 rows affected (Elapsed: 00:00:00.15)\n\ngbase> desc t2;\n+-------+---------+------+-----+---------+-------+\n| Field | Type | Null | Key | Default | Extra |\n+-------+---------+------+-----+---------+-------+\n| id | int(11) | YES | | NULL | |\n+-------+---------+------+-----+---------+-------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase> insert into t2 values(-1234567890);\nQuery OK, 1 row affected (Elapsed: 00:00:00.09)\n<\/code><\/pre>\n\n\n\n<\/span>Bigint\u6d4b\u8bd5<\/span><\/h2>\n\n\n\n\u6700\u957f19\u4f4d\uff0c\u7b97\u4e0a\u8d1f\u53f7\u662f20\u4f4d\u3002<\/p>\n\n\n\n
gbase> create table t3(id bigint);\nQuery OK, 0 rows affected (Elapsed: 00:00:00.14)\n\ngbase> desc t3;\n+-------+------------+------+-----+---------+-------+\n| Field | Type | Null | Key | Default | Extra |\n+-------+------------+------+-----+---------+-------+\n| id | bigint(20) | YES | | NULL | |\n+-------+------------+------+-----+---------+-------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase> insert into t3 values (-1234567890123456789);\nQuery OK, 1 row affected (Elapsed: 00:00:00.10)\n\ngbase> insert into t3 values (-12345678901234567890);\nERROR 1264 (22003): Out of range value for column 'id' at row 1\ngbase>\n<\/code><\/pre>\n\n\n\n<\/span>Decimal\u7c7b\u578b\u6d4b\u8bd5<\/span><\/h2>\n\n\n\ndecimal\u4e25\u683c\u505a\u4e86\u957f\u5ea6\u9650\u5236\uff0c\u8d1f\u53f7\u4e0d\u5728\u8303\u56f4\u5185\u3002<\/p>\n\n\n\n
gbase> create table t4(id decimal(5));\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.15)\r\n\r\ngbase> insert into t4 values(1234);\r\nQuery OK, 1 row affected (Elapsed: 00:00:00.09)\r\n\r\ngbase> insert into t4 values(12345);\r\nQuery OK, 1 row affected (Elapsed: 00:00:00.09)\r\n\r\ngbase> insert into t4 values(123456);\r\nERROR 1264 (22003): Out of range value for column 'id' at row 1\n\r\ngbase> insert into t4 values(-12345);\r\nQuery OK, 1 row affected (Elapsed: 00:00:00.09)\r\n\r\ngbase> select * from t4;\r\n+--------+\r\n| id |\r\n+--------+\r\n| 1234 |\r\n| 12345 |\r\n| -12345 |\r\n+--------+\r\n3 rows in set (Elapsed: 00:00:00.01)\r\n\r\ngbase> desc t4;\r\n+-------+--------------+------+-----+---------+-------+\r\n| Field | Type | Null | Key | Default | Extra |\r\n+-------+--------------+------+-----+---------+-------+\r\n| id | decimal(5,0) | YES | | NULL | |\r\n+-------+--------------+------+-----+---------+-------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n\r\n<\/code><\/pre>\n\n\n\n<\/span>Summary<\/span><\/h2>\n\n\n\n\u5bf9int\u3001bigint\u7c7b\u578b\uff0c\u53ea\u8981\u4e0d\u8d85\u8fc7\u5176\u8303\u56f4\u9650\u5236\uff0c\u4ece\u5b9e\u73b0\u770b\u5e76\u4e0d\u5bf9\u5176\u957f\u5ea6\u505a\u3010\u4e25\u683c\u3011\u9650\u5236\u3002decimal\u505a\u4e86\u4e25\u683c\u9650\u5236\u3002<\/p>","protected":false},"excerpt":{"rendered":"
\u6839\u636e\u6d4b\u8bd5\u7ed3\u679c\uff0cGBase 8a\u6570\u636e\u5e93\u7684\u6570\u5b57\u7c7b\u578b\u957f\u5ea6\uff0cint\u548cbigint\u5e76\u6ca1\u6709\u505a\u3010\u4e25\u683c\u3011\u7684\u9650\u5236\uff0c\u9664\u975e\u8d85\u8fc7\u4e86\u7c7b\u578b\u5141\u8bb8\u7684\u6700\u5927\u957f\u5ea6\u3002\u7b97\u4e0a\u8d1f\u6570\u7684\u6807\u5fd7\uff0cint\u6700\u957f11\u4f4d\uff0cbigint\u662f20\u4f4d\u3002decimal\u505a\u4e86\u4e25\u683c\u9650\u5236\uff0c\u8d85\u4e86\u957f\u5ea6\u4f1a\u62a5\u9519\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-7722","post","type-post","status-publish","format-standard","hentry","category-gbase8a"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/7722","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=7722"}],"version-history":[{"count":6,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/7722\/revisions"}],"predecessor-version":[{"id":7751,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/7722\/revisions\/7751"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=7722"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=7722"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=7722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}