Kenapa yah ????
MySQL 4.1.21
mysql> create table x (i integer);
Query OK, 0 rows affected (0.75 sec)
Query OK, 0 rows affected (0.75 sec)
mysql> insert into x values (9999999999);
Query OK, 1 row affected, 1 warning (0.13 sec)
mysql> select * from x;
+————+
| i |
+————+
| 2147483647 |
+————+
1 row in set (0.04 sec)
mysql>
PostgreSQL 8.2.4
test=# create table x (i integer);
CREATE TABLE
test=# insert into x values (9999999999);
ERROR: integer out of range
test=#
CREATE TABLE
test=# insert into x values (9999999999);
ERROR: integer out of range
test=#
Cara setting MySQL nya gimana yah biar kalo kita insert seperti diatas (MySQL) tidak akan mau masuk seperti halnya jika kita insert di PostgrSQL ???
Salam kenal.
http://www.alatsurveycenter.com/
untu table pake type InooDb jangan myisam