TheBulgarianWolf

Create, Modify and Print SQL Table

Nov 24th, 2020
639
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE PERSONS(
  2.     PersonID int,
  3.     FirstName varchar(40),
  4.     LastName varchar(40),
  5.     Address varchar(80),
  6.     City varchar(40)
  7. );
  8.  
  9. INSERT INTO PERSONS(PersonID,FirstName,LastName,Address,City)
  10. VALUES(1,'George','Michael','Brooklyn Road 151','New York');
  11.  
  12. INSERT INTO PERSONS(PersonID,FirstName,LastName,Address,City)
  13. VALUES(2,'Jim','Timberland','Lyule Road 18','Haskovo');
  14.  
  15. INSERT INTO PERSONS(PersonID,FirstName,LastName,Address,City)
  16. VALUES(3,'Anna','Smith','Tsar Petur 64','Moskow');
  17.  
  18. SELECT * FROM PERSONS
  19.  
RAW Paste Data