· 7 years ago · Nov 18, 2018, 10:10 PM
1DROP DATABASE IF EXISTS tmptmptmp;
2CREATE DATABASE tmptmptmp;
3
4USE tmptmptmp;
5
6CREATE TABLE a (
7 id INT(11) PRIMARY KEY AUTO_INCREMENT,
8 char_stuff varchar(255) NOT NULL,
9 int_stuff int(32) NOT NULL
10);
11
12
13INSERT INTO a (char_stuff, int_stuff) VALUES ('5ycWg3NTqzlNg9qAJ9imxK76Oq9a1MpN', 5);
14
15SELECT * FROM a WHERE int_stuff = '5ycWg3NTqzlNg9qAJ9imxK76Oq9a1MpN';
16SHOW WARNINGS;