Assignment Solution-Using Constraint
CREATE TABLE customers
( customer_id INT,
first_name VARCHAR(255) NOT NULL,
last_name VARCHAR(255) NOT NULL,
email_address VARCHAR(255) NOT NULL,
number_of_complaints INT
);
2 answers ( 0 marked as helpful)
Hi Tamizhazhagan!
Thanks for reaching out.
Thanks for sharing this piece of information with the Community!
Best,
Tsvetelin
create table Customers
(
customer_id int not null primary key auto_increment,
first_name varchar(255) not null,
last_name varchar(255) not null,
email_address varchar(255) not null,
number_of_complaints int
);