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
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
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 (o1.resu
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
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
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 proble
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
ItemTag.
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
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
> It
> 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
ItemTag.Ite
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
--
My
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 d
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
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 p
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
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
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 different
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 lo
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 a
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 any
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 f
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 an
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?
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
---
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 +
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 t
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 + ord
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 10
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 f
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 'show
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
* 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 "log-bin"-di
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
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 archive
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 = retu
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, etc
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 v5
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 '',
`E
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 versio
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 wai
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 questi
d my mysql user have 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
max_allowed_packet - one has client, another has server.
> Run mysql with --max_allowed_packet=16M 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
h --max_allowed_packet=16M 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 ser
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 yo
sage-
>> From: Gleb 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 inter
L 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:
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
> -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 interact
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
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 wait_
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 InnoD
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 to
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
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 calculat
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 won'
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 diagramm
[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 yo
---
From: Michael Stassen [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:
>
> So as I said, I am rather pleased with the performance and the ease at
> which I was able t
Justin Crone wrote:
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 the ac
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 viewing
would
assume that if a record exists in CONTACT_X_CUSTOMER then there would be
corresponding records in both of those tables.
I know this has been a huge post but you
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]
D, IF(CUSTOMER.ID_ADDRESS_SHIPTO > 0,
CUSTOMER.ID_ADDRESS_SHIPTO = ADDRESS.ID, CUSTOMER.ID_ADDRESS_MAIN = ADDRESS.ID)
This actually worked great, I only had to refer to ADDRESS once in the select for
output, I only had to join the other tables CITY, PROVINCE, COUNTRY once on ADDRESS
too.
BUT
06/02/2004 11:31 cc: "MYSQL-List (E-mail)" <[EMAIL
PROTECTED]>
AM Fax to:
Subjec
D]>
-magic.com> cc:
Fax to:
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))
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
(that
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 environm
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 10:16 AM
To: [EMAIL PROTECTED]
Subject: Re: Unknown error, urgent help please
"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 t
"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 webppli
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 attempting
LL
...returns tens of thousands of records.
-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
-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 possi
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 evalu
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
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 n
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
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
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
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 varc
gt;
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
>
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 fin
> 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 product.product_p
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 PLEA
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 (' here>');
>From the message you're getting it seems you're using
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 (' here>');
>
> The problem is when I ha
AIL PROTECTED]>
To: <[EMAIL 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
* 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 ('');
>
> The problem is when I have more than 2 country codes, the query
> takes forever..
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 ('');
The problem is when I have more than 2 country codes, the query takes forever...
When I show processlist, it
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 th
automatically. It will then minimize
itself on your toolbar as an icon. You can accessed it from there to
turn the service on/off
-Original Message-
From: Huw Parker [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 1:56 PM
To: [EMAIL PROTECTED]
Subject: Help please
Hi people
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
c:\mysql\
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|
]
Sent: Tuesday, March 25, 2003 4:13 PM
To: Black, Kelly W [PCS]
Subject: Re: mysql install---help please
I typed in
/usr/local/mysql/bin/mysql -u userid -p -h localhost password:
prompted for password, gave only one I ever use
response was
ERROR 1045: Access denied for user: '[EMAIL PROT
1 - 100 of 256 matches
Mail list logo
