On Nov 29, 2011, at 11:50 AM, Claudio Nanni wrote:
>
> This is not to say that MySQL could not have more of the file management
> features. For example, the ability to add or remove datafiles on the fly and
> the
> ability to detach tablespaces as collections of tables.
>
> That's where MySQ
Hi... there is stuff inline there.
>> The logic behind this is probably that without innodb_file_per_table=1
>> and with several large ibdata files, the space IS freed up when one does
>> optimize table or drop table. The space is freed up inside the database
>> files and can be reused.
>
>
Am 29.11.2011 20:25, schrieb Karen Abgarian:
>
> On 29.11.2011, at 5:21, Reindl Harald wrote:
>> why is this dumb "innodb_file_per_table=0" default since MOST PEOPLE
>> have only troubles with it because they can not free space with
>> "optimize table" with no real benefits?
>
> The logic behind
>
>
> This is not to say that MySQL could not have more of the file management
> features. For example, the ability to add or remove datafiles on the fly
> and the
> ability to detach tablespaces as collections of tables.
That's where MySQL(read InnoDB) got stuck actually, it never introduced a
On 29.11.2011, at 5:21, Reindl Harald wrote:
>
> ibdata1 does NEVER get smaller, this is normal and a hughe problem
> in your case, only if you are using "innodb_file_per_table" which
> is NOT default would retire the space after drop tables
>
> why is this dumb "innodb_file_per_table=0" defaul
Am 29.11.2011 14:08, schrieb Luis Pugoy:
> Hello. I have the following problem.
>
> I was importing a large database to mysql using mysqldump. Unfortunately this
> filled up the whole disk, and
> mysqldump exited with an error that the table it is currently writing to is
> full. Checking df -h
df -h was correct. However,
when I try to restart mysql it outputs the following errors in the error
log; it is in the attached file.
Thanks for anyone that could help.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
29 12:51
2011/10/24 16:31 -0700, Daevid Vincent
WHERE cs.customer_id = 7
GROUP BY customer_id
Well, the latter line is now redundant.
How will you make the '7' into a parameter?
--
MySQL General Mailing List
For list archives: http://l
October 24, 2011 4:06 PM
> To: mysql@lists.mysql.com
> Subject: RE: Within-group aggregate query help please - customers and
latest
> subscription row
>
> A kind (and shy) soul replied to me off list and suggested this solution,
> however,
> this takes 28 seconds (that's f
-
> From: Daevid Vincent [mailto:dae...@daevid.com]
> Sent: Monday, October 24, 2011 1:46 PM
> To: mysql@lists.mysql.com
> Subject: Within-group aggregate query help please - customers and latest
> subscription row
>
> I know this is a common problem, and I've been struggling
I know this is a common problem, and I've been struggling with it for a full
day now but I can't get it.
I also tried a few sites for examples:
http://www.artfulsoftware.com/infotree/queries.php#101
http://forums.devarticles.com/general-sql-development-47/select-max-datetime
-problem-10210.html
iPad
>
> On Oct 5, 2011, at 4:01 AM, Tompkins Neil
> wrote:
>
> > Following my mail below, if anyone can help optimise the query further
> that
> > would be a great help.
> >
> > -- Forwarded message --
> > From: Tompkins Neil
> >
Try adding an index on cities.name, it may prevent the file sort. What was the
original query time and what is it now?
Sent from my iPad
On Oct 5, 2011, at 4:01 AM, Tompkins Neil wrote:
> Following my mail below, if anyone can help optimise the query further that
> would be a grea
Following my mail below, if anyone can help optimise the query further that
would be a great help.
-- Forwarded message --
From: Tompkins Neil
Date: Wed, Oct 5, 2011 at 9:48 AM
Subject: Re: Slow query - please help
To: Johnny Withers
Cc: "mysql@lists.mysql.com"
I ju
g where'
'2', 'DEPENDENT SUBQUERY', 'hotels', 'ref',
'UNQ_folder_url,IDX_country_code,IDX_enabled,IDX_language_code',
'IDX_enabled', '1', 'const', '267', '100.00', 'Using index condition; Usin
27;IDX_language_code', NULL, NULL,
NULL, '163102', '100.00', 'Using where'
'2', 'DEPENDENT SUBQUERY', 'hotels', 'ref',
'UNQ_folder_url,IDX_enabled,IDX_language_code', 'IDX_enabled', '1', 'c
Can you post the explain extended output of your query?
Sent from my iPad
On Oct 4, 2011, at 2:45 PM, Neil Tompkins wrote:
> Can anyone help me ?
>
>
> Begin forwarded message:
>
>> From: Tompkins Neil
>> Date: 30 September 2011 20:23:47 GMT+01:00
>>
Can anyone help me ?
Begin forwarded message:
> From: Tompkins Neil
> Date: 30 September 2011 20:23:47 GMT+01:00
> To: mark carson
> Cc: "[MySQL]"
> Subject: Re: Slow query - please help
>
> I downloaded version mysql-5.6.2-m5-win32.msi and he table definitio
ERE districts.city_id =
> > cities.city_id AND districts.language_code = 'en' AND
> districts.country_code
> > = 'gb') AS district_count
> > FROM cities WHERE language_code = 'en' AND country_code = 'gb'
> > ORDER BY cities
x27;
ORDER BY cities.name ASC , cities.city_id ASC
Previously the table format was Innodb with foreign keys and the query was
pretty much instant. Now I've changed the table format to MyISAM and
obviously removed the foreign keys and the query takes forever to execute
using the same data. Can anyone help and tell me where I've gone wrong.
Thanks
Neil
the redo log on a raid disk, I
assume that would allow the system to continue running in these
scenarios. I would prefer a solution that does not add this cost to the
system.
Thanks for your help
Paul
l.com
Subject: Re: need help with -- unknown variable
Check if this is in the [mysqldump] section of your my.cnf file(s). Of course
it might not be a valid option in mysqldump...I haven't checked...
On 13 Jun 2011 17:00, "Brown, Charles" mailto:cbr...@bmi.com>>
wrote:
> He
> mysqldump: unknown variable 'datadir=/var/lib/mysql'
>
> Please can someone help me.
>
> Thanks
>
>
>
>
>
>
> This message is intended only for the use of the Addressee and
> may contain informatio
Hello All ~ I attempted to do a mysqldump when I got this message -- see below:
mysqldump: unknown variable 'datadir=/var/lib/mysql'
Please can someone help me.
Thanks
This message is intended only for the use of the Addressee and
m
I could be wrong but I think your problem is the unique index.
--
João Cândido de Souza Neto
"robert rottermann" escreveu na mensagem
news:4dd967a8.5040...@redcor.ch...
> Hi there,
>
> I would like to create a table that optionally links to an other table.
>
> The field company_id in the fol
Hi there,
I would like to create a table that optionally links to an other table.
The field company_id in the following table should be either Null or link to the
table tblCompany (`id` ).
How do I do that. The way I it now, I can not enter records where the field
company_id is null.
Thanks
ERE tmp.file = C.file and
tmp.digest = C.digest);
--Anupam
--- On Tue, 17/5/11, Aveek Misra
mailto:ave...@yahoo-inc.com>> wrote:
From: Aveek Misra mailto:ave...@yahoo-inc.com>>
Subject: Help with a query
To: "mysql@lists.mysql.com<mailto:mysql@lists.mysql.com>"
mailto:m
, digest
HAVING Sum(Cnt) <> (Select sum(refcount) from C WHERE tmp.file = C.file and
tmp.digest = C.digest);
--Anupam
--- On Tue, 17/5/11, Aveek Misra wrote:
From: Aveek Misra
Subject: Help with a query
To: "mysql@lists.mysql.com"
Date: Tuesday, 17 May, 2011, 1:23 PM
I ha
I have a table A and table B of the same type as
CREATE TABLE A (
`file` varbinary(255) not null,
`digest` binary(40) not null
)
CREATE TABLE B (
`file` varbinary(255) not null,
`digest` binary(40) not null
)
I have another table C of the following type
CREATE TABLE C (
On 5/12/2011 2:30 PM, Grega Leskovšek wrote:
CREATE TABLE log ( idlog int auto_increment not null, imepriimek
varchar(50), clock timestamp, action varchar(30), onfile
varchar(100), filesize float(6,2), uniqueid(idlog) );
CREATE TABLE log (
idlog int auto_increment primary key,
imepriimek va
Can smbd please look at this sentence - I got an error and do not
know how to fix it - I am still very unfamiliar with MYSQL:
CREATE TABLE log ( idlog int auto_increment not null, imepriimek
varchar(50), clock timestamp, action varchar(30), onfile
varchar(100), filesize float(6,2), uniqueid(
2011/03/15 17:51 -0500, LAMP
Let's say there is a table orders (simplified, of course)
CREATE TABLE orders (
item_id int,
org_id int,
) ENGINE=MyISAM
Need to select all (distinct) org_id they have item_id 34, 36, 58 and
63. All of them, not only some of them.
Result is org_id=2
I don't currently have any version of MySQL installed so
I can't try this myself to be sure it works in your version of MySQL.
--
Rhino
your query will give me every org_id that has ANY of item_id., I need org_id
that has ALL of item_id. right?
result would be
2607
1520
8934
7295
1649
2011/03/18 08:49 -0500, LAMP
Is here anybody from mysql development team, to suggest to build IN
ALL function?
There is a problem here: the basic operation is on the record, each record by
each record, all by itself. The solution to your problem entails acting on more
distinc
ANY of item_id., I
need org_id that has ALL of item_id. right?
result would be
2607
1520
8934
7295
1649
8871
On 2011-03-15 18:51, LAMP wrote:
Hi,
I need a help to build a query.
Let's say there is a table orders (simplified, of course)
CREATE TABLE orders (
`item_id` int,
`or
r query will give me every org_id that has ANY of item_id., I
need org_id that has ALL of item_id. right?
result would be
2607
1520
8934
7295
1649
8871
On 2011-03-15 18:51, LAMP wrote:
Hi,
I need a help to build a query.
Let's say there is a table orders (simplified, of course)
ery org_id that has ANY of item_id., I
need org_id that has ALL of item_id. right?
result would be
2607
1520
8934
7295
1649
8871
On 2011-03-15 18:51, LAMP wrote:
Hi,
I need a help to build a query.
Let's say there is a table orders (simplified, of course)
CREATE TABLE orders (
`
r version of MySQL.
--
Rhino
your query will give me every org_id that has ANY of item_id., I
need org_id that has ALL of item_id. right?
result would be
2607
1520
8934
7295
1649
8871
On 2011-03-15 18:51, LAMP wrote:
Hi,
I need a help to build a query.
Let's say there is a tabl
te:
Hi,
I need a help to build a query.
Let's say there is a table orders (simplified, of course)
CREATE TABLE orders (
`item_id` int,
`org_id` int,
) ENGINE=MyISAM
item_idorg_id
342607
342607
341520
362607
361520
368934
3828
38
Hi,
I need a help to build a query.
Let's say there is a table orders (simplified, of course)
CREATE TABLE orders (
`item_id` int,
`org_id` int,
) ENGINE=MyISAM
item_idorg_id
342607
342607
341520
362607
361520
368934
38
The OR conditions require a full table scan everytime this is called.
You didn't say how many rows you had, nor if there were indexes on
your various phone_xxx fields. If you do, you should get some value
by approaching it as a UNION
select count(id)from (
select id from leads where phone_work
Dear all,
I have a query that takes a rather long time and was wondering if there is
anyway to optimize it.
Normally we removing duplicate records by phone number. This query takes about
a
second and
it really slows down the process when we are importing several 1000 records a
day.
Here is
On 3/10/11 10:46 AM, Shawn Green (MySQL) wrote:
On 3/10/2011 12:32, Jim McNeely wrote:
Rhino,
Thanks for the help and time! Actually, I thought the same thing, but what's
weird is that is the only thing that doesn't slow it down.
If I take out all of the join clauses EXCEPT th
`),
KEY `NameFirst` (`NameFirst`),
KEY `NameLast` (`NameLast`)
This extremely simple join is still massively slow.
Jim
On Mar 10, 2011, at 10:00 AM, Shawn Green (MySQL) wrote:
On 3/10/2011 12:32, Jim McNeely wrote:
Rhino,
Thanks for the help and time! Actually, I thought the same thing
`NameLast` (`NameLast`)
This extremely simple join is still massively slow.
Jim
On Mar 10, 2011, at 10:00 AM, Shawn Green (MySQL) wrote:
> On 3/10/2011 12:32, Jim McNeely wrote:
>> Rhino,
>>
>> Thanks for the help and time! Actually, I thought the same thing, but what's
&g
On 3/10/2011 12:32, Jim McNeely wrote:
Rhino,
Thanks for the help and time! Actually, I thought the same thing, but what's
weird is that is the only thing that doesn't slow it down. If I take out all of
the join clauses EXCEPT that one the query runs virtually instantaneously.
mysql.com/doc/refman/5.1/en/index-hints.html
Mike
At 11:32 AM 3/10/2011, Jim McNeely wrote:
Rhino,
Thanks for the help and time! Actually, I thought the same thing, but
what's weird is that is the only thing that doesn't slow it down. If I
take out all of the join clauses EXCEPT
Rhino,
Thanks for the help and time! Actually, I thought the same thing, but what's
weird is that is the only thing that doesn't slow it down. If I take out all of
the join clauses EXCEPT that one the query runs virtually instantaneously. for
some reason it will use the index in tha
Shawn,
Thanks for the great help! It still is not working. I did an EXPLAIN on this
query with your amended split out join statements and got this:
++-+---+---+---++-+--++-+
| id | select_type | table | type
Hi Jim,
On 3/9/2011 17:57, Jim McNeely wrote:
I am trying to set up an export query which is executing very slowly, and I was
hoping I could get some help. Here is the query:
SELECT a.IdAppt, a.IdPatient,
p.NameLast, p.NameFirst, p.NameMI,
a.IdProcedure, a.ProcName, CAST(CONCAT(a.ApptDate
I am trying to set up an export query which is executing very slowly, and I was
hoping I could get some help. Here is the query:
SELECT a.IdAppt, a.IdPatient,
p.NameLast, p.NameFirst, p.NameMI,
a.IdProcedure, a.ProcName, CAST(CONCAT(a.ApptDate, " ", a.ApptTimeOut) AS CHAR)
Ap
lto:neil.tompk...@googlemail.com]
>Sent: Wednesday, March 02, 2011 10:12 AM
>To: Jerry Schwartz
>Cc: [MySQL]
>Subject: Re: Query help
>
>Thanks for the response. This is what I was after. Although, I am looking
>to find out the email addresses used to login from the same IP
il.com]
> >Sent: Wednesday, March 02, 2011 6:00 AM
> >To: [MySQL]
> >Subject: Query help
> >
> >Hi
> >
> >I've the following basic table
> >
> >login_id
> >email_address
> >ip_address
> >
> >I want to extract all reco
>-Original Message-
>From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
>Sent: Wednesday, March 02, 2011 6:00 AM
>To: [MySQL]
>Subject: Query help
>
>Hi
>
>I've the following basic table
>
>login_id
>email_address
>ip_address
>
&g
Hi Neil,
select
login_id,
ip_address
from
basic_table
group by
login_id,ip_address
having
count(login_id,ip_address)>1
this should work
in case you want to see also the list of emails add:
group_concat(email_address,',') as list_of_used_emails
to the select fields.
Claudio
Hi
I've the following basic table
login_id
email_address
ip_address
I want to extract all records from this table in which a user has used the
same IP address but different email address to login ?
Thanks,
Neil
If you are brand new to mysql, you do not want to start with the
cluster. Try the community server distro instead:
here is a link to the 64-bit generic linux version:
http://dev.mysql.com/downloads/mirror.php?id=401067#mirrors
On Thu, Feb 10, 2011 at 10:33 AM, rohit bishnoi wrote:
> *hello ev
*hello everyone on list*
*i am a student of MCA and want to learn mysql. i have installed
"mysql-cluster-gpl-7.1.4b-linux-i686-glibc23" binary distribution on my
fedora 14 system. the installation process have gone OK according to steps
listed in distribution's installation file.*
*
*
*But when i
orre...@gmail.com]
Sent: Monday, February 07, 2011 1:08 PM
To: mysql@lists.mysql.com
Subject: Help with ORDER BY
I currently have a query that organizes search results for volunteers that
should be called for projects based on how close they live to a project the
and there past attendance.
Currently d
ty and the
number of projects done trumps distance from the project, but in the
beginning I am willing to set that somewhat arbitrary and adjust it later.
I realize that this may be beyond the scope of a MySQL query. If so I am
grateful for any ideas on where to go for info/help.
Thanks,
Richard
:
> Something like this might help you find all of the times where your user_id
> switched to a different team_id:
>
> select team_id, user_id, min(last_changed)
> from
> (select home_team_id as team_id, home_user_id as user_id, last_changed
> from data
> union all
> sel
Something like this might help you find all of the times where your user_id
switched to a different team_id:
select team_id, user_id, min(last_changed)
from
(select home_team_id as team_id, home_user_id as user_id, last_changed
from data
union all
select away_team_id as team_id, away_user_id as
Hi,
I've the following list of sample data, and need a SELECT statement to help
me identify the point at which I've highlighted the data :
Season, Competition, home_team_id, away_team_id, home_user_id, away_user_id,
last_changed
1, 18, 11, 23, 3, 2010-11-14 17:18:17
1, 11, 8, 3, 82,
On Tue, 1 Feb 2011 14:46:39 -0400
Paul Halliday wrote:
> I have a query (thanks to this list) that uses a join to add country
> information to an IP. It looks like this:
>
> SELECT COUNT(signature) AS count, INET_NTOA(src_ip), map1.cc as
> src_cc, INET_NTOA(dst_ip), map2.cc as dst_cc
> FROM even
Hi Paul!
Paul Halliday wrote:
> I have a query (thanks to this list) that uses a join to add country
> information to an IP. It looks like this:
>
> SELECT COUNT(signature) AS count, INET_NTOA(src_ip), map1.cc as
> src_cc, INET_NTOA(dst_ip), map2.cc as dst_cc
> FROM event LEFT JOIN mappings AS m
I have a query (thanks to this list) that uses a join to add country
information to an IP. It looks like this:
SELECT COUNT(signature) AS count, INET_NTOA(src_ip), map1.cc as
src_cc, INET_NTOA(dst_ip), map2.cc as dst_cc
FROM event LEFT JOIN mappings AS map1 ON event.src_ip = map1.ip LEFT
JOIN mapp
On 01/31/2011 12:18 PM, Jørn Dahl-Stamnes wrote:
> On Monday 31 January 2011 21:12, Phillip Baker wrote:
>
>> Greetings All,
>>
>> I am looking for a little help in setting a where clause.
>> I have a dateAdded field that is a DATETIME field.
>> I am look
On 1/31/2011 15:12, Phillip Baker wrote:
Greetings All,
I am looking for a little help in setting a where clause.
I have a dateAdded field that is a DATETIME field.
I am looking to pull records from Midnight to midnight the previous day.
I thought just passing the date (without time) would get
Thank you very much Jørn
Blessed Be
Phillip
"Never ascribe to malice what can be explained by incompetence"
-- Hanlon's Razor
On Mon, Jan 31, 2011 at 1:18 PM, Jørn Dahl-Stamnes
wrote:
> Jørn
On Monday 31 January 2011 21:12, Phillip Baker wrote:
> Greetings All,
>
> I am looking for a little help in setting a where clause.
> I have a dateAdded field that is a DATETIME field.
> I am looking to pull records from Midnight to midnight the previous day.
> I thought jus
Greetings All,
I am looking for a little help in setting a where clause.
I have a dateAdded field that is a DATETIME field.
I am looking to pull records from Midnight to midnight the previous day.
I thought just passing the date (without time) would get it but I keep
getting an empty record set
Thank you, that did the trick.
Simon
On 11 January 2011 12:09, Steve Meyers wrote:
> On 1/11/11 9:31 AM, Simon Wilkinson wrote:
>
>> select users.id from users where users.id in (select newletters.user_id
>> from
>> newletters left join articles on newletters.id = articles.newsletter_id
>> wher
On 1/11/11 9:31 AM, Simon Wilkinson wrote:
select users.id from users where users.id in (select newletters.user_id from
newletters left join articles on newletters.id = articles.newsletter_id
where articles.newsletter_id is null);
I think this would do what you require:
SELECT
u.id AS user_i
Hi,
I have 3 tables that I am trying to search across, and could use some help
on how to structure the query. I have a users table, a newsletter table,
and an articles table. The newsletter table has a user_id column, and the
articles table has a newsletter_id column. A user can have multiple
stuck. I wonder if anyone out there could take a look at this
> bit of mysqld log. Any help at all would be greatly appreciated!!!
>
> Pito
>
> 110107 15:07:15 mysqld started
> 110107 15:07:15 InnoDB: Database was not shut down normally!
> InnoDB: Starting crash recovery
I am very new to trying to solve a problem like this and have searched
and searched the web for a useful troubleshooting guide but I am
honestly stuck. I wonder if anyone out there could take a look at this
bit of mysqld log. Any help at all would be greatly appreciated!!!
Pito
110107 15:07:15
the cloud.
As we develop our Database-as-a-Service cloud offering, we'd like to hear from
you:
Please help us by answering a few questions about your experiences with
databases in the cloud.
Complete the survey and receive a free T-shirt!
http://xeround.com/developers/mysql-in-the-cloud-survey/
Thanks!
Hello,
Thank for your help
I just try mysqldump with --quick or --opt option ... to avoid
"out of memory" problem but
--> dump fails with --max_allowed_packet=2048M and --quick :
r...@pcjahia01:/# /usr/bin/mysqldump -A --max_allowed_packet=2048M
--quick --default-chara
_size = 100M
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 16M
includedir /etc/mysql/conf.d/
Any help would be appreciate !!
Bests
--
Christophe Dumonet
Centre de Ressour
hi,everyone:
i need your helps,really!! this is my second compiling-failed on
building my own MySQL already.previous is version 5.5.6 rc,now is 5.5.7 rc.
my build environment is centos 5 x86,full name is Linux PowerPC
2.6.18-194.8.1.el5.028stab070.5 #1 SMP Fri Sep 17 19:10:36 MSD 2010 i686
i686
On 10/27/2010 6:55 AM, Nuno Mendes wrote:
I have 3 tables: (1) Companies, (2) locations and (3) employees:
CREATE TABLE `companies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(75) NOT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `locations ` (
`id` i
I have 3 tables: (1) Companies, (2) locations and (3) employees:
CREATE TABLE `companies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(75) NOT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `locations ` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`
Then you'll probably need to define it with a separate select before using
it. I'm half-guessing here, really, but that sounds like it makes sense :-)
On Mon, Sep 27, 2010 at 11:49 AM, Tompkins Neil <
neil.tompk...@googlemail.com> wrote:
> Hi,
>
> I did try defining it before the IF statement, bu
Hi,
I did try defining it before the IF statement, but still the same ?
Cheers
Neil
On Mon, Sep 27, 2010 at 7:58 AM, Johan De Meersman wrote:
> At a guess, because you use @team in an if statement before you actually
> define it.
>
>
> On Sun, Sep 26, 2010 at 12:35 AM, Tompkins Neil <
> neil.to
At a guess, because you use @team in an if statement before you actually
define it.
On Sun, Sep 26, 2010 at 12:35 AM, Tompkins Neil <
neil.tompk...@googlemail.com> wrote:
> Hi,
>
> I've the following query
>
> SELECT teams_id AS teams_id ,SUM(rating) AS total_team_rating FROM (SELECT
> teams_id
Hi,
I've the following query
SELECT teams_id AS teams_id ,SUM(rating) AS total_team_rating FROM (SELECT
teams_id ,players_id ,rating ,IF(@team <> teams_id, @row := 1, @row := @row
+ 1) AS rank ,@team := teams_id FROM ( SELECT players.teams_id
,players.players_id ,players_master.rating FROM player
I wondered if anyone can help me ? Do you need any further information ?
Cheers
Neil
-- Forwarded message --
From: Tompkins Neil
Date: Thu, Sep 23, 2010 at 9:49 AM
Subject: Query help please
To: "[MySQL]"
Hi all,
I've the following
Hi all,
I've the following query :
SELECT fixtures_results.seasons_id ,
home_teams_id AS teams_id ,
1 AS home ,0 AS away ,
(SELECT SUM(goals) FROM players_appearances WHERE
fixtures_results.fixtures_results_id =
players_appearances.fixtures_results_id AND players_appearances.teams_id =
home_teams
>-Original Message-
>From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
>Sent: Tuesday, September 21, 2010 11:48 AM
>To: Johan De Meersman
>Cc: [MySQL]
>Subject: Re: SELECT WHERE IN help
>
>Thanks for the reply. The search of (3,4,5,6,7,3) is pulling data
Hi Neil, all!
Tompkins Neil wrote:
> Hi
>
> With a SELECT * FROM my_table WHERE record_id IN (3,4,5,6,7,3), how can I
> return two records for the record_id 3 ? Is it possible ?
This is a case where you may safely use natural language and logic. The
command is
SELECT all fields FROM the rec
On 21/09/2010 16:44, Tompkins Neil wrote:
Thanks for the quick reply. Basically in (3,4,5,6,7,3) the record_id of 3
only exists once in the table my_table. However, because 3 exists twice
within (3,4,5,6,7,3), I want it to return two records for record_id 3. Is
it possible ?
No, that isn't
Thanks for the reply. The search of (3,4,5,6,7,3) is pulling data from a
table. I think in this case I need to change my design .
On Tue, Sep 21, 2010 at 4:46 PM, Johan De Meersman wrote:
> I don't think that'll work, no. Why would you want to return duplicate data
> ? The whole point of an R
I don't think that'll work, no. Why would you want to return duplicate data
? The whole point of an RDBMS is to *avoid* duplicate data :-)
On Tue, Sep 21, 2010 at 5:44 PM, Tompkins Neil wrote:
> Thanks for the quick reply. Basically in (3,4,5,6,7,3) the record_id of 3
> only exists once in the
Thanks for the quick reply. Basically in (3,4,5,6,7,3) the record_id of 3
only exists once in the table my_table. However, because 3 exists twice
within (3,4,5,6,7,3), I want it to return two records for record_id 3. Is
it possible ?
Cheers
Neil
On Tue, Sep 21, 2010 at 4:40 PM, Johan De Meers
If there are two, you will return two.
On Tue, Sep 21, 2010 at 5:33 PM, Tompkins Neil wrote:
> Hi
>
> With a SELECT * FROM my_table WHERE record_id IN (3,4,5,6,7,3), how can I
> return two records for the record_id 3 ? Is it possible ?
>
> Cheers
> Neil
>
--
Bier met grenadyn
Is als mosterd
Hi
With a SELECT * FROM my_table WHERE record_id IN (3,4,5,6,7,3), how can I
return two records for the record_id 3 ? Is it possible ?
Cheers
Neil
things like prize
money, gate receipts etc
Thanks for any help.
Cheers
Neil
Neil,
If you are just starting out with database design, you may get some
ideas from http://www.databaseanswers.org/data_models/
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Thanks for any help.
Cheers
Neil
n_remaining = 0
order by players.teams_id, players_master.rating desc) s1
where rank <= 11
group by teams_id;
-Travis
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Thursday, September 09, 2010 1:58 AM
To: [MySQL]
Subject: Fwd: Query SUM help
Any
On 9/9/2010 3:57 AM, Tompkins Neil wrote:
Any help would be really appreciated ?
-- Forwarded message --
From: Tompkins Neil
Date: Wed, Sep 8, 2010 at 5:30 PM
Subject: Query SUM help
To: "[MySQL]"
Hi
I've the following query :
SELECT total_team_rating, m
301 - 400 of 7359 matches
Mail list logo