zhelong19830726的博客

SQL Schema > Create table Person (PersonId int, FirstName varchar(255), LastName varchar(255)) Create table Address (AddressId int, PersonId int, City varchar(255), State varchar(255)) Truncate t...

SQL Schema > Create table If Not Exists Employee (Id int, Salary int) Truncate table Employee insert into Employee (Id, Salary) values ('1', '100') insert into Employee (Id, Salary) values ('2', ...

SQL Schema > Create table If Not Exists Scores (Id int, Score DECIMAL(3,2)) Truncate table Scores insert into Scores (Id, Score) values ('1', '3.5') insert into Scores (Id, Score) values ('2', '3...

SQL Schema > Create table If Not Exists Logs (Id int, Num int); Truncate table Logs; insert into Logs (Id, Num) values ('1', '1'); insert into Logs (Id, Num) values ('2', '1'); insert into Logs (...

SQL Schema > Create table If Not Exists Employee (Id int, Name varchar(255), Salary int, ManagerId int); Truncate table Employee; insert into Employee (Id, Name, Salary, ManagerId) values ('1', '...

SQL Schema > Create table If Not Exists Person (Id int, Email varchar(255)); Truncate table Person; insert into Person (Id, Email) values ('1', 'a@b.com'); insert into Person (Id, Email) values (...