Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2016
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.39 KB | None | 0 0
  1. id int(6) auto_increment,
  2. name varchar(40) not null,
  3. pseudo varchar(40) not null,
  4. email varchar(40) not null,
  5. password varchar(40) not null,
  6. plan varchar(40) not null,
  7. date DATETIME DEFAULT CURRENT_TIMESTAMP,
  8. points int(6) not null,
  9. primary key(id,name,pseudo,email,password,date,points,plan)
  10.  
  11. insert into users(NULL,"name","pseudo","email@email.com","Pass1919",NULL,
  12. "100");
  13.  
  14. insert into users(name,pseudo,email,password,paln,date,poits)
  15. values("name","pseudo","email@email.com","Pass1919",'', NULL, "100");
  16.  
  17. insert into users(name,pseudo,email,password,paln,poits)
  18. values("name","pseudo","email@email.com","Pass1919",'', "100");
  19.  
  20. insert into users(name,pseudo,email,password,paln,date,poits)
  21. values("name","pseudo","email@email.com","Pass1919",NULL, "100");
  22.  
  23. insert into users values(NULL,"name","pseudo","email@email.com","Pass1919",NULL,
  24. "100");
  25.  
  26. insert into users values("name","pseudo","email@email.com","Pass1919",NULL, "100");
  27.  
  28. INSERT INTO users(
  29. `name`,
  30. `pseudo`,
  31. `email`,
  32. `password`,
  33. `plan`,
  34. `points`
  35. )
  36. VALUES (
  37. NULL,
  38. 'name',
  39. 'pseudo',
  40. 'email@email.com',
  41. 'Pass1919',
  42. NULL,
  43. '100');
  44.  
  45. insert into users(name,pseudo,email,password,plan,points) values ('name','pseudo','email@email.com','Pass1919','','100');
  46.  
  47. insert into users(name,pseudo,email,password,plan,date,points)
  48. values("name","pseudo","joe.bloggs@mydomain.com","S3CuR3", "PLAN", "2014-06-26", 100);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement