Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `country` (
- `country_id` int(11) NOT NULL AUTO_INCREMENT,
- `country_code` varchar(2) COLLATE ascii_bin NOT NULL COMMENT 'ISO 3166 Country Code',
- PRIMARY KEY (`country_id`),
- KEY `country_code` (`country_code`)
- ) ENGINE=MyISAM DEFAULT CHARSET=ascii COLLATE=ascii_bin;
- /*
- OUTPUT:
- mysql> SELECT * FROM country LIMIT 0,3;
- +------------+--------------+
- | country_id | country_code |
- +------------+--------------+
- | 1 | An |
- | 2 | Un |
- | 3 | Af |
- +------------+--------------+
- 3 rows in set (0.00 sec)
- */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement