Record lag functionality in MySQL?

above) Any suggestions? -- David L. Van Brunt, Ph.D. Outlier Consulting & Development mailto: <[EMAIL PROTECTED]>

Can I grab the value of a row index with the field values of the same row?

part of a SELECT¹s record set. Any ideas? Am I close? -- David L. Van Brunt, Ph.D. Outlier Consulting & Development mailto: <[EMAIL PROTECTED]>

SELECT into OUTFILE... Can I add column names?

I've scoured the online documentation, and I have a good SELECT into OUTFILE query that gives me what I want... Except that there is no 1st row with column names. Hoping I missed something obvious... Any pointers on this one? -- David L. Van Brunt, Ph.D. Outlier Consulting & Developme

Re: SELECT into OUTFILE... Can I add column names?

Okay, so I didn't miss anything... Good to know! Any way I CAN create an output file with those names? Maybe if I make a table first? On 4/6/04 21:43, "Paul DuBois" <[EMAIL PROTECTED]> wrote: > At 20:43 -0500 4/6/04, David L. Van Brunt, Ph.D. wrote: >> I've sc

Re: SELECT into OUTFILE... Can I add column names?

FABULOUS! It works like a charm, even on a very complex series of commands. Redirected output into a file, and viola! Thanks a bunch! On 4/6/04 22:17, "Paul DuBois" <[EMAIL PROTECTED]> wrote: > At 22:04 -0500 4/6/04, David L. Van Brunt, Ph.D. wrote: >> Okay, so I did

Data typing calculation results in SELECT?

I'm doing a select where I lag across records, and would like to compute some differences. It seems to do the calcs right if I evaluate the result in an IF statement, but if I just want to get the calculation result stored, it seems to default to a data type that only stores on digit. Here's the of