MySQL CLI
To login into mysql, enter db_password
mysql -u db_user -p
Create database
CREATE DATABASE db_name;
-- Table structure for table `countries` | |
CREATE TABLE IF NOT EXISTS `countries` ( | |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
`name` varchar(60) COLLATE utf8_unicode_ci NOT NULL, | |
`iso` varchar(2) COLLATE utf8_unicode_ci NOT NULL, | |
`iso3` varchar(3) COLLATE utf8_unicode_ci NOT NULL, | |
`dial` varchar(5) COLLATE utf8_unicode_ci NOT NULL, | |
`currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL, | |
`currency_name` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL, |
To login into mysql, enter db_password
mysql -u db_user -p
Create database
CREATE DATABASE db_name;