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 ); INSERT INTO users (name, email, gender, 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'); SELECT * FROM users; --ADDRESSES TABLE --------- CREATE TABLE addresses( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT, street VARCHAR(255), city VARCHAR(150), state VARCHAR(150), pincode VARCHAR(10), CONSTRAINT fk_user FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE ); INSERT INTO addresses (user_id , street, city, state, pincode) vALUES (1, '123 Main Street', 'Lahore', 'Punjab', '54000'), (2, '45-A Model Town', 'Karachi', 'Sindh', '74000'), (3, '789 Garden Road', 'Islamabad', 'Capital Territory', '44000'), (4, '11 Shalimar Block', 'Rawalpindi', 'Punjab', '46000'), (5, '22 Canal View', 'Faisalabad', 'Punjab', '38000'), (6, 'Plot 17, Gulshan-e-Iqbal', 'Karachi', 'Sindh', '75300'), (7, 'House #34, DHA Phase 3', 'Lahore', 'Punjab', '54792'), (8, '88 Satellite Town', 'Quetta', 'Balochistan', '87300'), (9, 'House 102, Peshawar Road', 'Peshawar', 'KPK', '25000'), (10, 'Street 5, G-11', 'Islamabad', 'Capital Territory', '44000'), (11, 'Block C, North Nazimabad', 'Karachi', 'Sindh', '74700'), (12, 'House 77, Iqbal Town', 'Multan', 'Punjab', '60000'), (13, '96 Civic Centre', 'Sialkot', 'Punjab', '51040'), (14, 'Flat 2B, Gulberg Greens', 'Lahore', 'Punjab', '54660'), (15, 'Plot 34, Phase 6', 'Karachi', 'Sindh', '75100'), (16, '15 Jinnah Avenue', 'Bahawalpur', 'Punjab', '63100'), (17, 'Block 7, Gulshan-e-Maymar', 'Karachi', 'Sindh', '75340'), (18, 'Street 4, H-8', 'Islamabad', 'Capital Territory', '44090'), (19, 'Plot 10, Charsadda Road', 'Peshawar', 'KPK', '25050'), (20, 'House #11, Blue Area', 'Islamabad', 'Capital Territory', '44000'), (21, '33 Ravi Road', 'Lahore', 'Punjab', '54010'), (22, 'Block A, Satellite Town', 'Rawalpindi', 'Punjab', '46010'), (23, 'Street 11, Gulistan-e-Johar', 'Karachi', 'Sindh', '75290'), (24, 'House 88, Officers Colony', 'Faisalabad', 'Punjab', '38010'), (25, 'Flat 302, Mall Road', 'Murree', 'Punjab', '47150'), (26, '34 Fort Road', 'Hyderabad', 'Sindh', '71000'), (27, '22-A Hali Road', 'Sargodha', 'Punjab', '40100'), (28, 'Block E, University Town', 'Peshawar', 'KPK', '25120'), (29, 'House 45, G-9/1', 'Islamabad', 'Capital Territory', '44010'), (30, 'Street 10, Tariq Road', 'Karachi', 'Sindh', '75400'); SELECT users.name, addresses, city FROM users INNER JOIN addresses ON users.id = addresses.user_id; SELECT * FROM addresses;