how to integrate new data with existing data in a column in mysql?
i want to integrate data with exiting data in a column in phpmyadmin.
for example i have a table which has a column (ticket_number).
And its exiting value is 234 and want to add '1' before 234 so that the value will be 1234. this below written code not working for this.
UPDATE ticket SET `ticket_number`+= '1';
thanks in advance.
UPDATE ticket SET ticket_number = CONCAT(1,ticket_number)
Because if you add up the "1" directly you'll get 235 not 1234...
- A Linux, Apache, MySQL, PHP (LAMP) stack is a combination of open source software that is typically installed together to enable a server to host dynamic […]
- MySQL is an the most popular open-source database management system, in most of hosting company its has been bundle by LAMP(Linux, Apache, MySQL, PHP/Python/Perl) stack. Another alternative […]
- MySQL is the world’s most popular open-source database. Despite its powerful features, MySQL is simple to set up and easy to use. Below are some instructions […]