SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE Provider ( ProviderID char(6) not null, FirstName varchar(24) not null, LastName varchar(64) not null, PRIMARY KEY (ProviderID) ); INSERT INTO Provider ( ProviderID, LastName, FirstName) VALUES ( '123456', 'Spock', 'Ben'); ALTER TABLE Provider ADD COLUMN HireDate date; UPDATE Provider SET FirstName = 'Ben' WHERE ProviderID='123456';
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear