Advertisement
rootUser

project 1 - display value (sql)

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