· 9 years ago · Oct 06, 2016, 03:00 AM
1id Name
2 000010 A
3 000011 B
4 000012 C
5 000015 D
6 000016 E
7
8CREATE TABLE IF NOT EXISTS `TABLE`(
9 id` int(6) zerofill unsigned NOT NULL AUTO_INCREMENT,
10 `Name` varchar(10) NOT NULL,
11 PRIMARY KEY (`id`)
12 )
13 ENGINE=InnoDB;
14
15SELECT
16 id,Name
17FROM
18 TABLE
19WHERE
20 id="10"
21
22SELECT
23 id,Name
24FROM
25 TABLE
26WHERE
27 id="17"