Advertisement
Guest User

Untitled

a guest
Jun 25th, 2017
501
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.60 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `country` (
  2.   `country_id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `country_code` varchar(2) COLLATE ascii_bin NOT NULL COMMENT 'ISO 3166 Country Code',
  4.   PRIMARY KEY (`country_id`),
  5.   KEY `country_code` (`country_code`)
  6. ) ENGINE=MyISAM  DEFAULT CHARSET=ascii COLLATE=ascii_bin;
  7.  
  8. /*
  9. OUTPUT:
  10.  
  11. mysql> SELECT * FROM country LIMIT 0,3;
  12. +------------+--------------+
  13. | country_id | country_code |
  14. +------------+--------------+
  15. |          1 | An           |
  16. |          2 | Un           |
  17. |          3 | Af           |
  18. +------------+--------------+
  19. 3 rows in set (0.00 sec)
  20.  
  21.  
  22. */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement