MariaDB [bernd]> desc big;
|
+-------+------------------+------+-----+---------+----------------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------+------------------+------+-----+---------+----------------+
|
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
|
| bi | bigint(11) | YES | | NULL | |
|
| vc | varchar(20) | YES | | NULL | |
|
+-------+------------------+------+-----+---------+----------------+
|
3 rows in set (0.01 sec)
|
|
MariaDB [bernd]> select * from big;
|
+----+--------------------+--------------------+
|
| id | bi | vc |
|
+----+--------------------+--------------------+
|
| 1 | 137226000008073943 | 137226000008073943 |
|
| 2 | 137226000008073929 | 137226000008073929 |
|
+----+--------------------+--------------------+
|
2 rows in set (0.05 sec)
|
|
MariaDB [bernd]> select * from big where vc = 137226000008073943;
|
+----+--------------------+--------------------+
|
| id | bi | vc |
|
+----+--------------------+--------------------+
|
| 1 | 137226000008073943 | 137226000008073943 |
|
| 2 | 137226000008073929 | 137226000008073929 |
|
+----+--------------------+--------------------+
|
2 rows in set (0.00 sec)
|
|
MariaDB [bernd]>
|