-- ✅ Create Database CREATE DATABASE IF NOT EXISTS testdb; USE testdb;

-- ✅ Create Customers Table CREATE TABLE IF NOT EXISTS customers ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100) NOT NULL, phone VARCHAR(20) NOT NULL, city VARCHAR(50) NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); DROP TABLE customers; ; -- ✅ Insert Demo Data INSERT INTO customers (name, phone, city) VALUES ('Ali Khan', '03001234567', 'Karachi'),

('Nawaz', '021223343', 'islamabad');

SELECT * FROM customers; DELETE FROM customers; ALTER TABLE customers ADD UNIQUE (phone);