id

The cell id (int), and the cell id_fb (varchar), in both cells should have been written the same thing, but written like this, why such a difference?

Structure: enter image description here

  • How is it recorded? - carapuz
  • insert into users (id, id_fb) values ​​("'. $ id.'", "'. $ id.'"); - Alexander Reizan

1 answer 1

By default, 11 characters are stored in int in MySQL, in varchar 255.

Documentation of numeric types in MySQL

  • but I put 255 there and there - Alexander Reizan
  • Are you sure what was put down? Show the table structure - Maxim Bogdanov
  • added screenshot - Alexander Reizan
  • Check the documentation link for maximum values ​​for types - Maxim Bogdanov
  • Try to store as numeric (255,0) - Maxim Bogdanov