I want to `Add columns` to my database using `PDOquery`. But my query returns some error

Question

I want to Alter my database table (Add Columns) using query. I have done this :

This is my first query (Run Successfully) :

$database->pdoQuery("ALTER TABLE tbl_mytable ADD column1 varchar(100)");

This is my second query (gives an error) :

$database->pdoQuery("ALTER TABLE tbl_mytable ADD column2 text");

I have got this error message:

Executed Query -> ALTER TABLE tbl_mytable ADD column2 text
ERROR:"SQLSTATE[HY000]: General error: 315"

Can any one solve my problem? Any help would get appreciated.

Nimesh Vagadiya · Accepted Answer · 2016-02-22 13:59:57Z

1

$db->query("ALTER TABLE tbl_mytable ADD column2 text NOT NULL AFTER column1");

answered Feb 22, 2016 at 13:59

Nimesh Vagadiya

6323 gold badges8 silver badges18 bronze badges

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

Comments

schellingerht · Accepted Answer · 2016-01-23 18:50:45Z

1

You didn't say which versions you're using.

Your query is not wrong, but it could be your (older) MySQL version. Add backticks to your query:

$database->pdoQuery("ALTER TABLE `tbl_mytable` ADD `column2` text");

answered Jan 23, 2016 at 18:50

schellingerht

5,8062 gold badges30 silver badges56 bronze badges

Tried but same result. :(