thufir

Untitled

Jun 24th, 2014
264
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.48 KB | None | 0 0
  1. mysql>
  2. mysql> use vehicles;
  3. Reading table information for completion of table and column names
  4. You can turn off this feature to get a quicker startup with -A
  5.  
  6. Database changed
  7. mysql>
  8. mysql> show tables;
  9. +--------------------+
  10. | Tables_in_vehicles |
  11. +--------------------+
  12. | vehicles |
  13. +--------------------+
  14. 1 row in set (0.00 sec)
  15.  
  16. mysql>
  17. mysql> describe vehicles;
  18. +-------+-------------+------+-----+---------+-------+
  19. | Field | Type | Null | Key | Default | Extra |
  20. +-------+-------------+------+-----+---------+-------+
  21. | make | varchar(45) | YES | | NULL | |
  22. | model | varchar(45) | YES | | NULL | |
  23. | year | int(11) | YES | | NULL | |
  24. | phone | varchar(45) | YES | | NULL | |
  25. | title | varchar(45) | YES | | NULL | |
  26. +-------+-------------+------+-----+---------+-------+
  27. 5 rows in set (0.00 sec)
  28.  
  29. mysql>
  30. mysql> describe vehicles.vehicles;
  31. +-------+-------------+------+-----+---------+-------+
  32. | Field | Type | Null | Key | Default | Extra |
  33. +-------+-------------+------+-----+---------+-------+
  34. | make | varchar(45) | YES | | NULL | |
  35. | model | varchar(45) | YES | | NULL | |
  36. | year | int(11) | YES | | NULL | |
  37. | phone | varchar(45) | YES | | NULL | |
  38. | title | varchar(45) | YES | | NULL | |
  39. +-------+-------------+------+-----+---------+-------+
  40. 5 rows in set (0.00 sec)
  41.  
  42. mysql>
Advertisement
Add Comment
Please, Sign In to add comment