Marcus,
I've managed to do this with a Perl-DBI script, but
would much prefer to do it completely with MySQL instead.
You could port it to a recursive stored procedure. It would probably be
slower, and what would you have gained?
PB
Marcus Claesson wrote:
Hi!
I have a "SQL query constru
> -Original Message-
> From: Marcus Claesson [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 03, 2007 7:49 AM
> To: mysql@lists.mysql.com
> Subject: Help with SQL query construction
>
> Hi!
>
> I have a "SQL query construction" question that I h
Hi!
I have a "SQL query construction" question that I hope someone can help
me with. After comparing a bunch of DNA fragments (see name below) with
a larger reference sequence I get a ordered list ranked according to
similarities, and with start/stop co-ordinates where the fragments map
to the ref
Hi
Having 2 tables
TOrders:
ProductID Amount
400810
4008 -5
4110 7
4110 2
4110 -4
4110 1
TStock
ProductID Count
4110 3
4110 2
What I want Is a sum of product nee
At 18:30 -0800 2/26/03, Admin-Stress wrote:
I have a table with this structure :
username VARCHAR(32)
address VARCHAR(128)
datereg DATETIME // date of registration
classINT
How is the sql query for username who are their datereg was 30 days
ago and class = 1?
WHERE class = 1 AN
I have a table with this structure :
username VARCHAR(32)
address VARCHAR(128)
datereg DATETIME // date of registration
classINT
How is the sql query for username who are their datereg was 30 days ago and class = 1?
thanks
__
D
Hi there
Try This:
SELECT products.product_name, products.fg_number, images.image_name,
images.thumbnail, images.image_path, images.color_depth,
images.width_inches, images.height_inches, images.resolution,
images.filesize, images.filetype, images.notes
FROM products LEFT JOIN images ON produc
I have two tables:
products
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra
|
+-+--+--+-+-++
| id | int(6) |
mysql - version 3.23.40-log (build from src)
i have created a database that records ahrs worked and have
2 fields (amongst others) ahrs_start & ahrs_end both are set as type time
(hh:mm:ss)
as we get paid for a minmum of 1hr for being called out i would like to be
able to
craft a query that su
