Skip to content

Instantly share code, notes, and snippets.

@scottjbarr

scottjbarr/gist:1277173

Created October 11, 2011 03:09
Show Gist options
  • Save scottjbarr/1277173 to your computer and use it in GitHub Desktop.
Save scottjbarr/1277173 to your computer and use it in GitHub Desktop.
Download ZIP
Selecting record in mysql with overflowing integer
Raw
gistfile1.sql
mysql> SHOW VARIABLES like "version";
+---------------+--------+
| Variable_name | Value |
+---------------+--------+
| version | 5.5.15 |
+---------------+--------+
1 row in set (0.00 sec)
mysql> select * from users where id in (29391170719191043234654437481914368);
Empty set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment