Hi,
On Jan 18, 2008 2:59 PM, RoryGRen [EMAIL PROTECTED] wrote:
Hi all
I am quite new to mySQL and have the following question I hope someone can
help me with:
I have a database table imported directly from MS Access with two of the
field names having brackets - F(1) and S(1). I don't want
.
With best wishes
Ch
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: 14 December 2005 19:22
To: Jesse
Cc: mysql@lists.mysql.com
Subject: Re: SQL Statement Help
Jesse [EMAIL PROTECTED] wrote on 12/14/2005 02:03:22 PM:
Hello,
I need
Hello,
I need help building a SQL Statement. I'm currently using MySQL
5.something. This one is kind of strange, and I can't seem to figure out
how to do it.
I have a table named Participants. Each Participant is allowed to bring up
to 5 Guests. Instead of putting the names in a
Jesse [EMAIL PROTECTED] wrote on 12/14/2005 02:03:22 PM:
Hello,
I need help building a SQL Statement. I'm currently using MySQL
5.something. This one is kind of strange, and I can't seem to figure
out
how to do it.
I have a table named Participants. Each Participant is allowed to
Turn off your auto commit (if using innodb) and run the queries. See how
many rows it updates and compare them. If it matches commit it. Else
rollback.
C.F. Scheidecker Antunes wrote:
Another thing is that table2 might not have a match.
C.F. Scheidecker Antunes wrote:
I actually forgot
C.F. Scheidecker Antunes [EMAIL PROTECTED] wrote on 10/16/2005
01:58:56 PM:
I actually forgot something. I need a two statements into one. The
reason is that table_two has multiple values, so I need the minimal ID
from table 2.Thanks.
Maybe I am working too much here and tired to see the
I am not the smartest on the list, but I think this would do it for you.
UPDATE table_one t1, table_two t2 SET t1.ID = t2.ID WHERE t2.num = t1.num
AND t1.ID = 0
J.R.
-Original Message-
From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 16, 2005 1:45 PM
To:
I actually forgot something. I need a two statements into one. The
reason is that table_two has multiple values, so I need the minimal ID
from table 2.Thanks.
Maybe I am working too much here and tired to see the right statement.
J.R. Bullington wrote:
I am not the smartest on the list, but
Another thing is that table2 might not have a match.
C.F. Scheidecker Antunes wrote:
I actually forgot something. I need a two statements into one. The
reason is that table_two has multiple values, so I need the minimal ID
from table 2.Thanks.
Maybe I am working too much here and tired to
On Wednesday, March 30, 2005 09:49, Christopher Vaughan wrote:
I have data in a table listed as
44:22:22
333:33:33
It stands for hhh:mm:ss
If you convert it to a time field you can use mysql built-in functions
to do what you want. You are limited to the range -838:59:59 to
838:59:59
On Wednesday, March 30, 2005 10:24, Christopher Vaughan wrote:
Tom Crimmins on Wednesday, March 30, 2005 at 11:10 AM -0500 wrote:
If you convert it to a time field you can use mysql built-in
functions to do what you want. You are limited to the range
-838:59:59 to 838:59:59 though.
I think I remember a match_at(:) or pat_index(:) UDF which would
return the position of the first : for you, but I can't find it if it
does exist.
On Wed, 30 Mar 2005, Christopher Vaughan wrote:
I have data in a table listed as
44:22:22
333:33:33
It stands for hhh:mm:ss
I want to break each
Christopher Vaughan [EMAIL PROTECTED] wrote on 30/03/2005 16:48:47:
I have data in a table listed as
44:22:22
333:33:33
It stands for hhh:mm:ss
I want to break each part of the data into different parts based on
the ':' to separate them. Then I want to take that data and sum it.
I wrote
Craig Hoffman [EMAIL PROTECTED] wrote on 01/18/2005 04:17:30 PM:
Hi There,
I have web form where a user can search certain fields and then have
them displayed aggregated. For example, find all the routes I climbed
with partner A in area(s) ALL (% - wildcard) between date1 and date2 --
so
Hi Rhino
I had pretty much already suggested doing that, but I have been told that
I'm not allowed to redesign the database as there is already lots other code
working on it already that would need changing as well. I personally think
the database design is terrible, but I have to work with what
Andrew Dixon [EMAIL PROTECTED] wrote:
Hi Everyone.
I require some help with an IN statement I'm trying to get working. I have
inherited a database from someone else in which there is a table with
project information and a field containing which geographic regions the
projects relate. As a single
Hi.
Thanks Stephen, the works like a dream... Unlike this database which is more
like a nightmare!!!
Best Regards
Andrew.
-Original Message-
From: Stephen E. Bacher [mailto:[EMAIL PROTECTED]
Sent: 03 August 2004 12:16
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: In Statement
://archives.postgresql.org/pgsql-performance/2002-12/msg00185.php
HTH,
Martin Gainty
From: Andrew Dixon [EMAIL PROTECTED]
To: 'Stephen E. Bacher' [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: In Statement Help
Date: Tue, 3 Aug 2004 12:27:25 +0100
MIME-Version: 1.0
Received: from lists.mysql.com
: Stephen E. Bacher [mailto:[EMAIL PROTECTED]
Sent: 03 August 2004 12:16
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: In Statement Help
Andrew Dixon [EMAIL PROTECTED] wrote:
Hi Everyone.
I require some help with an IN statement I'm trying to get working. I
have inherited a database from someone
Martin Gainty wrote:
Andrew et al-
Keep in mind that when you use LIKE you will NOT use an index but you
will use a full table scan instead.
Agreed.
Also instead of using IN EXISTS uses Indexes on the master table
query..if you have master-heavy or parent-heavy query use EXISTS/NOT
EXISTS vs
On Tue, 03 Aug 2004 06:50:46 -0600, Martin Gainty wrote:
Keep in mind that when you use LIKE you will NOT use an index but you will
use a full table scan instead
Also instead of using IN EXISTS uses Indexes on the master table query..if
you have master-heavy or parent-heavy query use
is Indexed-
Martin Gainty
From: Michael Stassen [EMAIL PROTECTED]
To: Martin Gainty [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: In Statement Help
Date: Tue, 03 Aug 2004 10:26:29 -0400
MIME-Version: 1.0
Received: from out011.verizon.net
- Original Message -
From: Andrew Dixon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 02, 2004 9:44 AM
Subject: In Statement Help
Hi Everyone.
I require some help with an IN statement I'm trying to get working. I have
inherited a database from someone else in which
Mark,
You can find your first missing date in MySQL 4.1.0(alpha) or higher,
using sub-selects, something like this:
SELECT MIN(DATEADD(LOAD_DATE,1)) AS MISSING_DATE
FROM load_cntl AS A
WHERE
DATEDIFF(NOW(), LOAD_DATE) 30
AND LOAD_DATE
(SELECT MAX(LOAD_DATE) FROM load_cntl AS B)
AND
At 21:21 -0700 9/21/02, Des Dougan wrote:
I want to extract data into a temporary table such that unique
records with the same primary key (in this case an invoice number)
are written to one record, with each of the unique fields extracted
being written to a separate field in the temporary
Hello,
I've been trying to figure this out but I feel like I'm just
banging my head
on the wall.
That must be quite painful...
I hope this is the right forum to pose this question.
It's certainly one of the better ones, yes.
I have a table of flights which has several fields
Table:
On Sat, 12 Jan 2002, Tom Jones wrote:
Table: flights
Fields: depart, depart_time, arrive, arrive_time, flight_no, flight_group
I'm trying to do a search on depart and arrive and show only the records
which have matching flight_group
SELECT depart, arrive
FROM flights
WHERE flight_group
27 matches
Mail list logo