MySQL 5.5

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE members (
id int(40) NOT NULL auto_increment,
name char(20) COLLATE utf8_unicode_ci NOT NULL,
username char(20) COLLATE utf8_unicode_ci NOT NULL,
password char(20) COLLATE utf8_unicode_ci NOT NULL,
gender char(1) COLLATE utf8_unicode_ci NOT NULL,
birthday DATE NOT NULL,
email varchar(50) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO members (name, username, password, gender, birthday, email) VALUES
('Sam', 'member1', 'member1', 'F', '2000-01-01', 'sam@gmail.com'),
('Kevin', 'member2', 'member2', 'M', '2000-01-02', 'kevin@gmail.com'),
('Winnie', 'member3', 'member3', 'M', '2000-01-03', 'winnie@gmail.com'),
('Mark', 'member4', 'member4', 'F', '2000-01-04', 'mark@gmail.com'),
('Suzuki', 'member5', 'member5', 'F', '2000-01-05', 'suzuki@gmail.com');
Select *
from members 
order by id


id
name
username
password
gender
birthday
email


1
Sam
member1
member1
F
2000-01-01
sam@gmail.com

2
Kevin
member2
member2
M
2000-01-02
kevin@gmail.com

3
Winnie
member3
member3
M
2000-01-03
winnie@gmail.com

4
Mark
member4
member4
F
2000-01-04
mark@gmail.com

5
Suzuki
member5
member5
F
2000-01-05
suzuki@gmail.com

id	name	username	password	gender	birthday	email
1	Sam	member1	member1	F	2000-01-01	sam@gmail.com
2	Kevin	member2	member2	M	2000-01-02	kevin@gmail.com
3	Winnie	member3	member3	M	2000-01-03	winnie@gmail.com
4	Mark	member4	member4	F	2000-01-04	mark@gmail.com
5	Suzuki	member5	member5	F	2000-01-05	suzuki@gmail.com