SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
INSERT INTO Customer (CustomerID, FirstName, LastName, PhoneNumber, Address) VALUES (1, 'Mohammed', 'Ahmed', '+923123456789', 'PAKISTAN, Lahore'), (2, 'Fatima', 'Khan', '+923987654321', 'PAKISTAN,Karachi'), (3, 'Ahmed', 'Ali', '+923111111111', 'PAKISTAN,Islamabad'); INSERT INTO Operator (OperatorID, FirstName, LastName, PhoneNumber, EmailAddress) VALUES (1, 'Sarah', 'Khan', '+923222222222', 'sarah.khan@example.com'), (2, 'Hamza', 'Ali', '+923333333333', 'hamza.ali@example.com'), (3, 'Ayesha', 'Javed', '+923444444444', 'ayesha.javed@example.com'); INSERT INTO Complaint (Comp_ID, Comp_Type, Comp_Date, Comp_Status) VALUES ('CMPT101', 'CB', '2022-12-29', 'Resolved'), ('CMPT102', 'CSB', '2022-12-29', 'Pending'), ('CMPT103', 'CSB', '2023-01-10', 'Pending');
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear