· 8 years ago · Jun 19, 2018, 04:28 PM
1id firstname gender
21 Aaron m
32 Adam m
43 Alan m
5etc...
6
7SELECT id, firstname FROM firstname WHERE id = round(1 + (rand() * 199));
8
9id firstname
1043 Jason
11
12-- First Name --
13drop table if exists firstname;
14
15 CREATE TABLE firstname (
16 id INT NOT NULL,
17 firstname VARCHAR(20) NOT NULL,
18 gender VARCHAR(1) NOT NULL,
19 PRIMARY KEY (id),
20 UNIQUE (firstname)
21 );
22
23 INSERT INTO firstname
24 (id,firstname,gender)
25 VALUES
26 (1,"Aaron","m"),
27(2,"Adam","m"),
28(3,"Alan","m"),
29(4,"Albert","m"),
30(5,"Alexander","m"),
31(6,"Andrew","m"),
32(7,"Anthony","m"),
33(8,"Arthur","m"),
34(9,"Austin","m"),
35(10,"Benjamin","m"),
36(11,"Billy","m"),
37(12,"Bobby","m"),
38(13,"Brandon","m"),
39(14,"Brian","m"),
40(15,"Bruce","m"),
41(16,"Bryan","m"),
42(17,"Carl","m"),
43(18,"Charles","m"),
44(19,"Christian","m"),
45(20,"Christopher","m");