error while importing an sqlto phpMyAdmin db

Question

I want to import an SQL file to my phpMyAdmin database, the file contains tables about a restaurant application and a table about the admin login, but I have 2 unexpected errors, I really don't see what is exactly wrong with that?. here is the error message:

Static analysis: 2 errors were found during analysis.

An opening bracket followed by a set of values was expected. (near "CREATE" at position 285)
Unexpected token. (near "CREATE" at position 285)

SQL query:

-- -- Déchargement des données de la table `operation` -- 

    INSERT INTO `operation` (`numop`, `numcp`, `prenom`, `nom`, `type`, `numcp2`, `mentant`, `date`) VALUES 

-- -------------------------------------------------------- -- 
-- Structure de la table `reclamation` -- 

    CREATE TABLE `reclamation` (
    `numrec` int(11) NOT NULL
    ,`id` varchar(8) NOT NULL
    ,`prenom` varchar(30) NOT NULL
    ,`nom` varchar(30) NOT NULL
    ,`text` text NOT NULL
    ,`date` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ;

MySQL said: Documentation #1064 - 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 'CREATE TABLE `reclamation` ( `numrec` int(11) NOT NULL, `id` varchar(8) NO' at line 14

CREATE TABLE `reclamation` (
  `numrec` int(11) NOT NULL,
  `id` varchar(8) NOT NULL,
  `prenom` varchar(30) NOT NULL,
  `nom` varchar(30) NOT NULL,
  `text` text NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

the create table has np error it is the insert that misses data — nbk
– nbk, Commented Feb 22, 2022 at 20:24
You have nothing after VALUES in the INSERT query. Also, the file needs ; between the queries. — Barmar
– Barmar, Commented Feb 22, 2022 at 20:26

4EACH · Accepted Answer · 2022-02-22 20:33:12Z

1

There are no values after VALUES in operation insertion query.

This error points on create because this is the next to the insertion and it expected to be values but actually is CREATE ...

It seems the values cutted off, make sure to separate between queries with ;

INSERT INTO `operation` (`numop`, `numcp`, `prenom`, `nom`, `type`, `numcp2`, `mentant`, `date`) VALUES

-- Structure de la table reclamation --

CREATE TABLE `reclamation` (
`numrec` int(11) NOT NULL
,`id` varchar(8) NOT NULL
,`prenom` varchar(30) NOT NULL
,`nom` varchar(30) NOT NULL
,`text` text NOT NULL
,`date` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ;

answered Feb 22, 2022 at 20:33

4EACH

2,1994 gold badges20 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

error while importing an sqlto phpMyAdmin db

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related