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 default since
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
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
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.
well,
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 MySQL(read
Am 30.11.2011 01:11, schrieb Karen Abgarian:
MY only luck is that i recognized this years ago after PLAYING
with innodb and so i started with innodb_file_per_table=1 from
the begin with the first production database
Well, I would not base my database design on luck and playing. There
If the people do not have the knowledge to do exports/imports, the brand new
and cool
file management feature will not help them either. Essentially, the
instructions how to use
that feature are written in the same book as the instructions how to do
export/imports. If we
consider it as given
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:
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
-
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 with it for a
full
day now but I
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 for a single customer_id, so this is not
going
to scale).
Got
; Using where'
Thanks
Neil
On Wed, Oct 5, 2011 at 3:12 AM, Johnny Withers joh...@pixelated.net wrote:
Can you post the explain extended output of your query?
Sent from my iPad
On Oct 4, 2011, at 2:45 PM, Neil Tompkins neil.tompk...@googlemail.com
wrote:
Can anyone help me ?
Begin
...@pixelated.net wrote:
Can you post the explain extended output of your query?
Sent from my iPad
On Oct 4, 2011, at 2:45 PM, Neil Tompkins neil.tompk...@googlemail.com
wrote:
Can anyone help me ?
Begin forwarded message:
From: Tompkins Neil neil.tompk...@googlemail.com
Date: 30 September
Following my mail below, if anyone can help optimise the query further that
would be a great help.
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date: Wed, Oct 5, 2011 at 9:48 AM
Subject: Re: Slow query - please help
To: Johnny Withers joh
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 neil.tompk...@googlemail.com wrote:
Following my mail below, if anyone can help optimise the query further
my iPad
On Oct 5, 2011, at 4:01 AM, Tompkins Neil neil.tompk...@googlemail.com
wrote:
Following my mail below, if anyone can help optimise the query further
that
would be a great help.
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date
Can anyone help me ?
Begin forwarded message:
From: Tompkins Neil neil.tompk...@googlemail.com
Date: 30 September 2011 20:23:47 GMT+01:00
To: mark carson mcar...@pixie.co.za
Cc: [MySQL] mysql@lists.mysql.com
Subject: Re: Slow query - please help
I downloaded version mysql-5.6.2-m5
Can you post the explain extended output of your query?
Sent from my iPad
On Oct 4, 2011, at 2:45 PM, Neil Tompkins neil.tompk...@googlemail.com wrote:
Can anyone help me ?
Begin forwarded message:
From: Tompkins Neil neil.tompk...@googlemail.com
Date: 30 September 2011 20:23:47 GMT
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
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
--
Mark Carson
Managing
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
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
may contain
: 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 information that is PRIVILEGED and CONFIDENTIAL.
If you are not the intended recipient
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 cbr...@bmi.commailto:cbr...@bmi.com
wrote:
Hello All ~ I attempted
I could be wrong but I think your problem is the unique index.
--
João Cândido de Souza Neto
robert rottermann rob...@redcor.ch 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
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
, 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 ave...@yahoo-inc.com wrote:
From: Aveek Misra ave...@yahoo-inc.com
Subject: Help with a query
To: mysql@lists.mysql.com mysql@lists.mysql.com
Date
and
tmp.digest = C.digest);
--Anupam
--- On Tue, 17/5/11, Aveek Misra
ave...@yahoo-inc.commailto:ave...@yahoo-inc.com wrote:
From: Aveek Misra ave...@yahoo-inc.commailto:ave...@yahoo-inc.com
Subject: Help with a query
To: mysql@lists.mysql.commailto:mysql@lists.mysql.com
mysql
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 (
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),
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
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=2607 and
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
8871
On 2011-03-15 18:51, LAMP wrote:
Hi,
I need a help to build a query.
Let's
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,
`org_id` int,
) ENGINE=MyISAM
item_idorg_id
342607
342607
341520
362607
361520
36
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
distinct records until
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,
`org_id` int,
) ENGINE
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,
`org_id` int,
) ENGINE=MyISAM
item_idorg_id
342607
342607
341520
36
?
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,
`org_id` int,
) ENGINE=MyISAM
item_idorg_id
342607
342607
34
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
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
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
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
3815
385
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
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 that case
/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 that one the query runs
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. for
some
`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
weird is that is the only thing
`),
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
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 that one
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)
ApptDateTime
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
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
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
-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
I want to extract all records from this table in which a user has
...@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
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
...@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 ?
On Wed, Mar 2, 2011 at 2:49 PM, Jerry
*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
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
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
...@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 doing
...@hotmail.com wrote:
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
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, 2010-11-14
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
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 map1
On Tue, 1 Feb 2011 14:46:39 -0400
Paul Halliday paul.halli...@gmail.com 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
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
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
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 just passing the date (without
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
sq...@dahl-stamnes.netwrote:
Jørn
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
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 looking to pull records from Midnight to midnight
Thank you, that did the trick.
Simon
On 11 January 2011 12:09, Steve Meyers steve-mysql-l...@spamwiz.com 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 =
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
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
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.
InnoDB: Reading tablespace
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
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-character-set=UTF8 -u
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 Ressources Informatiques
Institut Francais de
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
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,
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`
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 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 vegiv...@tuxera.bewrote:
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
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, but
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 players
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 =
I wondered if anyone can help me ? Do you need any further information ?
Cheers
Neil
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date: Thu, Sep 23, 2010 at 9:49 AM
Subject: Query help please
To: [MySQL] mysql@lists.mysql.com
Hi all,
I've
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
If there are two, you will return two.
On Tue, Sep 21, 2010 at 5:33 PM, Tompkins Neil neil.tompk...@googlemail.com
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
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
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 neil.tompk...@googlemail.com
wrote:
Thanks for the quick reply. Basically in (3,4,5,6,7,3) the record_id of
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 vegiv...@tuxera.bewrote:
I don't think that'll work, no. Why would you want to return duplicate data
? The
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
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
-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 from a
table. I think
be 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
Any help would be really appreciated ?
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date: Wed, Sep 8, 2010 at 5:30 PM
Subject: Query SUM help
To: [MySQL] mysql@lists.mysql.com
Hi
I've the following query :
SELECT total_team_rating, my_teams_id
did u try to use LIMIT after ORDER BY
On Thu, Sep 9, 2010 at 1:27 PM, Tompkins Neil
neil.tompk...@googlemail.comwrote:
Any help would be really appreciated ?
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date: Wed, Sep 8, 2010 at 5:30 PM
PM, Tompkins Neil
neil.tompk...@googlemail.com wrote:
Any help would be really appreciated ?
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date: Wed, Sep 8, 2010 at 5:30 PM
Subject: Query SUM help
To: [MySQL] mysql@lists.mysql.com
Hi
I've
301 - 400 of 7035 matches
Mail list logo