CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
email VARCHAR(100) UNIQUE NOT NULL,
gender ENUM('Male', 'Female', 'Other'),
date_of_birth DATE,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
SELECT * FROM users;
INSERT INTO users ('name', 'email','date_of_birth') VALUES
('Ahmed Ali', 'ahmed.ali@example.com', 'Male', '1992-05-14'),
('Fatima Khan', 'fatima.khan@example.com', 'Female', '1995-08-21'),
('Muhammad Usman', 'usman.muhammad@example.com', 'Male', '1989-12-09'),
('Ayesha Siddiqui', 'ayesha.siddiqui@example.com', 'Female', '1994-03-17'),
('Hamza Qureshi', 'hamza.qureshi@example.com', 'Male', '1990-07-02'),
('Zainab Noor', 'zainab.noor@example.com', 'Female', '1996-11-26'),
('Bilal Saeed', 'bilal.saeed@example.com', 'Male', '1993-06-05'),
('Hafsa Jameel', 'hafsa.jameel@example.com', 'Female', '1991-09-14'),
('Omar Farooq', 'omar.farooq@example.com', 'Male', '1988-04-28'),
('Maryam Raza', 'maryam.raza@example.com', 'Female', '1997-10-11'),
('Imran Tariq', 'imran.tariq@example.com', 'Male', '1990-01-18'),
('Laiba Haroon', 'laiba.haroon@example.com', 'Female', '1995-05-23'),
('Yusuf Kamal', 'yusuf.kamal@example.com', 'Male', '1987-02-03'),
('Noor Fatima', 'noor.fatima@example.com', 'Female', '1998-07-27'),
('Samiullah Zafar', 'samiullah.zafar@example.com', 'Male', '1992-03-10'),
('Hira Aslam', 'hira.aslam@example.com', 'Female', '1996-12-19'),
('Tariq Nadeem', 'tariq.nadeem@example.com', 'Male', '1989-09-01'),
('Maha Irfan', 'maha.irfan@example.com', 'Female', '1994-11-05'),
('Adnan Bashir', 'adnan.bashir@example.com', 'Male', '1991-06-15'),
('Aleena Shafi', 'aleena.shafi@example.com', 'Female', '1993-08-29'),
('Rizwan Haider', 'rizwan.haider@example.com', 'Male', '1988-10-30'),
('Amna Yousaf', 'amna.yousaf@example.com', 'Female', '1997-01-12'),
('Kashif Mehmood', 'kashif.mehmood@example.com', 'Male', '1990-03-08'),
('Sana Parveen', 'sana.parveen@example.com', 'Female', '1995-06-17'),
('Noman Arif', 'noman.arif@example.com', 'Male', '1992-04-03'),
('Iqra Shahid', 'iqra.shahid@example.com', 'Female', '1996-09-21'),
('Waqar Ahmed', 'waqar.ahmed@example.com', 'Male', '1989-12-25'),
('Zoya Khalid', 'zoya.khalid@example.com', 'Female', '1993-07-09'),
('Farhan Nazir', 'farhan.nazir@example.com', 'Male', '1991-05-30'),
('Rubina Anwar', 'rubina.anwar@example.com', 'Female', '1994-02-16');