Quit or search personnel info(TABLE PERSONNEL_INFO)
Notes
Searching is case sensitive
Table ADMIN_INFO
CREATE TABLE ADMIN_INFO (
id int PRIMARY KEY,
AdminName varchar(255) NOT NULL UNIQUE ,
AdminPassword varchar(255) NOT NULL,
CONSTRAINT Name_Length CHECK(LENGTH(AdminName) >= 8 AND LENGTH(AdminName) <= 20),
CONSTRAINT Password_Length CHECK(LENGTH(AdminPassword) >= 6 AND LENGTH(AdminPassword) <= 15)
);
Table PERSONNEL_INFO
CREATE TABLE personnel_info (
id int PRIMARY KEY,
name varchar(255) NOT NULL,
title varchar(255) NOT NULL,
skill varchar(255),
address varchar(255) UNIQUE,
phone varchar(255),
salary varchar(255)
);