SyntaxFix

Write A Post

Hire A Developer

Questions

Tags

[php] How to update MySql timestamp column to current timestamp on PHP?

I want to update the columns of data type timestamp manually through my PHP code.

Can you please tell me how to do that?

This question is related to php mysql database timestamp sql-update

The answer is

Another option:

UPDATE `table` SET the_col = current_timestamp

Looks odd, but works as expected. If I had to guess, I'd wager this is slightly faster than calling now().

Source: Stackoverflow.com

Examples related to php

• I am receiving warning in Facebook Application using PHP SDK • Pass PDO prepared statement to variables • Parse error: syntax error, unexpected [ • Preg_match backtrack error • Removing "http://" from a string • How do I hide the PHP explode delimiter from submitted form results? • Problems with installation of Google App Engine SDK for php in OS X • Laravel 4 with Sentry 2 add user to a group on Registration • php & mysql query not echoing in html with tags? • How do I show a message in the foreach loop?

Examples related to mysql

• Implement specialization in ER diagram • How to post query parameters with Axios? • PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client • Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver' • phpMyAdmin - Error > Incorrect format parameter? • Authentication plugin 'caching_sha2_password' is not supported • How to resolve Unable to load authentication plugin 'caching_sha2_password' issue • Connection Java-MySql : Public Key Retrieval is not allowed • How to grant all privileges to root user in MySQL 8.0 • MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Examples related to database

• Implement specialization in ER diagram • phpMyAdmin - Error > Incorrect format parameter? • Authentication plugin 'caching_sha2_password' cannot be loaded • Room - Schema export directory is not provided to the annotation processor so we cannot export the schema • SQL Query Where Date = Today Minus 7 Days • MySQL Error: : 'Access denied for user 'root'@'localhost' • SQL Server date format yyyymmdd • How to create a foreign key in phpmyadmin • WooCommerce: Finding the products in database • TypeError: tuple indices must be integers, not str

Examples related to timestamp

• concat yesterdays date with a specific time • How do I format {{$timestamp}} as MM/DD/YYYY in Postman? • iOS Swift - Get the Current Local Time and Date Timestamp • Pandas: Convert Timestamp to datetime.date • Spark DataFrame TimestampType - how to get Year, Month, Day values from field? • What exactly does the T and Z mean in timestamp? • What does this format means T00:00:00.000Z? • Swift - iOS - Dates and times in different format • Convert timestamp to string • Timestamp with a millisecond precision: How to save them in MySQL

Examples related to sql-update

• Update some specific field of an entity in android Room • How to perform update operations on columns of type JSONB in Postgres 9.4 • MySQL - UPDATE multiple rows with different values in one query • How to update multiple columns in single update statement in DB2 • Update Multiple Rows in Entity Framework from a list of ids • Update MySQL using HTML Form and PHP • CodeIgniter query: How to move a column value to another column in the same row and save the current time in the original column? • mysql after insert trigger which updates another table's column • Update values from one column in same table to another in SQL Server • I want to use CASE statement to update some records in sql server 2005