On 2015/04/09 13:42, Michael Dykman wrote:
A trigger is far simpler than remodelling your data and adding extra
queries. They are nothing to be afraid of.
Not afraid of, but to be careful when writing. I have had trouble with
my triggers, because I left thisthat out. As for timestamping,
care about changes in any of
four different columns, but I don¹t care about changes in other
columns or
added columns.
Is there a command that says ³update the time stamp if and only if there
is a change in columns a, b,c, or d
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
.
Is there a command that says ³update the time stamp if and only if there
is a change in columns a, b,c, or d
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
--
- michael dykman
- mdyk...@gmail.com
May
in any of
four different columns, but I don¹t care about changes in other columns or
added columns.
Is there a command that says ³update the time stamp if and only if there
is a change in columns a, b,c, or d
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
W dniu 08.04.2015 o 17:42, Andrew Wallace pisze:
I think you'd have to do that with a trigger.
+1 for using triggers.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
columns.
Is there a command that says ³update the time stamp if and only if there
is a change in columns a, b,c, or d
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
-Original Message-
From: John Comerford [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 17, 2007 10:50 PM
To: mysql@lists.mysql.com
Subject: Millisecond time stamp
Hi Folks,
I am putting together a table to hold log entries. I was going to index
it on a field with a type
On 4/17/07, John Comerford [EMAIL PROTECTED] wrote:
Hi Folks,
A) One character string contain a string I build with the date and
milliseconds tagged onto the end
b) Two separate fields Field1 TimeStamp Field2 Milliseconds
I am leaning towards approach B, but saying that it's more gut
On 4/18/07, Tim Lucia [EMAIL PROTECTED] wrote:
-Original Message-
From: John Comerford [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 17, 2007 10:50 PM
To: mysql@lists.mysql.com
Subject: Millisecond time stamp
Hi Folks,
I am putting together a table to hold log entries. I was going
Thanks for the replies guys, banging my head against the wall for not
thinking of using an auto increment integer to handle the sequence, I've
got to cut back on those Friday night beers
On 4/17/07, John Comerford [EMAIL PROTECTED] wrote:
Hi Folks,
A) One character string contain a
John Comerford wrote:
Thanks for the replies guys, banging my head against the wall for not
thinking of using an auto increment integer to handle the sequence,
I've got to cut back on those Friday night beers
Okay, color me confused, but what exactly are you wanting to do anyway?
I am writing a type of message stack that is built while a task is
processing and presented to the user at the end of processing. I do it
using a function like
Logit(Blah, blah, blah);
Which records the SessionID, Sequence and Message, which is presented to
the user in sequence at the end
Hi Folks,
I am putting together a table to hold log entries. I was going to index
it on a field with a type of TimeStamp. Unfortunately this will not
suit my needs because I could have more than one log entry per second.
As far as my (limited) knowledge goes I have two options to get
Hi!
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, October 13, 2004 6:43 PM
Subject: RE: Table creation Time stamp
--=_alternative 005527E185256F2C_=
Content-Type: text/plain; charset=US-ASCII
By Jove! you are right! Sorry! I can't
Hi,
where can we find the time stamp of table creation i.e when that table was
created
Thanks
Anil
DBA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
use the command: SHOW TABLE STATUS
http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Anil Doppalapudi [EMAIL PROTECTED] wrote on 10/13/2004
10:42:11 AM:
Hi,
where can we find the time stamp of table creation i.e
SHOW TABLE STATUS LIKE 'your_table_name';
See the manual for details
http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html.
Michael
Anil Doppalapudi wrote:
Hi,
where can we find the time stamp of table creation i.e when that table was
created
Thanks
Anil
DBA
--
MySQL General Mailing List
By Jove! you are right! Sorry! I can't think of an easy way to find those
dates. Mr. Tuuri, any ideas?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Anil Doppalapudi [EMAIL PROTECTED] wrote on 10/13/2004
11:04:53 AM:
i see the time stamp only for Myisam table type
Is there something wrong with this code ?
Still confused after reading the manual.
td?php echo
$rsJobShortDat-Fields('DATE_FORMAT('LFWJobBank'.'Entered','%m/%d/%Y'));
?/td
Entered is a timestamp column.
With the apostrophes off the table / column I get
errors about unexpected % .
Here is my
Stuart, why not change your select statement (assuming it is correct and
actually works, in and of itself) to give the date-formatted field an
alias:
SELECT
LFWJobBank.JobReferenceCode,DATE_FORMAT(LFWJobBank.Entered,'%m/%d/%Y') AS
date_entered,
LFWJobBank.DazeLeft, LFWJobBank.JobTitle
FROM
Terry , thank you .
The query worked on it's own, but within the PHP it
got thrown back. Alias worked well.
Sorry , sort of new to db / webdev.
Stuart
--- Terry Riley [EMAIL PROTECTED] wrote:
Stuart, why not change your select statement
(assuming it is correct and
actually works, in and
Steve
Try: SELECT MAX(field_timestamp) from table1;
David
-Original Message-
From: Steve Buehler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 5:21 PM
To: mysql; PHP
Subject: time stamp
I am using PHP with MySQL and have a timestamp field in my db
table. What
MAX(field_timestamp) from table1;
David
-Original Message-
From: Steve Buehler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 5:21 PM
To: mysql; PHP
Subject: time stamp
I am using PHP with MySQL and have a timestamp field in my db
table. What
would
I am using PHP with MySQL and have a timestamp field in my db table. What
would be the easiest way to get the newest timestamp out of the db?
Thanks in Advance
Steve
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
ow3
this is the horrid time stamp i get fo my file name
whats wrong with it i cant make anything outta it
where m i messing up now
n YES its related to THIS list ... since i ve to store the uploaded file in
mysql database
id really appriciate any help with this
stuck as usual
toby
Chuck Barnett wrote:
How do I copy the data from one table to another table with a time stamp
every night?
example: table A contains x,y,z.
at midnight, I want to copy table A's contents to table B (B has same
fields, just adds a date field) and reset x,y,z to zero.
what do you
ot; [EMAIL PROTECTED]
To: "Chuck Barnett" [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, January 24, 2001 12:34 PM
Subject: Re: automation question: How do I copy the data from one table to
another table with a time stamp every night?
Chuck Barnett wrote:
How do I copy the
Chuck Barnett wrote:
Thanks for replying.
I know the SQL commands, I want to know how to automate the whole sequence.
I've always written php pages that do the calls. I want to write a script
to do it on the server as a cron job or something.
Ahhh, pardon my confusion, since this the
table
to another table with a time stamp every night?
Thanks for replying.
I know the SQL commands, I want to know how to automate the whole sequence.
I've always written php pages that do the calls. I want to write a script
to do it on the server as a cron job or something.
thanks
Chuck
29 matches
Mail list logo