SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE Provider ( Prov_ID char(6) not null, FirstName varchar(24) not null, LastName varchar(64) not null, PRIMARY KEY (Prov_ID) ); INSERT INTO Provider ( Prov_ID, LastName, FirstName) VALUES ( '123456', 'Spock', 'Ben'); ALTER TABLE Provider ADD COLUMN HireDate date; UPDATE Provider SET FirstName = 'Ben' WHERE ProviderID='123456'; INSERT INTO Provider ( Prov_ID, Prov_LastName, Prov_FirstName, Prov_HireDate) VALUES ( '123457', 'Schweitzer', 'Albert', '1990-05-09' ) ; INSERT INTO Provider ( Prov_ID, Prov_LastName, Prov_FirstName, Prov_HireDate) VALUES ( '123458', 'Shepherd', 'Derek', '2005-03-27' ) ; INSERT INTO Provider ( Prov_ID, Prov_LastName, Prov_FirstName, Prov_HireDate) VALUES ( '123459', 'Sloan', 'Mark', '2005-03-27' ); INSERT INTO Provider ( Prov_ID, Prov_LastName, Prov_FirstName, Prov_HireDate) VALUES ( '123460', 'Thomas', 'Brett', '2020-01-15' );
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear