UPDATE column to append data into it in MySQL?
Answers
Answered by
0
Hey mate!
Here's your answer!
UPDATE command is used to update the table. It is not used to append data. There is an another command called INSERT which is used to append data.
Hope it helps :)
Answered by
0
This is just a simple UPDATE .Try the following.
UPDATE tablename
SET credit = credit + 7
WHERE ID =1
Note that ID=1 And ID='1'
is the same as the server automatically parsen it.
Similar questions