Hello,
I've tried the manual and google, but I am not even sure what to call what I
want to do.
simplified data example:
I have a table of start and end times for an event, and an id for that event
in a table. each event may occur multiple times, but never more than 5 times
and rarely more
On Tue, Jun 2, 2009 at 11:52 AM, Ray r...@stilltech.net wrote:
Hello,
I've tried the manual and google, but I am not even sure what to call what I
want to do.
simplified data example:
I have a table of start and end times for an event, and an id for that event
in a table. each event may
Ray,
I want a query that will provide one record per event with all times included.
feel free to answer RTFM or STFW as long as you provide the manual section or
key words. ;)
Can be done with a pivot table. Examples under Pivot tables at
On June 2, 2009 10:44:48 am Peter Brawley wrote:
Ray,
I want a query that will provide one record per event with all times
included. feel free to answer RTFM or STFW as long as you provide the
manual section or key words. ;)
Can be done with a pivot table. Examples under Pivot tables at
On June 2, 2009 03:14:36 pm Ray wrote:
On June 2, 2009 10:44:48 am Peter Brawley wrote:
Ray,
I want a query that will provide one record per event with all times
included. feel free to answer RTFM or STFW as long as you provide the
manual section or key words. ;)
Can be done
4:58 PM
To: mysql@lists.mysql.com
Subject: Re: Question about query - can this be done?
On June 2, 2009 03:14:36 pm Ray wrote:
On June 2, 2009 10:44:48 am Peter Brawley wrote:
Ray,
I want a query that will provide one record per event with all times
included. feel free to answer RTFM
that completes the picture.
Just what I was looking for.
Ray
-Original Message-
From: Ray [mailto:r...@stilltech.net]
Sent: Tuesday, June 02, 2009 4:58 PM
To: mysql@lists.mysql.com
Subject: Re: Question about query - can this be done?
On June 2, 2009 03:14:36 pm Ray wrote:
On June 2, 2009 10
My 1st question, can be understood after 3 steps below:
(1) Suppose we have a table defined as:
mysql desc tt;
+-+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---+
| id |
YL,
(2) the rows in the table are
mysql select * from tt;
++--+-+
| id | name | options |
++--+-+
| 1 | abc | (1,2,3) |
| 2 | bbc | (2,3,7) |
| 3 | cbc | (3,1,7) |
++--+-+
snip
(4) My intention is a query like
mysql select id,name from tt
| (2,3,7) |
| 3 | cbc | (3,1,7) |
++--+-+
- Original Message -
From: Peter Brawley
To: YL
Cc: mysql@lists.mysql.com
Sent: Saturday, September 03, 2005 12:34 AM
Subject: Re: string-array question. ( 2 query questions)
YL,
(2) the rows in the table are
mysql
question. ( 2 query questions)
YL,
(2) the rows in the table are
mysql select * from tt;
++--+-+
| id | name | options |
++--+-+
| 1 | abc | (1,2,3) |
| 2 | bbc | (2,3,7) |
| 3 | cbc | (3,1,7) |
++--+-+
snip
(4) My intention is a query
If you have a varchar column (late) that holds a timestamp like:
2003-11-01 08:45:12
Can you use this select statement:
select * from table where DATE_FORMAT(`late`, '%Y-%m-%d') '2003-11-01';
Even though the varchar column is not at datetime,timestamp column...
Rob
--
MySQL General Mailing
Jorge Calas [EMAIL PROTECTED] wrote:
Hello, I'm new to SQL and MySQL, I'm developing a web application (php) and I need
some tables relationed between them with a foreing key. The idea is the following
create table persons (
cid smallint auto_increment not null unique,
name
Hello, I'm new to SQL and MySQL, I'm developing a web application (php) and I need
some tables relationed between them with a foreing key. The idea is the following
create table persons (
cid smallint auto_increment not null unique,
name varchar(30),
alias varchar(10),
primary
hi all,
anyone knows if it is possible to create the query log
in a mysql table instead of in a text file?
Otherwise ... is there a way to import it into a
table?
Thanks to all.
Natale Babbo
sql, query
__
Yahoo!
: question about query log
hi all,
anyone knows if it is possible to create the query log
in a mysql table instead of in a text file?
Otherwise ... is there a way to import it into a
table?
Thanks to all.
Natale Babbo
sql, query
I'm a new user with both MySQL and MySQLGU, so this question may be very
simple. When I save query results in MySQLGU, the file shows a MIME file
with a .res extension. I haven't found a program which can open and
directly use the information. Can you help?
Thanks so much.
Gary Simmons
In the last episode (Mar 06), Christian Hammers said:
I have a table with a normal multiple key on a datetime field called
"end". I want to search for the number of records in some months. I
know that there are none.
Now "explain" tells me that a querey with a WHERE clause of
end
Hello
I have a table with a normal multiple key on a datetime field called "end".
I want to search for the number of records in some months. I know that there
are none.
Now "explain" tells me that a querey with a WHERE clause of
end between '2001-01-01' and '2001-04-01'
affects just one
19 matches
Mail list logo