Latest news
Home » SQL » copy data from one mysql field to another mysqlfield

copy data from one mysql field to another mysqlfield

Mysql have this option to copy one field data to another field. For this purpose run a simple query.

$UserlevelMigrationQuery     = “UPDATEusers SET  level_id = ‘4’, preunii_email =  email, migration_date = NOW(), email_verify = ‘0’ WHERE level_id = 7″;
$UserlevelMigrationResult    = mysql_query($UserlevelMigrationQuery, $connection)  or die(mysql_error());

Leave a Reply

x

Check Also

How can be list the installed SQL Server instances

Press window+R windows run window will open and then type cmd Command prompt will open ...