database - MySQL server version for the right syntax to use near '' at line 3

Question

I have some problem in PHPMyadmin when I import my DB.

CREATE TABLE IF NOT EXISTS `wp_cf_forms` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` varchar(18) COLLATE utf8_general_ci; NOT NULL DEFAULT '',
  `type` varchar(255) COLLATE utf8_general_ci; NOT NULL DEFAULT '',
  `config` longtext COLLATE utf8_general_ci; NOT NULL,
  PRIMARY KEY (`id`),
  KEY `form_id` (`form_id`)
)

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3(`form_id` varchar(18) COLLATE utf8_general_ci; NOT NULL DEFAULT '',)

Has anyone any idea how I can solve this?

question from:https://stackoverflow.com/questions/66068304/mysql-server-version-for-the-right-syntax-to-use-near-at-line-3

Answer 1

from what said @Thorsten Kettner you can solve this problem doing

CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci;

USE mydatabase;

CREATE TABLE IF NOT EXISTS `wp_cf_forms` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` varchar(18) NOT NULL DEFAULT '',
  `type` varchar(255) NOT NULL DEFAULT '',
  `config` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `form_id` (`form_id`)
);

the result

mysql> CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 1 row affected (0.02 sec)

mysql> USE mydatabase;
Database changed
mysql> CREATE TABLE IF NOT EXISTS `wp_cf_forms` (
    ->   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    ->   `form_id` varchar(18) NOT NULL DEFAULT '',
    ->   `type` varchar(255) NOT NULL DEFAULT '',
    ->   `config` longtext NOT NULL,
    ->   PRIMARY KEY (`id`),
    ->   KEY `form_id` (`form_id`)
    -> );
Query OK, 0 rows affected (0.03 sec)

mysql> SHOW TABLES ;
+----------------------+
| Tables_in_mydatabase |
+----------------------+
| wp_cf_forms          |
+----------------------+
1 row in set (0.01 sec)

mysql>