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 this&that out. As for timestamping, MyS
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
ble where I 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 lis
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
anges 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.co
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
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
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?
--
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
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
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 insti
> -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 i
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 around
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!
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 on
i see the time stamp only for Myisam table type and not for InnoDB table
type. where can we find for Innodb Table type
Thanks
Anil
DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 13, 2004 8:18 PM
To: Anil Doppalapudi
Cc: [EMAIL PROTECTED
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 Gene
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
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]
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 a
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 LFWJ
Is there something wrong with this code ?
Still confused after reading the manual.
Fields('DATE_FORMAT('LFWJobBank'.'Entered','%m/%d/%Y'));
?>
"Entered" is a "timestamp" column.
With the apostrophes off the table / column I get
errors about unexpected % .
Here is my SQL statement
SELECT
LFWJ
m";}
if($hour > 12){$hour = $hour-12;}
if(!$month){
return "nothing";
}else{
return "$month-$day-$year $hour:$min $ap";
}
*/
}
Thank Again
Steve
At 08:28 AM 8/28/2002 -0700, you wrote:
>Steve
>
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
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
-
ame but it doesnt do dat
it either saves the file as its original name or it saves it as its original
name :(
4. the most horribale thing
1026114031-getStart.zip
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
from one DB, parsing and inserting into another.
Mark.
-Original Message-
From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 6:22 PM
To: Steve Ruby
Cc: [EMAIL PROTECTED]
Subject: Re: automation question: How do I copy the data from one table
to another table wi
oes that make sense?
Thanks,
Eric
At 11:34 AM 1/24/01 -0700, Steve Ruby wrote:
>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 mi
a from one 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
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
y" <[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
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 r
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.
my setup is a cobalt raq4i MySQL 3.
33 matches
Mail list logo
