Attempting to execute two SQL queries with one query() call in CodeIgniter fails before the start of the second statement [duplicate]

Question

I am following a CodeIgniter tutorial, which tells me to make a database with the following code (using mysql):

 $sql = "create database login;
            CREATE TABLE IF NOT EXISTS `user_login` (
            `id` int(11) NOT NULL AUTO_INCREMENT,
            `user_name` varchar(255) NOT NULL,
            `user_email` varchar(255) NOT NULL,
            `user_password` varchar(255) NOT NULL,
            PRIMARY KEY (`id`)
            ) ";

I try to run this, using my own php code, but i keep getting this error, and have no idea how to solve it:

Error creating table: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `user_login` ( `id` int(11) NOT NULL AUTO_INCREM' at line 2

Why does my query fail at the start of the second query statement?

You can't execute 2 statements at once with your PHP command. — juergen d
– juergen d, Commented Oct 13, 2016 at 9:45
Split it up, execute it as two statements. Or better yet, use the migrations feature of Codeigniter. — tadman
– tadman, Commented Oct 13, 2016 at 9:46
@tadman So you mean i have to split create database and create table? — Tjazz
– Tjazz, Commented Oct 13, 2016 at 9:48
I'm curious as to what the tutorial is. Is it publicly accessible via a link? — TimBrownlaw
– TimBrownlaw, Commented Oct 13, 2016 at 9:57

actc · Accepted Answer · 2016-10-13 09:55:01Z

2

create database login;

and

CREATE TABLE IF NOT EXISTS `user_login` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_name` varchar(255) NOT NULL,
    `user_email` varchar(255) NOT NULL,
    `user_password` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
)

are two commands which are to be executed separately. Have the database created before you try to create the table - either via a SQL client or by executing something like:

$sql1 = 'create database login;';
$sql1->execute();

$sql2 = 'CREATE TABLE IF NOT EXISTS `user_login`...';
$sql2->execute();

answered Oct 13, 2016 at 9:55

actc

6821 gold badge10 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

Attempting to execute two SQL queries with one query() call in CodeIgniter fails before the start of the second statement [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related