bugged.be

"Think outside the [B0X]"
Icon

Countries db script

Script for creating database with countries.
1. Create table:

CREATE TABLE `development`.`countries` (
   `countryId` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
   `name` VARCHAR(100) NOT NULL DEFAULT '',
   `code` VARCHAR(6) NOT NULL DEFAULT '',
   PRIMARY KEY(`countryId`)
) ENGINE = InnoDB;

2. Download and execute this script.

Category: Sql

Tagged: