Sunday, December 8, 2019

How to concatenate self column in mysql

By using the following sql command we can edit a column with the value of same column: UPDATE tblclients SET phonenumber = concat('880',RIGHT(phonenumber,10)); 

No comments:

Post a Comment

Command to install direct admin on ubuntu 22.04

 sudo apt update sudo apt upgrade sudo apt install wget gcc g++ make flex bison openssl libssl-dev cd /usr/local/src wget https://www.direct...