Interested to Buy Any Domain ? << Click Here >> for more details...
what if you really want to store the timestamp data, such
as the publication date of the article?
- 2 Answers
- 5875 Views
- I also Faced
- E-Mail Answers
Answer Posted / tim little
A timestamp field can hold a date passed to it!
If you do :
CREATE TABLE newtable ( aname varchar(32), pubdate timestamp );
INSERT INTO newtable ( aname, pubdate ) values ( 'first', '2009-07-08' );
and then do a
SELECT * from newtable;
Then you get "2009-07-08 00:00:00" as the date back! You don't need a second field. Why do people think this? I've seen this all around the internet and it's always wrong!
Now, I will tell you that any updates to that ROW WILL clobber the field, UNLESS you make efforts to put the old value back in, like :
update newtable set aname = 'now', pubdate=pubdate where aname = 'first';
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is cte? : Mysql dba
How to list or view all databases from the mysql server.
How do I disconnect mysql workbench?
Which is faster mysql or mongodb?
Is oracle better than mysql?
How do I change the max connection in mysql?
How do I run a query in mysql?
What are the different types of triggers in mysql?
How to create trigger in mysql workbench?
What is delimiter in mysql trigger?
How do I stop a mysql service?
What is the difference between BLOB AND TEXT?
What mysql means?
How do I create a mysql database?
Where is mysql password stored?
