· 7 years ago · Sep 15, 2018, 06:22 PM
1Error in SQL query on server via phpmyadmin database import
2SQL query:
3
4--
5-- Database: `mydata`
6--
7-- --------------------------------------------------------
8--
9-- Table structure for table `add_place`
10--
11CREATE TABLE IF NOT EXISTS `add_place` (
12
13 `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
14 `place_name` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
15 `place_tel` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
16 `place_email` VARCHAR( 250 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
17 `url` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
18 `place_address` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
19 `place_describe` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
20 `place_cat` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
21 `image` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
22PRIMARY KEY ( `id` )
23) ENGINE = INNODB DEFAULT CHARSET = latin1 AUTO_INCREMENT =21;
24
25MySQL said:
26
27#1046 - No database selected
28
29use mydatabase;