SQLize | PHPize | SQLtest

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');