rendered paste bodycreate table pelicula(
id_pelicula int(10),
titulo text,
fecha int(4),
sinopsis text,
origen text,
idioma text,
color text,
duracion text,
foto text,
misc text
)
type=innodb;
mysql> describe pelicula;
+-------------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------+------+-----+---------+-------+
| id_pelicula | int(10) | NO | PRI | 0 | |
| titulo | text | YES | | NULL | |
| fecha | int(4) | YES | | NULL | |
| sinopsis | text | YES | | NULL | |
| origen | text | YES | | NULL | |
| idioma | text | YES | | NULL | |
| color | text | YES | | NULL | |
| duracion | text | YES | | NULL | |
| foto | text | YES | | NULL | |
| misc | text | YES | | NULL | |
+-------------+---------+------+-----+---------+-------+
10 rows in set (0.00 sec)
mysql> select id_pelicula from pelicula;
+-------------+
| id_pelicula |
+-------------+
| 0 |
| 1 |
| 418281537 |
| 1025493379 |
| 1248064203 |
| 1483774584 |
| 1613500206 |
| 2147483647 |
+-------------+
8 rows in set (0.00 sec)
mysql> insert into pelicula(id_pelicula) values(8141382586);
ERROR 1062 (23000): Duplicate entry '2147483647' for key 1