gerald_clark wrote:
How many possible values may res_status have? What percentage for
each value? It may not be possible to use an index on this field.
The res_status field may have up to 10 different values from 0-9. and
there will be a huge amounts of '0' and thousands of records with 1-9
Cory at SkyVantage wrote:
gerald_clark wrote:
How many possible values may res_status have? What percentage for
each value? It may not be possible to use an index on this field.
The res_status field may have up to 10 different values from 0-9. and
there will be a huge amounts of '0' and
Cory at SkyVantage [EMAIL PROTECTED] wrote on 03/10/2006 04:25:00 PM:
[EMAIL PROTECTED] wrote:
Can you post the results of SHOW CREATE TABLE pnr_segments, please
pnr_segments | CREATE TABLE `pnr_segments` (
`ID` bigint(20) NOT NULL auto_increment,
`ID_pnr` bigint(20) NOT NULL,
- Original Message -
From: Søren Merser [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday, March 05, 2006 9:12 AM
Subject: Help on sql statement (not MySQL specifik)
Hi
Could someone please help me out here?
TABLE:
RECNO| ID |TYPE
I think he wants to update rows where != 4 to null
that is, update TYPE setting TYPE to null where TYPE != 4
-Ron
Rhino wrote:
- Original Message - From: Søren Merser [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday, March 05, 2006 9:12 AM
Subject: Help on sql statement (not
Hi, I'll try
I need one record for each id in the tabel, i.e. NO duplicate id's with TYPE
set to 4 or NULL
Now, the TYPE of id 2 is 4 so I peserve it;
As id 2 has more than one entry I have to delete it/them
Id's with TYPE = NULL (id 1,4,5)is kept
Id 5 (and 6) has two records, none of which
Søren Merser wrote:
Hi, I'll try
I need one record for each id in the tabel, i.e. NO duplicate id's with
TYPE set to 4 or NULL
Now, the TYPE of id 2 is 4 so I peserve it;
As id 2 has more than one entry I have to delete it/them
Id's with TYPE = NULL (id 1,4,5)is kept
Id 5 (and 6) has two
that if the value of the type is 4, leave it
alone, otherwise display null.
--
Rhino
- Original Message -
From: Søren Merser [EMAIL PROTECTED]
To: mysql@lists.mysql.com; Rhino [EMAIL PROTECTED]
Sent: Sunday, March 05, 2006 11:46 AM
Subject: Re: Help on sql statement (not MySQL specifik
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: Søren Merser [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Sunday, March 05, 2006 1:13 PM
Subject: Re: Help on sql statement (not MySQL specifik)
Søren Merser wrote:
Hi, I'll try
I need one record for each id
Rhino wrote:
I don't really understand _why_ you want to do this but here is a query
that gives the result you want:
select id, case type when 4 then 4 else null end as type
from Soren01
group by id;
The GROUP BY ensures that you get one row for each value of id; the case
expression in the
to start with.
In any case, thanks for keeping me honest.
--
Rhino
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: Søren Merser [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Sunday, March 05, 2006 2:26 PM
Subject: Re: Help on sql statement
: Søren Merser [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Sunday, March 05, 2006 9:05 PM
Subject: Re: Help on sql statement (not MySQL specifik)
You're absolutely right that I'd need some good luck for this query to
work for every possible data value that the table could continue.
I realized
]
To: Michael Stassen [EMAIL PROTECTED]
Cc: Søren Merser [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Sunday, March 05, 2006 9:05 PM
Subject: Re: Help on sql statement (not MySQL specifik)
You're absolutely right that I'd need some good luck for this query to
work for every possible data value
It would be easier to answer a specific question
--
Rhino
- Original Message -
From: Terry Spencer [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday, March 05, 2006 6:41 PM
Subject: -help
Terry Spencer
Haigh Consultancy Services
Tel: +44 (0)116 262 3966
Fax: +44
I'm not sure but the situation you are describing sounds like the so-called
Bill of Materials Problem, sometimes called BOM for short.
I'm certain that some databases provide SQL to handle BOM problems; for
example, DB2 which I know quite well, provides for BOMs. However, I just did
a search
Kishore,
We use Vbulletin for our message boards, and I have a
query which
takes approximately 1.2 - 1.5 seconds to execute, on a table
('thread')
having around 130,000 rows, it is as follows
SELECT threadid
FROM thread
LEFT JOIN deletionlog
ON ( thread.threadid = deletionlog.primaryid AND
Yoed Anis wrote:
Hi all,
I'm trying to do the following.
I have three table:
Table a has address information:
address_id | City | State | Zip
1Austin TX 78758
2 Dallas TX 77000
3 Galveston TX 77550
Table b has information about the location:
address_id | Location_id |
how to achieve this?
select table1.*, table2.*, table3.*, sum(table2.field3), sum(table2.field4)
from table1, table2, table3 where table1.field1 = table2.field1 and
table2.field1 = table3.field1
Your question as formulated has no answer. If you query aggregate
values like Sum on a table, you
Dear Reynier,
You can use JOIN on your both,
The JOIN have to run on the same feilds i.e IDA.
SELECT * FROM carro_de_compras LEFT JOIN os_articulo ON carro_de_compras.IDA
= os_articulo.IDA
This query returns all your users with their articles if any and you can
iterate on it.
but one note:
Use
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
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
pedro mpa [EMAIL PROTECTED] wrote on 01/31/2006 12:49:48 AM:
Greetings.
I need help on the following query.
I get an error like Unknown/Invalid column total_price [...] when I
try
filter by total_price.
How can I do this correctly?
SELECT receipts.*,
(SELECT
this.
--
Rhino
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: Scott Purcell [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Tuesday, January 31, 2006 1:18 AM
Subject: Re: Help Understanding Document Syntax
Rhino wrote:
The 'symbol' you
-
From: Michael Stassen [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: Scott Purcell [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Tuesday, January 31, 2006 1:18 AM
Subject: Re: Help Understanding Document Syntax
Rhino wrote:
The 'symbol' you are referring to, in the foreign key
Rhino wrote:
First and foremost, thank you very much Michael for correcting my
mistakes; I _was_ a bit sloppy in my reading of the syntax for the
statements and that caused some unnecessary errors in my reply to Scott.
However, your corrections are not _quite_ right even now. See below
where
The 'symbol' you are referring to, in the foreign key clause of the CREATE
TABLE statement, is simply an opportunity for you to choose a name for the
foreign key of the table; if you don't choose a name, MySQL will generate a
default name for you.
Therefore, if you do this:
CREATE TABLE
Rhino wrote:
The 'symbol' you are referring to, in the foreign key clause of the
CREATE TABLE statement, is simply an opportunity for you to choose a
name for the foreign key of the table; if you don't choose a name, MySQL
will generate a default name for you.
Therefore, if you do this:
pedro mpa wrote:
Greetings.
I need help on the following query.
I get an error like Unknown/Invalid column total_price [...] when I try
filter by total_price.
How can I do this correctly?
SELECT receipts.*,
(SELECT SUM(receipt_itens.price) FROM receipt_itens WHERE
Hello.
Chris, the collation is subordinated to the character set. You should
work with the character sets, and only after with collations. The data
which you store in your table is silently converted to ascii character
set. Are you sure that the characters which you want to store are
present in
Thank you Gleb,
I'm afraid I'm in over my head on this subject as I am restricted to make db
changes via sql or phpmyadmin.It seem from your references the database
character_set needs to be set to latin? I'm speculating to change
character_sets and collations I need access to other utilites,
Hello.
I do not see the CHARACTER SET of your table (usually SHOW CREATE
includes it, may be you have NO_TABLE_OPTIONS in @@sql_mode), so I
assume it is the same as database character set - ascii. Check if the
problem disappears after changing the character set of your fields to utf8.
Chris
I'm sorry but I do not know what you mean by NO_TABLE_OPTIONS in
@@sql_mode).
The database has a Collation = ascii_general_ci. The only other option is
ascii_bin.
With respect to the table, it also has Collation of the same,
ascii_general_ci. There are many Collation types which the table may
Hello.
Please, execute the following statements in mysql command line and php,
and provide its output to the list:
show variables like '%char%';
show variables like '%collation%';
Include the CREATE statement for your table as well.
Chris wrote:
I think I have a problem with mysql
Sorry, I am unable to work the command line. I have used this script
instead.
$sql = show variables like '%char%';
$result = mysql_query($sql) or die(Couldn't Select .mysql_error());
$count = mysql_num_rows($result);
//echo $count;
while ($row = mysql_fetch_row($result)) foreach($row as
Jay Paulson [EMAIL PROTECTED] wrote on 01/25/2006 10:09:36 AM:
From the result set below I have 22 rows and the only difference is the
date. I was wondering if there was a way to get all of these results
using
GROUP BY instead of having to use LIMIT??
As this table grows I'm going to want
Imran [EMAIL PROTECTED] wrote on 01/18/2006 03:13:08 PM:
Hello All:
I need to join three tables but I am not sure how to structure the
query.
I need to join table1 to table2 and then join table3 to this result set.
So like (table1 join table2) join table3.
Table1 and Table2 will be
Please do not hijack someone elses thread.
]Imran wrote:
Hello All:
I need to join three tables but I am not sure how to structure the query.
I need to join table1 to table2 and then join table3 to this result set.
So like (table1 join table2) join table3.
Table1 and Table2 will be joined
- Original Message -
From: Imran [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, January 18, 2006 3:13 PM
Subject: Help in joining three tables
Hello All:
I need to join three tables but I am not sure how to structure the query.
I need to join table1 to table2 and then
Rhino [EMAIL PROTECTED] wrote on 01/18/2006 03:30:44 PM:
- Original Message -
From: Imran [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, January 18, 2006 3:13 PM
Subject: Help in joining three tables
Hello All:
I need to join three tables but I am not sure
- Original Message -
From: [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: Imran [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Wednesday, January 18, 2006 5:07 PM
Subject: Re: Help in joining three tables
Rhino [EMAIL PROTECTED] wrote on 01/18/2006 03:30:44 PM:
- Original
Agreed. OTOH, I would recommend 4.1.15 until they solve the problem
with updates in 4.1.16 apparently not using index prefixes.
--Pete
On Sun, Jan 15, 2006 at 05:07:08PM +, Jocelyn Fournier wrote:
Hi,
Excepted if he found a bug in an older version of MySQL, it's of course
false ! (it
Hi,
Excepted if he found a bug in an older version of MySQL, it's of course
false ! (it would be a major issue which would make MySQL just unusable)
Regards,
Jocelyn
David Rabinowitz a écrit :
Hi,
We are using MySQL 4.1.16, recently upgraded from 4.0.18. On the old
server we tried not
[EMAIL PROTECTED] wrote on 01/11/2006 02:42:27 PM:
Hi List!
Please forgive me if I'm asking the wrong list (and please guide me to
the right place).
I have two tables (simplified for this example) pics and tags like
so:
pics:
picid photo
1Mustang
2Apple
3Rock
4
Mike,
You're in the right place. If I understand your requirement correctly,
you want entries which...
match on id,
match a selection from ('Mustang' or 'Beetle'),
match multiple values in tags (eg 'red' and 'car').
Here's one solution:
SELECT p.photo, t.tag
FROM pics p
INNER JOIN tags c
On 1/11/06, Gordon Bruce [EMAIL PROTECTED] wrote:
I assume you are looking for both red and car.
You can not use IN because that is implicitly an IN.
You hae to join the tags table to itself using 2 different aliasis.
{If you required 3 things then you would join it 3 times etc..}
SELECT *
[EMAIL PROTECTED] wrote on 01/11/2006 03:53:26 PM:
On 1/11/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote on 01/11/2006 02:42:27 PM:
Hi List!
Please forgive me if I'm asking the wrong list (and please guide me
to
the right place).
I have
Hello.
Usually working with IP addresses in a numeric form is faster. Use
INET_NTOA() and INET_ATON() functions to store IP addresses as unsigned
ints. To work with subnetworks instead of like 'xxx.xxx.%' use
ip_address_in_numeric_form between inet_aton('xxx.xxx.0.0') and
:[EMAIL PROTECTED]
Sent: Fri 1/6/2006 5:28 AM
To: mysql@lists.mysql.com
Subject: Re: Help with a SELECT query
Hello.
Usually working with IP addresses in a numeric form is faster. Use
INET_NTOA() and INET_ATON() functions to store IP addresses as unsigned
ints. To work with subnetworks
Jay Paulson (CE CEN) wrote:
This helps a ton! Thanks! I didn' tknow about the INET_NTOA() or the
INET_ATON() functions. That is much quicker to query on them than on a char set
of ips. However, I did notice on the mysql web site that these functions are
only available in 5.x but the way the page
Hello.
These functions are available in 4.1.16 as well:
mysql select inet_aton('192.168.0.1');
+--+
| inet_aton('192.168.0.1') |
+--+
| 3232235521 |
+--+
1 row in set (0.06 sec)
mysql select
Michael,
thanks for your feedback!
Jay Paulson (CE CEN) wrote:
This helps a ton! Thanks! I didn' tknow about the INET_NTOA() or the
INET_ATON() functions. That is much quicker to query on them than on a
char set
of ips. However, I did notice on the mysql web site that these
functions are
Message-
From: Stefan Hinz [mailto:[EMAIL PROTECTED]
Sent: Fri 1/6/2006 12:40 PM
To: Michael Stassen
Cc: Jay Paulson (CE CEN); Gleb Paharenko; mysql@lists.mysql.com; [EMAIL
PROTECTED]
Subject: Re: Help with a SELECT query
[1] The reasoning behind this: Is it relevant for a 5.0 user to know
@lists.mysql.com; [EMAIL PROTECTED] Subject: Re: Help
with a SELECT query
[1] The reasoning behind this: Is it relevant for a 5.0 user to know
that INET_ATON() was introduced in 3.23.15? We don't think it is,
and many users had complained that the manual was full of clutter
like that.
Regards
.
-Original Message-
From: Caroline Jen [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 05, 2006 10:13 AM
To: Logg, Connie A.
Subject: Re: Help...I am desparate
Is there anything in your PC listening to Port 1000?
It seems that there is a conflict.
--- Logg, Connie A. [EMAIL PROTECTED] wrote
of the road, and 'IF' is
the middle word in life.
-Original Message-
From: Caroline Jen [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 05, 2006 10:13 AM
To: Logg, Connie A.
Subject: Re: Help...I am desparate
Is there anything in your PC listening to Port 1000?
It seems
Hi Connie,
060103 15:54:02 [ERROR] Can't start server: Bind on TCP/IP port:
Permission denied
060103 15:54:02 [ERROR] Do you already have another mysqld server
running on port: 1000 ?
You can't bind to a port less than 1024 unless you're running as root.
I suspect that's the problem here.
@lists.mysql.com
Subject: Re: Help...I am desparate
Hi Connie,
060103 15:54:02 [ERROR] Can't start server: Bind on TCP/IP port:
Permission denied
060103 15:54:02 [ERROR] Do you already have another mysqld server
running on port: 1000 ?
You can't bind to a port less than 1024 unless you're
To: Logg, Connie A. Cc: mysql@lists.mysql.com Subject: Re: Help...I
am desparate
Hi Connie,
060103 15:54:02 [ERROR] Can't start server: Bind on TCP/IP port:
Permission denied
060103 15:54:02 [ERROR] Do you already have another mysqld server
running on port: 1000 ?
You can't bind to a port
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html
Doug Dalton wrote:
I found a log error after turning on warning running the server manually:
051215 17:32:42 [Warning] Aborted connection 3961 to db: 'db' user:
'user' host: `client'
Hello.
Check that MySQL doesn't die during the query. See:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
oug Dalton wrote:
I am running mysql 4.1.13 on Suse 10 and I get an error on a simple
select query, I have checked the threads on lost connection and my
connection
Gleb Paharenko wrote:
Hello.
Check that MySQL doesn't die during the query. See:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
Gleb,
I should mention that I get no log errors and I even have it set to warn
does this mean mysql could die and not log the error? I have gone
Gleb,
I watched the server during this error, the server continued to run...
it didnt crash... and no warning or logged error?
Regards,
Doug
Doug Dalton wrote:
Gleb Paharenko wrote:
Hello.
Check that MySQL doesn't die during the query. See:
I found a log error after turning on warning running the server manually:
051215 17:32:42 [Warning] Aborted connection 3961 to db: 'db' user:
'user' host: `client' (Got timeout reading communication packets)
Any idea what this error is ? the interfaces show no errors from a
network
Hello.
music mysql -u root -p
..
music untz$ mysql music_development db/create.sql
Why haven't you added -uroot -p for you second action ? See:
http://dev.mysql.com/doc/refman/5.0/en/error-access-denied.html
untz wrote:
Hello there!
I am
Nestor,
When I tried this... This is what I got:
mysql use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql delete from user where id='root';
ERROR 1054 (42S22): Unknown column 'id'
Ok, this worked... My question is that is the password for 'root'
supposed to
match the sudo password used to grant super priveleges to the bash user?
I purposely wanted this different and changed my root password on
mysqladmin
to something else... Is it supposed to be the same as the root's
4259 - Fax
-Original Message-
From: untz [mailto:[EMAIL PROTECTED]
Sent: Friday, 2 December 2005 10:09 AM
To: mysql@lists.mysql.com
Subject: Re: Help resetting password on MySQL 5
Ok, this worked... My question is that is the password for 'root'
supposed to
match the sudo password used
Hi,
You can use select group_concat(segfees) from fsf;
The information bellow is from mysql manual, but you have to have mysql
4.1.x
=
*
|GROUP_CONCAT(/|expr|/)|
This function returns a string result with the concatenated
non-|NULL| values from a group. It returns
Thanks for the tip.. Here's the query that worked...
SELECT GROUP_CONCAT(DISTINCT segfees SEPARATOR ',')
from segfees
WHERE ID_flights_segments=[insert value here]
group by ID_flights_segments;
inferno wrote:
Hi,
You can use select group_concat(segfees) from fsf;
The information bellow is from
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 9 November 2005 1:47 PM
To: David Inglis
Cc: mysql@lists.mysql.com
Subject: Re: help with socket setting problem
David Inglis [EMAIL PROTECTED] wrote on 11/08/2005
09:33:27 PM:
I am having the following problem
with the setting
David Inglis [EMAIL PROTECTED] wrote on 11/08/2005
09:33:27 PM:
I am having the following problem
with the setting for socket in the my.cnf configuration file set to
socket=/tmp/mysql.sock I am able to connect through a browser but cannot
connect using the mysql client when I change it
Subject: Re: help with socket setting problem
David Inglis [EMAIL PROTECTED] wrote on 11/08/2005
09:33:27 PM:
I am having the following problem
with the setting for socket in the my.cnf configuration file set to
socket=/tmp/mysql.sock I am able to connect through a browser
Hi Daniel,
Check your permissions. Your mysqld process is probably trying to create
the log file but can't and is telling you via the error code 13 message
$ perror 13
System error: 13 = Permission denied
$
Regards
Daniel C. Mahoney wrote:
I'm running MySQL (--ersion says mysql Ver 14.7
SELECT lat,lon
FROM geocodes
WHERE ip BETWEEN 1173020467 AND 1173020467 ;
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 04, 2005 10:33 PM
To: Brian Dunning
Cc: mysql@lists.mysql.com
Subject: Re: Help optimize this simple find
Brian Dunning
Rhino wrote:
I'm glad the explanation helped. I figured that the solution alone wouldn't
be very useful if it wasn't explained since it is not obvious to most people
how correlated queries work :-)
I really wasn't trying to center you out with my rant about MySQL version.
It's been a
Rhino wrote:
I can't test this in MySQL- I'm using an older version of MySQL that doesn't
support subqueries - but it works in DB2 and it should do the trick for
getting the current weight of each VBS_id value:
select VBS_id, date, weight
from VBS_table x
where date =
(select max(date) from
@lists.mysql.com
Sent: Saturday, November 05, 2005 8:05 AM
Subject: Re: Help with an SQL query
Rhino wrote:
I can't test this in MySQL- I'm using an older version of MySQL that
doesn't
support subqueries - but it works in DB2 and it should do the trick for
getting the current weight of each VBS_id value
Gobi wrote:
Not sure if this is the right place to ask. I have a table, Weight,
with the following test data:
idx VBS_ID DateWeight
11110/3/200511.5
2119/5/2004 10
31110/7/200511.51
41110/8/200511.52
512
Arno Coetzee wrote:
Gobi wrote:
Not sure if this is the right place to ask. I have a table, Weight,
with the following test data:
idx VBS_ID DateWeight
11110/3/200511.5
2119/5/2004 10
31110/7/200511.51
41110/8/2005
Gobi wrote:
Arno Coetzee wrote:
Gobi wrote:
Not sure if this is the right place to ask. I have a table, Weight,
with the following test data:
idx VBS_ID DateWeight
11110/3/200511.5
2119/5/2004 10
31110/7/200511.51
4
Hi Gobi,
there was a similar posting in august.
See:
http://lists.mysql.com/mysql/187436
which I think describes what you want.
I'll include a bit of it here as well
--
This is out of the MySQL class and is called the Max-Concat trick.
Johan Höök wrote:
Hi Gobi,
there was a similar posting in august.
See:
http://lists.mysql.com/mysql/187436
which I think describes what you want.
I'll include a bit of it here as well
--
This is out of the MySQL class and is called the Max-Concat trick.
Johan Höök wrote:
Hi Gobi,
there was a similar posting in august.
See:
http://lists.mysql.com/mysql/187436
which I think describes what you want.
I'll include a bit of it here as well
--
This is out of the MySQL class and is called the Max-Concat trick.
Hi Gobi,
the problem with your original query is that there is no
guarantee that your max(date) and it's associated VBS_ID
is picked, so what you have to ensure is that they get picked
together, so I think your statement should be like this:
SELECT VBS_ID,
SUBSTRING( MAX( CONCAT( LPAD(
Figured out the query:
select idx, vbs_id, date, weight from Weight,
(select vbs_id as maxid, max(date) as maxdate from Weight group by
vbs_id) as t
where vbs_id = maxid and date = maxdate;
It returns the proper weight and idx.
--
MySQL General Mailing List
For list archives:
Brian Dunning [EMAIL PROTECTED] wrote on 11/04/2005 10:36:00 PM:
This simple find is taking 4 to 7 seconds. Way too long!! (This is a
geotargeting query using the database from IP2location.)
select lat,lon from geocodes where ipFROM=1173020467 and
ipTO=1173020467
The database looks
Connie,
The port you have specified (1020) requires root permissions as does any
port 1024 and below. The normal port is 3306. I'm suspecting that your
mysql server installation is configured to run as mysql or some user
other than root. Change the port to something above 1024 and you
Is this what you are looking for:
SELECT clone_ids, COUNT(DISTINCT(gene_ids)) as count_genes
FROM table_name
GROUP BY clone_ids
or
SELECT clone_ids, COUNT(gene_ids) as count_genes
FROM table_name
GROUP BY clone_ids
Hope this helps,
Alvaro
- Original Message -
From: Xiaobo Chen [EMAIL
pedro mpa [EMAIL PROTECTED] wrote on 10/24/2005 06:32:48 PM:
Hi!
I need help on implementing a query that performs a search for items
under
nested categories. An example is on ebay search where you can restrict
your
search by selecting a subcategory and you only get items under that
[EMAIL PROTECTED] wrote on 10/22/2005 06:24:07 PM:
I have a table of votes with four fields, a primary key, and userID,
that are just there for tracking purposes. But then I have
questionID and vote fields. For each question, a user could pick a
number of it's importance from 1 to 5.
ja,
Your question is a little cryptic. If a questionid column value
identifies a particular question, and a vote column value contains a
user's vote (1,2,3, c), can't you just write...
SELECT questionid, vote,count(vote)
FROM ...
GROUP BY questionid, vote
PB
-
[EMAIL PROTECTED] wrote:
Hello.
The start point for you in such kind of problems should be researching
the output of the following statement:
SHOW VARIABLES LIKE '%char%';
Please, run it from different environments (PHP, MySQL Query Browser),
and send results to the list. Include the CREATE statement for you
Shawn,
- Original Message -
From: [EMAIL PROTECTED]
To: Dušan Pavlica
Cc: Michael Stassen ; list mysql
Sent: Wednesday, October 12, 2005 4:45 PM
Subject: Re: Help with query
Dušan Pavlica [EMAIL PROTECTED] wrote on 10/12/2005 10:00:53 AM:
Thanks, Michal, for your
Dušan Pavlica wrote:
Hello,
could someone help me please to construct correct query or tell me what I'm
doing wrong?
I have three tables:
table products
table products_codes where some products could have assigned another additional codes
table products_prices
I want to get all rows from
querries for each DB system separately. Now I see that I will have to.
Dusan
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: Dušan Pavlica [EMAIL PROTECTED]
Cc: list mysql mysql@lists.mysql.com
Sent: Wednesday, October 12, 2005 2:54 PM
Subject: Re: Help with query
Dušan
Sent: Wednesday, October 12, 2005 2:54 PM
Subject: Re: Help with query
Dušan Pavlica wrote:
Hello,
could someone help me please to construct correct query or tell me
what
I'm doing wrong?
snip
Kind regards,
Dusan Pavlica
snip
In any case, does this do what you want
` int(10) default NULL,
PRIMARY KEY (`ID`),
KEY `ProdNo` (`ProdNo`),
KEY `Branch` (`Branch`)
)
- Original Message -
From: [EMAIL PROTECTED]
To: Imran [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, October 10, 2005 4:17 PM
Subject: Re: Help on writing a sql
, October 11, 2005 9:49 AM
Subject: Re: Help on writing a sql statement
(my response bottom-posted. See below - SG)
- Original Message -
From: [EMAIL PROTECTED]
To: Imran [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, October 10, 2005 4:17 PM
Subject: Re: Help on writing
PROTECTED]
To: Imran [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, October 11, 2005 9:49 AM
Subject: Re: Help on writing a sql statement
(my response bottom-posted. See below - SG)
- Original Message -
From: [EMAIL PROTECTED]
To: Imran [EMAIL PROTECTED]
Cc
:33 AM
Subject: Re: Help on writing a sql statement
Will you have name collisions with the same temporary table names used
from different connections? Nope.
Temporary tables and user-defined (@-variables) are connection-specific.
Even if the same username/password combination is used to create
401 - 500 of 1597 matches
Mail list logo