How run update query in server?

How I run an update query开发者_Go百科 in server.

UPDATE yourtable SET newdate1=STR_TO_DATE(olddate1, yourdateformat), newdate2 ...

Here is a very good link on getting started with php and mysql

You can use PHP's MySQL library to execute your SQL statement.

Try this:

<?php
    mysql_query("UPDATE yourtable SET newdate1=STR_TO_DATE(olddate1, yourdate)");
?>