Advertisement
rootUser

Project 0 - insert value - (SQL)

Oct 23rd, 2016
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.85 KB | None | 0 0
  1. DROP TABLE IF EXISTS user0;
  2.  
  3. DROP TABLE IF EXISTS data0;
  4.  
  5. CREATE TABLE user0
  6. (
  7. Dname VARCHAR(100) UNIQUE NOT NULL,
  8. Dpassword VARCHAR(100) NOT NULL
  9. );
  10.  
  11. CREATE TABLE data0
  12. (
  13. Dbrand VARCHAR(100) NOT NULL,
  14. Dmodel VARCHAR(100) NOT NULL,
  15. Ddescription VARCHAR(10000) NOT NULL,
  16. Dprice DECIMAL(20,4) UNSIGNED NOT NULL
  17. );
  18.  
  19. INSERT INTO user0(Dname,Dpassword)
  20. VALUES ("al","al");
  21. INSERT INTO user0(Dname,Dpassword)
  22. VALUES ("za",SHA1("al"));
  23.  
  24. INSERT INTO data0(Dbrand,Dmodel,Ddescription,Dprice)
  25. VALUES("a0","b0","c0",20.0);
  26. INSERT INTO data0(Dbrand,Dmodel,Ddescription,Dprice)
  27. VALUES("a1","b1","c1",21.1);
  28. INSERT INTO data0(Dbrand,Dmodel,Ddescription,Dprice)
  29. VALUES("a2","b2","c2",22.2);
  30. INSERT INTO data0(Dbrand,Dmodel,Ddescription,Dprice)
  31. VALUES("a3","b3","c3",23.3);
  32. INSERT INTO data0(Dbrand,Dmodel,Ddescription,Dprice)
  33. VALUES("a4","b4","c4",24.4);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement