Advertisement
Guest User

Untitled

a guest
Mar 23rd, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. ## SQL
  2. **CREATE**
  3. ```SQL
  4. CREATE TABLE users (
  5. id MEDIUMINT NOT NULL AUTO_INCREMENT,
  6. name Varchar(30),
  7. age Number,
  8. alias Varchar(20),
  9. PRIMARY KEY (id)
  10. )
  11. ```
  12. **ALTER**
  13. ```SQL
  14. ALTER TABLE users ADD join_date DATETIME
  15. ALTER TABLE users DROP COLUMN join_date
  16. ```
  17. ## NoSQL with MongoDB
  18. **CREATE**
  19. ```BSON
  20. db.users.insertOne(
  21. {
  22. name : "Marcela Sena",
  23. age : 29,
  24. alias : "MarceStarlet"
  25. }
  26. )
  27. ```
  28. **ALTER**
  29. ```BSON
  30. db.users.updateMany(
  31. { },
  32. { $set: { join_date: new Date() } }
  33. )
  34. db.users.updateMany(
  35. { },
  36. { $unset: { "join_date": "" } }
  37. )
  38. ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement