MySQL add data to row after existing data

Question

I am trying to add new data right after the current data. This works well,

mysql_query("UPDATE uyeler SET shoots=shoots + 1 WHERE nick='admin'")

However, its only for numbers. I tried that with normal text value

$places = "london";
mysql_query("UPDATE uyeler SET shootplaces= shootplaces + '".$places."' WHERE nick='admin'")

But all it does is that it makes the shootplaces to 0. What is the correct way to add new value to a row without deleting the current value in it ?

menace you need addition of two text? or just Concatenate of two string? — Ishan Shah
– Ishan Shah, Commented Jan 1, 2016 at 8:21
I need to add new data to shootplaces row, after the current row data (without deleting it). — user198989
– user198989, Commented Jan 1, 2016 at 8:22

Sadikhasan · Accepted Answer · 2016-01-01 08:24:08Z

4

You have to use Mysql CONCAT function.

$places = "london";
mysql_query("UPDATE uyeler SET shootplaces= CONCAT(shootplaces , '".$places."') WHERE nick='admin'")

answered Jan 1, 2016 at 8:24

Sadikhasan

18.6k23 gold badges84 silver badges126 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 11:52:26Z

1

Is your shootplaces has INT as datatype ? Anyway, you can use concat() function to add new data into new cell.

UPDATE your_table 
SET your_column = CONCAT(your_column, 'your new value') WHERE id=..

See this link for further help

edited May 23, 2017 at 11:52

CommunityBot

11 silver badge

answered Jan 1, 2016 at 8:25

user5723483

1 Comment

Niagaradad Over a year ago

are you adding multiple values to a single column? That violates first normal form. or are you merely adding to a string. to me it looks like you are going to store multiple locations in one column.

Nimesh Patel · Accepted Answer · 2016-01-01 08:28:58Z

1

try this.

$places = "london";
     mysql_query("UPDATE uyeler SET shootplaces= concate(shootplaces , '$places') WHERE nick='admin'")

answered Jan 1, 2016 at 8:28

Nimesh Patel

8041 gold badge8 silver badges23 bronze badges

Collectives™ on Stack Overflow

MySQL add data to row after existing data

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related