mfernandez

MySQL bad behavior

Aug 16th, 2011
155
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.61 KB | None | 0 0
  1. mysql> create table test (texto varchar(3));
  2. Query OK, 0 rows affected (0.08 sec)
  3.  
  4. mysql> describe test
  5.     -> ;
  6. +-------+------------+------+-----+---------+-------+
  7. | Field | Type       | Null | Key | Default | Extra |
  8. +-------+------------+------+-----+---------+-------+
  9. | texto | varchar(3) | YES  |     | NULL    |       |
  10. +-------+------------+------+-----+---------+-------+
  11. 1 row in set (0.00 sec)
  12.  
  13. mysql> insert into test values ('1234');
  14. Query OK, 1 row affected, 1 warning (0.00 sec)
  15.  
  16. mysql> select * from test;
  17. +-------+
  18. | texto |
  19. +-------+
  20. | 123   |
  21. +-------+
  22. 1 row in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment