Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database dates updating automatically

Status
Not open for further replies.
sevex

sevex

Programmer
Sep 18, 2001
74
CA
I've got a date field in a database, TIMESTAMP(14) format, NULL=YES DEFAULT=NULL, that likes to reset to the current timstamp any time I update any other field in a record. Is there any specific reason this is happening, and any way I can stop it?

Thanks
 
Sort by date Sort by votes
Writing NULL to a timestamp column updates it to the current system time. That's what timestamp columns do (can be quite handy in some circumstances).

-Rob
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ersatz
  • Locked
  • Question
How to send 2 select from mysql database in email like tables
Replies
5
Views
462
ersatz
ersatz
rogerte
  • Locked
  • Question
best way to update mysql database 2
Replies
3
Views
196
rogerte
rogerte
DanDiw
  • Locked
  • Question
How to connect at MySQL Database
Replies
1
Views
92
spamjim
spamjim
notsoevilgenius
  • Locked
  • Question
Error Updating From mySQL To MySQLi
Replies
2
Views
134
vacunita
vacunita
dkemas
  • Locked
  • Question
PHP and MSSQL dates 1
Replies
3
Views
171
jpadie
jpadie

Part and Inventory Search

Sponsor

Back
Top