Advertisement
Guest User

Untitled

a guest
Jan 21st, 2020
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.48 KB | None | 0 0
  1.  
  2.  
  3. INSERT INTO Team (
  4. team_id,
  5. conference,
  6. name,
  7. city
  8. )
  9.  
  10. VALUES
  11. (
  12. '15',
  13. 'Western',
  14. 'Los Angeles Lakers',
  15. 'Los Angeles'),
  16.  
  17. ('16',
  18. 'Western',
  19. 'Denver Nuggets',
  20. 'Denver'
  21. ),
  22. ('17',
  23. 'Western',
  24. 'Utah Jazz',
  25. 'Utah'
  26. ),
  27. ('18',
  28. 'Western',
  29. 'Los Angeles Clippers',
  30. 'Los Angeles'
  31. ),
  32.  
  33. ('19',
  34. 'Western',
  35. 'Dallas Mavericks',
  36. 'Dallas'
  37. ),
  38. ('20',
  39. 'Western',
  40. 'Houston Rockets',
  41. 'Houston'
  42. ),
  43. ('21',
  44. 'Western',
  45. 'Oklahoma City Thunders',
  46. 'Oklahoma City'
  47. ),
  48. ('22',
  49. 'Western',
  50. 'Memphis Grizzlies',
  51. 'Memphis'
  52. ),
  53. ('23',
  54. 'Western',
  55. 'San Antonio Spurs',
  56. 'San Antonio'
  57. ),
  58. ('24',
  59. 'Western',
  60. 'Portland Trail Blazers',
  61. 'Portland'
  62. ),
  63. ('25',
  64. 'Western',
  65. 'Charlotte Hornets',
  66. 'Charlotte'
  67. ),
  68. ('26',
  69. 'Western',
  70. 'Phoenix Suns',
  71. 'Phoenix'
  72. ),
  73. ('27',
  74. 'Western',
  75. 'New Orleans Pelicans',
  76. 'New Orleans'
  77. ),
  78. ('28',
  79. 'Western',
  80. 'Minnesota Timberwolves',
  81. 'Minnesota'),
  82.  
  83. ('29',
  84. 'Western',
  85. 'Sacramento Kings',
  86. 'Sacramento'),
  87.  
  88. ('30',
  89. 'Western',
  90. 'Golden State Warriors',
  91. 'Golden State');
  92.  
  93.  
  94. Useful commands:
  95.  
  96. ALTER TABLE Coach
  97. DROP COLUMN bdate;
  98.  
  99. ALTER TABLE Customers
  100. ADD Email varchar(255);
  101.  
  102.  
  103. Coach : 30
  104. Company : 30
  105. Arena : 30
  106. Teams : 30
  107. Game :
  108. Ticket :
  109. Customer :
  110. Player :
  111. NBAChampion :
  112. Artist :
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement