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
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
I'm looking at a situation I haven't run into before, and I'm a bit
puzzled by it.
I have this table structure:
Table USERS: userid, class
Table OBJECT: userid, class, result
Now I want to query the database for a certain user's result in a
specified class, which is very, very easy. No
On Dec 11, 2007 8:38 AM, Anders Norrbring [EMAIL PROTECTED] wrote:
I'm looking at a situation I haven't run into before, and I'm a bit
puzzled by it.
I have this table structure:
Table USERS: userid, class
Table OBJECT: userid, class, result
Now I want to query the database for a certain
On Dec 11, 2007, at 10:46 AM, Rob Wultsch wrote:
On Dec 11, 2007 8:38 AM, Anders Norrbring [EMAIL PROTECTED] wrote:
I'm looking at a situation I haven't run into before, and I'm a bit
puzzled by it.
I have this table structure:
Table USERS: userid, class
Table OBJECT: userid, class, result
Anders,
I also want to find out the user's position relative to others
depending on the result.
For a given pUserID, something like this?
SELECT userid,result,rank
FROM (
SELECT o1.userid,o1.result,COUNT(o2.result) AS rank
FROM object o1
JOIN object o2 ON o1.result o2.result OR
This should work
DELETE Item FROM Item,ItemTag WHERE Item.ProductID =ItemTag.ItemID AND
ItemTag.TagID = '168'
Mark Kelly wrote:
Hi
I want to delete from the 'Item' table all the items identified by the
folowing query:
SELECT
Item.ProductID
FROM
Item, ItemTag
WHERE
Hi.
On Thursday 05 July 2007 17:35, you wrote:
I want to delete from the 'Item' table
all the items identified by the folowing query:
If you have MySQL 5+, you can do it using a sub-query:
DELETE FROM
Item
WHERE
ProductID IN (
SELECT
Item.ProductID
FROM
Item, ItemTag
Hi
I want to delete from the 'Item' table all the items identified by the
folowing query:
SELECT
Item.ProductID
FROM
Item, ItemTag
WHERE
ItemTag.TagID = '168'
AND
ItemTag.ItemID = Item.ProductID;
but I'm not sure how to go about it. Can anyone help?
Thanks
Mark
--
I want to delete from the 'Item' table
all the items identified by the folowing query:
If you have MySQL 5+, you can do it using a sub-query:
DELETE FROM
Item
WHERE
ProductID IN (
SELECT
Item.ProductID
FROM
Item, ItemTag
WHERE
ItemTag.TagID = '168'
AND
The following query should work if I understand what you're attempting
correctly. Use at your own risk though ;)
DELETE FROM Item USING Item, ItemTag WHERE ItemTag.ItemID =
Item.ProductID AND ItemTag.TagID = '168';
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Thanks a bunch for the suggested workaround. This method was exactly
what I was looking for.
Thanks again.
CL
At 01:33 AM 6/20/2007, Ananda Kumar wrote:
One possible way is to spool the contents of bin-log into a file.
mysqlbinlog oca-bin.000554 binlog_sql.sql.
This will give you all the
Guys,
I'm attempting to reapply a number of bin-log files in a effort to
restore all changes that was made to a database. I'm performing the
following command, but continue to get a foreign key constraint error
message when doing so. Has anyone ever ran into this issue, and if
so, what is a
One possible way is to spool the contents of bin-log into a file.
mysqlbinlog oca-bin.000554 binlog_sql.sql.
This will give you all the data present in oca-bin.000554. Then you can set
the
foreign key check to 0 at the session level and then apply the
binlog_sql.sql.
Comment our everything
I'm having problems getting a monitoring script to run.
I've put the troublesome bit in a separate script just to test, and it goes
like this:
declare -a HNdeclares the array HN
HN=(`echo SELECT url FROM hosts | mysql --user=netmon --password=n3tm0n
--skip-column-names
I would look at the 15th URL to see if there are specials in there that are
breaking the hash somehow.
On 5/22/07, Ben Benson [EMAIL PROTECTED] wrote:
I'm having problems getting a monitoring script to run.
I've put the troublesome bit in a separate script just to test, and it
goes
like
We recently switched to mysql5 and while we were at it we also changed
our logs from text to bin as suggested by the migration script we had
(probably created by debian people).
Now I unfortunately had to reconstruct what had happened during a faulty
run of our application and I could not get
Fionn Behrens wrote:
We recently switched to mysql5 and while we were at it we also changed
our logs from text to bin as suggested by the migration script we had
(probably created by debian people).
Now I unfortunately had to reconstruct what had happened during a faulty
run of our application
On Do, 2007-04-19 at 13:57 -0400, Jay Pipes wrote:
You can have both, AFAIK. The general query log keeps all queries,
including SELECTs. Binlog only has data-modifying queries.
Thanks very much for your answer.
Maybe the fact that binlogs apparently are quite different from normal
text
Fionn Behrens wrote:
On Do, 2007-04-19 at 13:57 -0400, Jay Pipes wrote:
You can have both, AFAIK. The general query log keeps all queries,
including SELECTs. Binlog only has data-modifying queries.
Thanks very much for your answer.
Maybe the fact that binlogs apparently are quite
Dear List,
As recently as last Sunday January 14, 2007, we have enabled
replication between two servers in our organization.
The master server runs MySQL 4.1.10a, the slave runs 5.0.18.
Since then, we have had a number of interruptions in replication when
the slave server stopped replicating
I've developed several job tracking applications here at my job.
One of them relies heavily on a series of date stamps in the main table.
Each job has about 6 milestones, each with a respective sibling
column in the same table. The first sibling reflects the job's
predicted date milestone and
I am not able to install Mysql on my 2003 server at home.
error 1045!!
I get an accesd denied for user [EMAIL PROTECTED]
my firewall is off and I know it is not the port becuase when I configure it
as 'anonymous it works like a charm. Please help me
I am not able to install Mysql on my 2003 server at home.
error 1045!!
I get an accesd denied for user [EMAIL PROTECTED]
I need the full error, but have some questions:
1. Are you sure that you set a root password?
2. Are you using the command line client or some other administrative tool?
Hi,
I have the following Query and Im a lil lost on this one
SELECT DISTINCT tbe_orders.order_id, tbe_orders.order_date,
tbe_orders.order_piececount
FROM tbe_orders
The query produces the following results:
+++
+ order_id + order_date +
At 18:51 9.7.2006, you wrote:
Hi,
I have the following Query and Im a lil lost on this one
SELECT DISTINCT tbe_orders.order_id, tbe_orders.order_date,
tbe_orders.order_piececount
FROM tbe_orders
SELECT tbe_orders.order_id,
tbe_orders.order_date, sum(tbe_orders.order_piececount)
FROM
m i l e s wrote:
Hi,
I have the following Query and Im a lil lost on this one
SELECT DISTINCT tbe_orders.order_id, tbe_orders.order_date,
tbe_orders.order_piececount
FROM tbe_orders
The query produces the following results:
+++
+ order_id +
I am using MySql 5.0.21-community Edition for widows XP. I can successfully
connect to the MySql Server as a root and create a database 'a'. Which creates
a directory 'a' under my mysql\data directory with a single file 'db.opt'. Now
dropping the database 'a' gives the following error
ERROR
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/crashing.html
If you feel that there are too much sockets in a TIME_WAIT have a look here:
http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html
Logg, Connie A. wrote:
Two days ago, a system that has been running
Two days ago, a system that has been running fine started crashing...It could
be for a variety of reasons which I am researchinig. However (running mysql
5.0.18) I notice the following from netstat:
tcp0 0 iepm-bw.slac.stanford.:1000 iepm-bw.slac.stanford:38672
ESTABLISHED
tcp
No I don't think this indicates orphaned sockets, having many sockets for
mysql in the state TIME_WAIT state is quite normal, as a socket has to be
created for every connection and once a connection is established the socket
goes into a TIME_WAIT state( i am not sure for how long though), the
* Rick Dwyer [EMAIL PROTECTED] [2005-12-13 18:21 +0100]:
I made a major mistake with MySQL 4.1.x. While using Navicatt I
dropped my database when I meant to drop a table. Other than backups
which are not that up to date, is there an undo?
If your mysqld writes binlogs (see
I made a major mistake with MySQL 4.1.x. While using Navicatt I
dropped my database when I meant to drop a table. Other than backups
which are not that up to date, is there an undo?
Help here is greatly appreciated.
Thanks, I'm desperate.
Rick
--
MySQL General Mailing List
For list
Hello.
If you database contained MyISAM tables, you should prevent any access
to the partition (or logical disk in Windows) and recover deleted files
(*.MYI, *.MYD, *.frm). I'm not sure what to do with InnoDB tablespace
(not per-file), but certainly you should shutdown MySQL and copy ibdata
On Wed, Oct 05, 2005 at 11:23:00AM -0700, Mike Wexler wrote:
Jim Seymour wrote:
I have researched repeatedly and cannot find an answer to the following. I
need to do something like the following (There is probably an easier
way).
end_date - start_date = diff / start_date = return for
I have researched repeatedly and cannot find an answer to the following. I
need to do something like the following (There is probably an easier
way).
end_date - start_date = diff / start_date = return for period
The table contains 401k investment values. Ideas, pointers, etc.? I am using
mysql
Jim Seymour wrote:
I have researched repeatedly and cannot find an answer to the following. I
need to do something like the following (There is probably an easier
way).
end_date - start_date = diff / start_date = return for period
The table contains 401k investment values. Ideas, pointers,
Hi,
I have two simple tables:
CREATE TABLE `new_stations` (
`CD` char(3) default '',
`STATION` varchar(17) default NULL,
`ICAO` varchar(4) NOT NULL default '',
`IATA` varchar(4) default '',
`SYNOP` varchar(7) default '',
`LAT` varchar(6) default '',
`LON` varchar(7) default '',
Hello.
/usr/local/mysql/libexec/mysqld: Out of memory (Needed 32704 bytes)
/usr/local/mysql/libexec/mysqld: Can't read dir of '/var/tmp/' (Errcode: 11)
/usr/local/mysql/libexec/mysqld: Out of memory (Needed 8156 bytes)
Decrease your memory related variables. You have rather old versions
Hi all
a few days a go i have troubles with mysql, the service stops and this is on
two boxes wiht diferents OS. The first one is a FreeBSD 5.3-RELEASE on a
sparc64 the mysql Version is '4.1.5-gamma' and i got this messages in my
logs:
050816 17:11:06 mysqld restarted
Fatal error 'gc cannot
Hello.
4.0.17 is old enough. You may switch to the debug version and attempt to
find the clues in debug or trace files. Can you reproduce an error on the
latest release (4.1.9 now)? Do you lost connection to the server with
other statements, than 'SHOW DATABASES'? Please answer on this
Hello.
Does the problem remain? What is in the error log? Please, send
us information about MySQL and operating system versions. There are
two variables: max_allowed_packet - one has client, another has server.
Run mysql with --max_allowed_packet=16M and mysqld with the same value.
May be
and mysqld with the same value.
May be you have some ulimits which cause such behaviour?
-Message d'origine-
De : Marois, David
Envoyé : 2 février, 2005 09:16
À : 'mysql@lists.mysql.com'
Objet : Re: help please : ERROR 2006: MySQL server has gone away
And
max_allowed_packet = 16776192
some ulimits which cause such behaviour?
-Message d'origine-
De : Marois, David
Envoy : 2 fvrier, 2005 09:16
: 'mysql@lists.mysql.com'
Objet : Re: help please : ERROR 2006: MySQL server has gone away
And
max_allowed_packet = 16776192
David
Hi,
my
access to write into my errorlog file
and in my directories.
David
David Marois
-Message d'origine-
De : Michael Dykman [mailto:[EMAIL PROTECTED]
Envoyé : 3 février, 2005 10:02
À : Marois, David
Cc : MySQL List
Objet : Re: help please : ERROR 2006: MySQL server has gone away
So far, you
Hello.
What's the value of the interactive_timeout system variable? See:
http://dev.mysql.com/doc/mysql/en/server-system-variables.html
http://dev.mysql.com/doc/mysql/en/gone-away.html
Marois, David [EMAIL PROTECTED] wrote:
[-- text/plain, encoding 7bit, charset: iso-8859-1, 19
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: woensdag 2 februari 2005 12:46
To: mysql@lists.mysql.com
Subject: Re: help please : ERROR 2006: MySQL server has gone away
Hello.
What's the value of the interactive_timeout system variable? See:
http
Hello.
I've asked you about interactive_timeout, not wait_timeout.
Mark [EMAIL PROTECTED] wrote:
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: woensdag 2 februari 2005 12:46
To: mysql@lists.mysql.com
Subject: Re: help please : ERROR 2006: MySQL
2 februari 2005 12:46
To: [EMAIL PROTECTED]
Subject: Re: help please : ERROR 2006: MySQL server has gone away
Hello.
What's the value of the interactive_timeout system variable? See:
http://dev.mysql.com/doc/mysql/en/server-system-variables.html
http://dev.mysql.com/doc/mysql/en/gone
Paharenko [mailto:[EMAIL PROTECTED]
Sent: woensdag 2 februari 2005 12:46
To: [EMAIL PROTECTED]
Subject: Re: help please : ERROR 2006: MySQL server has gone away
Hello.
What's the value of the interactive_timeout system variable? See:
http://dev.mysql.com/doc/mysql/en/server-system
Hi,
I have this error when I am connected in mysql:
ERROR 2006: MySQL server has gone away. No connection. Trying to reconnect...
I only did this command: show databases;
and received the error.
I noticed that if I don't send a command since 25 sec, I have the error.
Also, my variable
Hello.
You can enable logging on the server. See:
http://dev.mysql.com/doc/mysql/en/log-files.html
You need the error log, query log, slow log. But be careful!
Heavy loaded server can produce a lot of messages and your
files will grow quickly. If you use InnoDB, you can enable
the
I have a mysql server running on WIN-XP (in a critical
health area) and it started to give me that error.
At first, the problem ocurred in a machine and then
started to scatter all over the system. On Saturday I
reset the Server Machine and the problem disapeared.
But today applications started
Hello.
I have a subroutine which checks for multiple entries and if a user has
voted once in the same day, it will not calculate the vote. However, I
found out that it does not really do this.
What it does is only look at the last entry. If the user IP address is
the last entry it does not
On Tue, 14 Sep 2004 19:55:42 -0700, Soheil Shaghaghi [EMAIL PROTECTED] wrote:
I have a subroutine which checks for multiple entries and if a user has
voted once in the same day, it will not calculate the vote. However, I
found out that it does not really do this.
What it does is only look at
Thank you very much. I really appreciate your analogy to the waterfall.
This helped me out tremendously. I was able to sort out the problem and
all is now well! It appears that this wonderful little GUI tool the
lets you create ER diagrams that auto-generate CREATE scripts assumes
that you
I'm a total newbie to mySQL, but was hoping someone could answer a
question regarding adding a record into a database that has foreign key
constraints. Remember, I'm a total newbie so I'm hoping I'm using the
right words to express this. I'm taking a class that required us to use
an ER
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 11:01 PM
To: Justin Crone
Cc: [EMAIL PROTECTED]
Subject: Re: Some BLOB help please.
Justin Crone wrote:
snip
So as I said, I am rather pleased with the performance and the ease at
which I was able to get this up and running. However
[EMAIL PROTECTED] wrote:
You might save some space if you compress() before storing. Depending on
file content I'm seeing 0-50% savings?
Good idea, but note that COMPRESS() and UNCOMPRESS() weren't introduced
until MySQL 4.1.1.
With earlier versions you may be able to compress and uncompress in
Hello All,
I have been reading hundreds of posts and sites for information
regarding BLOBs in MySQL. So far I have not found an answer to my
question, so I pose it to you fine people. :)
A little background first. I have a web server that uses PHP to retrieve
documents in PDF format for
Justin Crone wrote:
snip
So as I said, I am rather pleased with the performance and the ease at
which I was able to get this up and running. However The problem is
I do have limits, and one of those being disk space. Those 10,000 files
are taking up 21 GB of space in the database. However
Fax to:
Subject: RE: JOINing complication,
help please
CONTACT_X_CUSTOMER.ID_ADDRESS
CUSTOMER.ID_ADDRESS_SHIPTO
CUSTOMER.ID_ADDRESS_MAIN
What I would like is to be able to JOIN conditionally based on the absence/presence of
reference
SELECT ADDRESS.ID FROM CONTACT_X_CUSTOMER LEFT JOIN CUSTOMER ON
CONTACT_X_CUSTOMER.ID_CUSTOMER = CUSTOMER.ID
Ok, I got a result here, still trying to determine if its correct or not :)
LEFT JOIN ADDRESS ON IF(CONTACT_X_CUSTOMER.ID_ADDRESS 0,
CONTACT_X_CUSTOMER.ID_ADDRESS = ADDRESS.ID, IF(CUSTOMER.ID_ADDRESS_SHIPTO 0,
CUSTOMER.ID_ADDRESS_SHIPTO = ADDRESS.ID, CUSTOMER.ID_ADDRESS_MAIN = ADDRESS.ID))
:
Fax to:
06/02/2004 10:46 AM Subject: JOINing complication, help
please
cc: MYSQL-List (E-mail) [EMAIL
PROTECTED]
AM Fax to:
Subject: Re: JOINing complication,
help please
for that big spew of SQL )
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 02, 2004 11:37 AM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: Re: JOINing complication, help please
Sorry to reply to myslef but I just saw my own typo. Here is a better
example
Oops, that LEFT JOIN ADDRESS ON IF(etc...) shouldn't be in the big long select
statement
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Tue, May 18, 2004 at 10:08:32AM -0400, Ronnie Regev wrote:
Hi,
Before I go on, I know nothing about mysql, but my db admin is out of town
and I need to be pointed in the right direction please.
Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual
hosting environment
Hi,
Before I go on, I know nothing about mysql, but my db admin is out of town
and I need to be pointed in the right direction please.
Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual
hosting environment on Ensim webppliance-3.5.20-7.
When using phpMyAdmin and
Ronnie Regev [EMAIL PROTECTED] wrote:
Hi,
Before I go on, I know nothing about mysql, but my db admin is out of town
and I need to be pointed in the right direction please.
Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual
hosting environment on Ensim
.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 8:44 AM
To: Knepley, Jim
Cc: [EMAIL PROTECTED]
Subject: RE: Null-safe equal help, please
Please reply to the list so that others can follow this discussion.
Thanks.
At 8:26 -0700 12/17/03, Knepley, Jim
equal help, please
At 15:22 -0700 12/16/03, Knepley, Jim wrote:
I've got a WHERE clause:
WHERE possibly_null_value IS NULL
That works fine. This null-safe equal doesn't do what I expect:
WHERE possibly_null_value = NULL
The manual, and my testing, shows that NULL = NULL evaluates to 1,
so
Are you
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 5:44 PM
To: Knepley, Jim; [EMAIL PROTECTED]
Subject: Re: Null-safe equal help, please
At 15:22 -0700 12/16/03, Knepley, Jim wrote:
I've got a WHERE clause:
WHERE possibly_null_value IS NULL
I've got a WHERE clause:
WHERE possibly_null_value IS NULL
That works fine. This null-safe equal doesn't do what I expect:
WHERE possibly_null_value = NULL
The manual, and my testing, shows that NULL = NULL evaluates to 1, so
my now-fevered mind sees no reason the two above statements are not
At 15:22 -0700 12/16/03, Knepley, Jim wrote:
I've got a WHERE clause:
WHERE possibly_null_value IS NULL
That works fine. This null-safe equal doesn't do what I expect:
WHERE possibly_null_value = NULL
The manual, and my testing, shows that NULL = NULL evaluates to 1, so
Are you saying that this is
Yup that worked -
I rebooted my machine - and I was allowed in -
Thank you very much
Andrew
-Original Message-
From: Brian Snyder [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 3:30 PM
Cc: MySQL
Subject: Re: Upgrading help please
Andrew,
I had the same problem and had
Good day List,
I have just upgraded from 3.23 -4.0.16
I downloaded all the RPM's and then ran
rpm -U *.rpm
It did all that it was supposed to do, and then told me to use the
/usr/bin/mysql_fix_privilege_tables script
which I did got horrid errors
ERROR 2002: Can't connect to local MySQL server
Andrew,
I had the same problem and had to stop and restart the servers. Give
that a shot.
brian
On Wed, 2003-11-05 at 17:19, Andrew wrote:
Good day List,
I have just upgraded from 3.23 -4.0.16
I downloaded all the RPM's and then ran
rpm -U *.rpm
It did all that it was supposed to do,
SQL guru's,
I could use some help writing a bit of SQL.
There's 3 tables:
orderable_parts
partID varchar,
topCatID int, # top level category ID
...
part_attributes
partID varchar,
attName varchar,
attValue varchar,
...
topcatattributevalues
tcavID int,
topCatID int,
attName varchar,
attValue
Hi,
this is the weirdest error I have ever encountered.
We get an error 2013 lost connection when we try to connect via mysql to
another machine having mysql on it as well. The weird part is that when
we change the IP address of the connecting machine to another service
provider it works
]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 09, 2003 11:50 AM
Subject: HELP PLEASE the weirdest error 2013 / connection ?
Hi,
this is the weirdest error I have ever encountered.
We get an error 2013 lost connection when we try to connect via mysql to
another machine having mysql on it as well
When I execute the following query I get duplicate product_id's as shown
below:
SELECT * FROM product, product_category_xref, category WHERE
product_parent_id=''
AND product.product_id=product_category_xref.product_id
AND category.category_id=product_category_xref.category_id
AND
When I execute the following query I get duplicate
product_id's as shown
below:
SELECT * FROM product, product_category_xref, category WHERE
product_parent_id=''
AND product.product_id=product_category_xref.product_id
AND category.category_id=product_category_xref.category_id
AND
All,
I have a query that is inner joined with another table based on country codes
Select distinct Name.* from Name inner join Location on Location.key =
Name.key and Location.cc in ('list of countries here');
The problem is when I have more than 2 country codes, the query takes forever...
When
* Twibell, Cory L
I have a query that is inner joined with another table based on
country codes
Select distinct Name.* from Name inner join Location on Location.key =
Name.key and Location.cc in ('list of countries here');
The problem is when I have more than 2 country codes, the query
PROTECTED]
Cc: Twibell, Cory L [EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 7:19 PM
Subject: Re: Table Query taking WAY TO LONG...HELP PLEASE!!!
* Twibell, Cory L
I have a query that is inner joined with another table based on
country codes
Select distinct Name.* from Name inner join
On Tue, Aug 26, 2003 at 07:38:04PM -0600, Twibell, Cory L wrote:
All,
I have a query that is inner joined with another table based on
country codes Select distinct Name.* from Name inner join Location
on Location.key = Name.key and Location.cc in ('list of countries
here');
The problem
On 26 Aug 2003 at 19:38, Twibell, Cory L wrote:
I have a query that is inner joined with another table based on
country codes Select distinct Name.* from Name inner join Location on
Location.key = Name.key and Location.cc in ('list of countries
here');
From the message you're getting it
|
It looks like it's using the correct indicesI don't know what else
to do...
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 12:23 AM
To: Twibell, Cory L
Cc: [EMAIL PROTECTED]
Subject: Re: Table Query taking WAY TO LONG...HELP PLEASE
Hi
I have purchased a package that uses ASP and SQL, my webhost provides MYSQL
and I have loaded my access database and all seems to be working fine.
Except the stored procedures (Queries) the webhost says MYSQL doesn't support
stored procedures, as this site confirms (wait for v5.0) but
Hi people.
Installing MySQL 3.23.54 under Windows 2000
(according to instructions in Next handbook 'Introduction to MySQL.', and
from CD attached to book)
Installing MySQL
- worked fine.
Starting the Server
c:\mysql\bin\mysqld-nt
- worked fine.
Running the MySQL command line interface
I have two tables;
TESTtblRC
++++-+
| id | npanxx | RCname | RCstate |
++++-+
| 1 | 11 | ONE| CA |
| 2 | 22 | ONE| CA |
| 3 | 33 | ONE| CA |
| 4 | 44 | TWO| CA |
| 5 | 55 | TWO|
Tried for the second time to install mysql on my mac and again a
problem during the install related to the password.
I typed in
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
and changed 'new-password' to the password I wanted.
Got the --
on the next line but nothing else so
: katherine bjork [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 3:02 PM
To: mysql
Subject: mysql install---help please
Tried for the second time to install mysql on my mac and again a
problem during the install related to the password.
I typed in
/usr/local/mysql/bin/mysqladmin -u root password
bjork; mysql
Subject: RE: mysql install---help please
You said that you changed the password to the password you wanted, but in
all the examples you are trying to access the server without a password.
Try using the -p flag so it prompts you for your password, then type in
whatever you set
1 - 100 of 244 matches
Mail list logo