Advertisement
Guest User

Untitled

a guest
Mar 16th, 2019
179
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.12 KB | None | 0 0
  1. 1:
  2. mysql> Insert Into Tracks Values(4,11,'Spring',150,1,0);
  3.  
  4. mysql> select tracks.* from tracks where tracks.titleID = 4;
  5. +---------+----------+-----------------------+---------------+------+---------+
  6. | TitleID | TrackNum | TrackTitle | LengthSeconds | MP3 | RealAud |
  7. +---------+----------+-----------------------+---------------+------+---------+
  8. | 4 | 1 | Bob's Dream | 185 | 1 | 1 |
  9. | 4 | 2 | My Wizard | 233 | 1 | 1 |
  10. | 4 | 3 | Third's Folly | 352 | 1 | 1 |
  11. | 4 | 4 | Leather | 185 | 1 | 1 |
  12. | 4 | 5 | Hot Cars Cool Nights | 192 | 1 | 1 |
  13. | 4 | 6 | Music in You | 204 | 1 | 1 |
  14. | 4 | 7 | Don't Care About Time | 221 | 1 | 1 |
  15. | 4 | 8 | Kiss | 218 | 1 | 1 |
  16. | 4 | 9 | Pizza Box | 183 | 1 | 1 |
  17. | 4 | 10 | Goodbye | 240 | 1 | 1 |
  18. | 4 | 11 | Spring | 150 | 1 | 0 |
  19. +---------+----------+-----------------------+---------------+------+---------+
  20. 11 rows in set (0.00 sec)
  21.  
  22. 2:
  23. mysql> CREATE TABLE Members2 (
  24. -> MemberID int ,
  25. -> FirstName varchar (25) NULL ,
  26. -> LastName varchar (25) NULL ,
  27. -> Address varchar (60) NULL ,
  28. -> City varchar (25) NULL ,
  29. -> Region varchar (15) NULL ,
  30. -> PostalCode varchar (10) NULL ,
  31. -> Country varchar (20) NULL ,
  32. -> HomePhone varchar (16) NULL ,
  33. -> WorkPhone varchar (16) NULL ,
  34. -> EMail varchar (40) NULL ,
  35. -> Gender char (1) NULL ,
  36. -> Birthday date NULL ,
  37. -> SalesID smallint NULL
  38. -> );
  39. Query OK, 0 rows affected (0.04 sec)
  40.  
  41. mysql> describe members2;
  42. +------------+-------------+------+-----+---------+-------+
  43. | Field | Type | Null | Key | Default | Extra |
  44. +------------+-------------+------+-----+---------+-------+
  45. | MemberID | int(11) | YES | | NULL | |
  46. | FirstName | varchar(25) | YES | | NULL | |
  47. | LastName | varchar(25) | YES | | NULL | |
  48. | Address | varchar(60) | YES | | NULL | |
  49. | City | varchar(25) | YES | | NULL | |
  50. | Region | varchar(15) | YES | | NULL | |
  51. | PostalCode | varchar(10) | YES | | NULL | |
  52. | Country | varchar(20) | YES | | NULL | |
  53. | HomePhone | varchar(16) | YES | | NULL | |
  54. | WorkPhone | varchar(16) | YES | | NULL | |
  55. | EMail | varchar(40) | YES | | NULL | |
  56. | Gender | char(1) | YES | | NULL | |
  57. | Birthday | date | YES | | NULL | |
  58. | SalesID | smallint(6) | YES | | NULL | |
  59. +------------+-------------+------+-----+---------+-------+
  60. 14 rows in set (0.01 sec)
  61.  
  62. 3:
  63. mysql> select * from members2;
  64. +----------+-----------+-----------+----------------------+--------------+--------+------------+---------+------------+------------+------------------------+--------+------------+---------+
  65. | MemberID | FirstName | LastName | Address | City | Region | PostalCode | Country | HomePhone | WorkPhone | EMail | Gender | Birthday | SalesID |
  66. +----------+-----------+-----------+----------------------+--------------+--------+------------+---------+------------+------------+------------------------+--------+------------+---------+
  67. | 10 | Roberto | Alvarez | Rt 1 | Anderson | IN | 46019 | USA | 7651552983 | 7651628837 | ral@mightyhostl.com | M | 1968-01-18 | 2 |
  68. | 31 | Jose | MacArthur | 51444 Vine | Santa Rosa | CA | 99999 | USA | 6331289393 | NULL | jmac@dowop.com | M | 1978-06-24 | 1 |
  69. | 13 | Mary | Chrisman | 1772 East 117th | Fishers | IN | 46123 | USA | 3171820387 | NULL | mjc17@daviscorp.com | F | 1973-03-01 | 1 |
  70. | 15 | Warren | Boyer | 167 Alamo Dr | Alverez | TX | 75601 | USA | 8221722883 | NULL | wbman@uptime.net | M | 1969-04-19 | 2 |
  71. | 32 | Doug | Finney | 2020 Dubois | Savannah | GA | 30003 | USA | 9821222929 | NULL | fennyd@bitspeed.com | M | 1963-08-04 | 3 |
  72. | 19 | Terry | Irving | 18a 7th St | Tybee Island | GA | 30004 | USA | 5411252093 | NULL | NULL | M | 1959-06-22 | 3 |
  73. | 21 | Michelle | Henderson | 201 Bonaventure | Savannah | GA | 30005 | USA | 8221928273 | NULL | NULL | F | 1964-03-15 | 2 |
  74. | 34 | William | Morrow | PO Box 1882 | New Rochelle | NY | 10014 | USA | 9981722928 | NULL | wmorrow@wmorrow.com | M | 1965-03-17 | 2 |
  75. | 29 | Frank | Payne | 5412 Clinton | New Rochelle | NY | 10014 | USA | 9981737464 | NULL | NULL | M | 1960-01-17 | 1 |
  76. | 35 | Aiden | Franks | 167 East 38th | Alverez | TX | 75601 | USA | 8321729283 | 8321723833 | kosmo@ispl.com | M | 1983-09-02 | 2 |
  77. | 3 | Bryce | Sanders | PO Box 1292 | Peterson | NC | 27104 | USA | 6441824283 | NULL | bs@cookery.com | M | 1966-06-11 | 2 |
  78. | 14 | Carol | Wanner | 787 Airport Rd | Alverez | TX | 75601 | USA | 6831223944 | NULL | NULL | F | 1978-11-08 | 3 |
  79. | 33 | Brian | Ranier | 23 Gregory Lane | London | ONT | M6Y 2Y7 | Canada | 6231842933 | NULL | NULL | M | 1957-10-19 | 3 |
  80. | 7 | Marcellin | Lambert | 142 Sample Rd | Alexandria | VA | 20102 | USA | 8331929302 | NULL | mlambert@corkscrew.com | M | 1959-11-14 | 3 |
  81. | 8 | Caroline | Kale | 1515 Stone Church Rd | Allen | VA | 20321 | USA | 7321223742 | NULL | NULL | F | 1956-05-30 | 3 |
  82. | 9 | Kerry | Fernandez | 15 Midway | Lynchberg | VA | 21223 | USA | 2211229384 | 2211223939 | NULL | M | 1962-01-16 | 1 |
  83. | 26 | Tony | Wong | 115 Maple St | McKensie | ONT | M8H 3T1 | Canada | 3311692832 | 3311692822 | twong@tamilla.org | M | 1955-11-01 | 2 |
  84. | 18 | Bonnie | Taft | RR4 | Alamaba | VT | 05303 | USA | 3721223292 | NULL | taffygirl@signon.com | F | 1960-09-21 | 1 |
  85. | 20 | Louis | Holiday | 15 Davis Ct | Clinton | IL | 63882 | USA | 1451223838 | NULL | NULL | M | 1969-07-27 | 2 |
  86. | 22 | Bobby | Crum | RR2 | Pine | VT | 05412 | USA | 1831828211 | NULL | NULL | M | 1965-06-10 | 3 |
  87. | 28 | Vic | Cleaver | 100 Maple | Reston | VT | 05544 | USA | 8111839292 | NULL | NULL | M | 1957-02-10 | 2 |
  88. | 30 | Roberto | Goe | 14 Gray Rd | Columbus | OH | 48110 | USA | 2771123943 | NULL | NULL | M | 1967-09-12 | 1 |
  89. | 36 | Davis | Goodman | 2020 Country Rd | Columbus | OH | 48318 | USA | 2771152882 | 2771128833 | goody@irvingnet.com | M | 1980-10-27 | 2 |
  90. +----------+-----------+-----------+----------------------+--------------+--------+------------+---------+------------+------------+------------------------+--------+------------+---------+
  91. 23 rows in set (0.00 sec)
  92.  
  93. 4:
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement