vencinachev

SimpleDB-school

Dec 14th, 2020
872
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE DATABASE school;
  2.  
  3. USE school;
  4.  
  5. CREATE TABLE users(
  6. UserID INT AUTO_INCREMENT PRIMARY KEY,
  7. FirstName VARCHAR(100),
  8. LastName VARCHAR(100),
  9. Username VARCHAR(50) NOT NULL,
  10. Pass VARCHAR(50) NOT NULL,
  11. Age INT
  12. );
  13.  
  14. INSERT INTO users (FirstName, LastName, Username, Pass, Age)
  15. VALUES ('Petkan', 'Kirilov', 'petkir', '1234', 28);
  16.  
  17. INSERT INTO users (FirstName, LastName, Username, Pass, Age)
  18. VALUES ('Ani', 'Vasileva', 'aniv', 'abcd', 17);
  19.  
  20. INSERT INTO users (FirstName, LastName, Username, Pass, Age)
  21. VALUES ('Kiro', 'Ivanov', 'bakshisha123', 'supermen', 27);
  22.  
  23. SELECT * FROM users;
RAW Paste Data