How do I Combine SQL queries

Question

Attempted to import SQL file into phpmyadmin and this happenend... I am complete newb

SQL query:

--
-- Dumping data for table `fe`
INSERT INTO  `fe` (  `ID` ,  `userID` ,  `type` ,  `ip` ,  `note` )  
VALUES ( 31, 114,  'e',  '75.**.***.92',  'test' ) , --

Table structure for table gateway

 CREATE TABLE IF NOT EXISTS  `gateway` (

  `email` VARCHAR( 1024 ) NOT NULL ) ENGINE = MYISAM DEFAULT CHARSET =
 latin1;

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 IF NOT EXISTS gateway ( email varchar(1024) NOT NULL ) ENGINE' at line 7

If you pasted those together, you need a ;, not a , to separate queries. — kainaw
– kainaw, Commented Aug 14, 2015 at 16:38

Vishrut Reddi · Accepted Answer · 2015-08-14 16:40:13Z

1

  CREATE TABLE IF NOT EXISTS  gateway (

        email VARCHAR( 1024 ) NOT NULL ) ENGINE = MYISAM DEFAULTCHARSET = latin1;

It looks right to me. Tried it here: http://sqlfiddle.com/#!9/10aa88

Maybe its with your MySQL version. What version are you using?

And as in the comments:

This:

INSERT INTO  `fe` (  `ID` ,  `userID` ,  `type` ,  `ip` ,  `note` )  
VALUES ( 31, 114,  'e',  '75.**.***.92',  'test' ) ,

should end with a ; and not ,

answered Aug 14, 2015 at 16:40

Vishrut Reddi

979 bronze badges

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

Collectives™ on Stack Overflow

How do I Combine SQL queries

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