Answers for "mysql modify data\"

SQL
1

update and replace mysql

#Search, Update & Replace Query

UPDATE `tblname` SET `description`= REPLACE(`description`, 'old name', 'New Name') WHERE `description` LIKE '%old name%';
Posted by: Guest on April-24-2021
0

Update information in a mysql column

UPDATE employees 
SET 
    email = '[email protected]'
WHERE
    employeeNumber = 1056;Code language: SQL (Structured Query Language) (sql)
Posted by: Guest on August-18-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language