Answers for "how to modify a record in mysql"

PHP
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

Browse Popular Code Answers by Language