Add Two Time stamps. Only one will get update.
Mat
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 1:31 PM
To: MySQL List
Cc: Henning Heil
Subject: Re: updating records without changing timestamp fields
On 27 Oct 2003 at 21:21, Henning He
Try this function
nl2br()
Mat
- Original Message -
From: "Rance Hall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 01, 2002 7:51 AM
Subject: Using MySQL text column with PHP4
> I need some help formatting a MySQL longtext column for presentation via
PHP
>
> When I
ON
FORUMCAT1.ID = FORUMMSG1.POSTNUMBER)ON USERS' at line 1.
Thanks,
Mat
- Original Message -
From: "Nathan" <[EMAIL PROTECTED]>
To: "Mat Murdock" <[EMAIL PROTECTED]>
Sent: Friday, February 22, 2002 12:03 PM
Subject: Re: How to rewrite this statement.
I have this query that works just fine in msacess agains some linked mysql
tables, but if I run this statement in php or in mysqlfront it doesn't work.
I belive it's because there is two joins in it but i'm not sure. If that is
the problem then what is the work around? Here is the statement:
SE
Can you do something like this in Mysql? The following lines are part of a
much larger sql query that we use on a MSsql box.
...
case ar_open_items.doc_code
when 'I' then 'Invoice'
when 'C' then 'Credit Memo'
when 'D' then 'Debit Memo'
when 'F' then 'Finance Chg'
when 'O' then
case ar_open_items
Hehehehe.
- Original Message -
From: "Geoff Blake" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 27, 2001 11:37 AM
Subject: Re: possible bug in sum() function
> On Thu, 26 Jul 2001 [EMAIL PROTECTED] wrote:
>
> >
> > the query was:
> >
> > select
Is there a particular reason why you want the images in a mysql database.
It would be faster if you put that path to the images in a table then the
actual images.
Mat
- Original Message -
From: "Kevin Pratt" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROTECTED]>
Sent: Friday, June 15,
We will be moving our MySql databases from a Winnt server to a linux server. Can I
just copy the data files from one machine to the other? If not then how should I do
it?
Mat Murdock
Your mouse has moved. Windows must be restarted for the change to take
effect. Reboot
If I understand the manual correctly when I do a "select blah from blah where blah
= blah order by blah limit 10" Mysql finds the first 10 matching records and then
sorts those records. How do I have it first sort the database and then take the first
10 records?
Thanks for your help,
Ma
Did you look at doing something with replication?
Mat
Your mouse has moved. Windows must be restarted for the change to take
effect. Reboot now? [ OK ]
- Original Message -
From: "Aigars Grins" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 28, 20
You can read a binlog with mysqldump?
Mat
Your mouse has moved. Windows must be restarted for the change to take
effect. Reboot now? [ OK ]
- Original Message -
From: "Scott Baker" <[EMAIL PROTECTED]>
To: "Mat Murdock" <[EMAIL PROTECTED
I've looked through the manual and about 9000 posts from multiple mailing lists..
Is there a way to have mysqlbinlog take a log file and dump just the sql statements to
a file? Am I using the wrong program to do that? Any help would be most appreciated.
Mat
I tried RedHat, but had the same problem getting apache and php and mysql to
talk to each other. I decided to try Mandrake 7.2 and it did all the work
for me.
Murdmath
- Original Message -
From: "Luis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTE
13 matches
Mail list logo
