Advertisement
Guest User

Untitled

a guest
Oct 19th, 2019
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.60 KB | None | 0 0
  1. mysql> show tables;
  2. +-------------------------+
  3. | Tables_in_wild_db_quest |
  4. +-------------------------+
  5. | school |
  6. | wizard |
  7. +-------------------------+
  8. 2 rows in set (0.00 sec)
  9.  
  10. mysql> DESCRIBE wizard;
  11. +-------------+--------------+------+-----+---------+----------------+
  12. | Field | Type | Null | Key | Default | Extra |
  13. +-------------+--------------+------+-----+---------+----------------+
  14. | id | int(11) | NO | PRI | NULL | auto_increment |
  15. | firstname | varchar(100) | NO | | NULL | |
  16. | lastname | varchar(100) | NO | | NULL | |
  17. | birthday | date | NO | | NULL | |
  18. | birth_place | varchar(255) | YES | | NULL | |
  19. | biography | text | YES | | NULL | |
  20. | is_muggle | tinyint(1) | NO | | NULL | |
  21. +-------------+--------------+------+-----+---------+----------------+
  22. 7 rows in set (0.00 sec)
  23.  
  24. mysql> DESCRIBE school;
  25. +----------+--------------+------+-----+---------+----------------+
  26. | Field | Type | Null | Key | Default | Extra |
  27. +----------+--------------+------+-----+---------+----------------+
  28. | id | int(11) | NO | PRI | NULL | auto_increment |
  29. | name | varchar(100) | NO | | NULL | |
  30. | capacity | int(11) | YES | | NULL | |
  31. | country | varchar(255) | NO | | NULL | |
  32. +----------+--------------+------+-----+---------+----------------+
  33. 4 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement