Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- id firstname gender
- 1 Aaron m
- 2 Adam m
- 3 Alan m
- etc...
- SELECT id, firstname FROM firstname WHERE id = round(1 + (rand() * 199));
- id firstname
- 43 Jason
- -- First Name --
- drop table if exists firstname;
- CREATE TABLE firstname (
- id INT NOT NULL,
- firstname VARCHAR(20) NOT NULL,
- gender VARCHAR(1) NOT NULL,
- PRIMARY KEY (id),
- UNIQUE (firstname)
- );
- INSERT INTO firstname
- (id,firstname,gender)
- VALUES
- (1,"Aaron","m"),
- (2,"Adam","m"),
- (3,"Alan","m"),
- (4,"Albert","m"),
- (5,"Alexander","m"),
- (6,"Andrew","m"),
- (7,"Anthony","m"),
- (8,"Arthur","m"),
- (9,"Austin","m"),
- (10,"Benjamin","m"),
- (11,"Billy","m"),
- (12,"Bobby","m"),
- (13,"Brandon","m"),
- (14,"Brian","m"),
- (15,"Bruce","m"),
- (16,"Bryan","m"),
- (17,"Carl","m"),
- (18,"Charles","m"),
- (19,"Christian","m"),
- (20,"Christopher","m");
Add Comment
Please, Sign In to add comment