Untitled
unknown
plain_text
a year ago
705 B
5
Indexable
CREATE TABLE customer ( cust_no Numeric(4), Lname VARCHAR(10), Fname VARCHAR(15), Address VARCHAR(20), city VARCHAR(50), states VARCHAR(10), pin VARCHAR(6), birth_date DATE ); INSERT INTO customer VALUES (1, 'samir', 'shrestha', '123 Main St', 'New York', 'NY', '10001', '1990-05-15'), (2, 'manjil', 'sharma', '456 Elm St', 'Los Angeles', 'CA', '90001', '1985-09-20'), (3, 'sumit', 'thokar', '789 Oak St', 'Chicago', 'IL', '60601', '1978-12-10'), (4, 'nischal', 'pandit', '101 Pine St', 'Houston', 'TX', '77001', '1995-03-25'), (5, 'kritim', 'bista', '202 Cedar St', 'Miami', 'FL', '33101', '1980-07-30') SELECT * FROM customer
Editor is loading...
Leave a Comment