Paste Search Dynamic
Recent pastes
Tables in wild db quest
  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          | 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          | NO   | PRI | null    | auto_increment |
  29. | name     | varchar(100) | NO   |     | null    |                |
  30. | capacity | int          | NO   |     | null    |                |
  31. | country  | varchar(255) | NO   |     | null    |                |
  32. +----------+--------------+------+-----+---------+----------------+
  33. 4 rows in set (0.00 sec)
  34.  
  35. mysql>
Parsed in 0.007 seconds