Tina
What I want is ONLY the 'ME' row (if a row exists with a subject of
'ME').
If an 'ME' subject row does not exist, then I want the other one.
I see. Then to complete spec, what behaviour is desired when there are
two rows with 'ME', or two rows with (course_offer_number = 1 AND
What I want is ONLY the 'ME' row (if a row exists with a subject of
'ME').
If an 'ME' subject row does not exist, then I want the other one.
Ill be offline for awhile so I'll assume answers not available, ie allow
='ME' dupes and 'ME' dupes if they exist. A one-query answer is to
union (i)
Peter,
I really appreciate all the help. Unfortunately, the query you came up
with still returns two rows for catalog_number = 520.
I modified your query slightly to this to qualify a specific catalog_number:
SELECT c.course_id,s.course_offer_number,s.subject
FROM course c
JOIN
Tina
Basically, if the subject is ME, then I want to select that row.
If there is no row for that catalog_number that has a subject of ME,
then I want to grab the row that has a course_offer_number of '1'
and a subject that is not equal to ME.
Is this what you mean?
SELECT ...
FROM
Peter,
That was the first query I tried, but for some reason, it still pulled
all of the rows. So I've been trying to come up with another solution.
Any other ideas?
Thanks for the reply.
Tina
Peter Brawley wrote, On 6/26/08 2:12 PM:
Tina
Basically, if the subject is ME, then I want to
Tina,
for some reason, it still pulled all of the rows
Are there multiple rows which meet your WHERE condition? If so, and if
you want just one of them, your need another WHERE condition.
PB
-
Tina Matter wrote:
Peter,
That was the first query I tried, but for some reason, it still
Even if I do a basic select (with no joins) for a given catalog_number,
I still get two rows back.
Even if I do this simple query, while hardcoding in a catalog_number:
SELECT subject, catalog_number FROM course_subject
WHERE (catalog_number = 520) AND
((subject = 'ME') OR
Tina,
Even if I do this simple query, while hardcoding in a catalog_number:
SELECT subject, catalog_number FROM course_subject
WHERE (catalog_number = 520) AND
((subject = 'ME') OR ((course_offer_number = 1) AND (subject NOT LIKE
'ME')))
Errrm, you mean ...subject 'ME'..., don't you!?
I
-Original Message-
From: Elim Qiu [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 10:56 AM
To: mysql@lists.mysql.com
Subject: query counts of a database
I'm looking for a query that reports the count of each table in the
database.
the query should not assume the table list
If you are using MySQL 5.0 or later, use the INFORMATION_SCHEMA database.
It has an in-memory table of table names called (as you would expect) 'tables'.
SELECT table_rows,table_name FROM information_schema.tables
WHERE table_schema = 'whatever database you choose';
If you are using a current
PROTECTED]
To: Elim Qiu [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Friday, June 13, 2008 10:02 AM
Subject: RE: query counts of a database
-Original Message-
From: Elim Qiu [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 10:56 AM
To: mysql@lists.mysql.com
Subject: query counts
Thanks a lot Edwards!
I'm using MySQL 5.1. Your query works great!
- Original Message -
From: Rolando Edwards [EMAIL PROTECTED]
To: Elim Qiu [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Friday, June 13, 2008 10:32 AM
Subject: RE: query counts of a database
If you are using MySQL 5.0
- Original Message -
From: Rob Wultsch [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: MYSQL General List mysql@lists.mysql.com
Sent: Friday, May 23, 2008 1:42:07 PM GMT -08:00 US/Canada Pacific
Subject: Re: Query Output Issue
On Fri, May 23, 2008 at 1:35 PM, Rob Wultsch [EMAIL PROTECTED
On Fri, May 23, 2008 at 3:06 PM, [EMAIL PROTECTED] wrote:
- Original Message -
From: Rob Wultsch [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: MYSQL General List mysql@lists.mysql.com
Sent: Friday, May 23, 2008 11:10:56 AM GMT -08:00 US/Canada Pacific
Subject: Re: Query Output Issue
On Fri, May 23, 2008 at 1:35 PM, Rob Wultsch [EMAIL PROTECTED] wrote:
SELECT
p1.POPS AS `POPA`,
p2.POPS AS `POPZ`
FROM
circuits
INNER JOIN pops.POPS as p1 WHERE circuits.popID_A =p1.popID
INNER JOIN pops.POPS as p2 WHERE circuits.pop_ID_Z =p2.popID
Wow... I can't believe I wrote that
On Fri, May 23, 2008 at 11:27 AM, [EMAIL PROTECTED] wrote:
I have a table that has two has two secondary keys referencing the same
primary key of another.
Table-name =Circuits
circuitID
CircuitID
A_loc
Z_loc
Table-name = Location
locationID
location
Pacific
Subject: Re: Query Output Issue
On Fri, May 23, 2008 at 11:27 AM, [EMAIL PROTECTED] wrote:
I have a table that has two has two secondary keys referencing the same
primary key of another.
Table-name =Circuits
circuitID
CircuitID
A_loc
Z_loc
Table-name
On Fri, May 23, 2008 at 12:04 PM, [EMAIL PROTECTED] wrote:
Thanks for the quick reply, however i am getting a failure on line 2.
SELECT
11.POPS AS `POPA`,
12.POPS AS `POPZ`
FROM
circuits
INNER JOIN pops.POPS as 11 WHERE circuits.popA = 11.popID
INNER JOIN pops.POPS as 12 WHERE
Subject: Re: Query Output Issue
On Fri, May 23, 2008 at 12:04 PM, [EMAIL PROTECTED] wrote:
Thanks for the quick reply, however i am getting a failure on line 2.
SELECT
11.POPS AS `POPA`,
12.POPS AS `POPZ`
FROM
circuits
INNER JOIN pops.POPS as 11 WHERE circuits.popA = 11.popID
INNER JOIN
On Fri, May 23, 2008 at 1:47 PM, [EMAIL PROTECTED] wrote:
Still getting and error on the last line
SELECT
p1.POPS AS `POPA`,
p2.POPS AS `POPZ`
FROM
circuits
INNER JOIN pops.POPS as p1 WHERE circuits.popID_A =p1.popID
INNER JOIN pops.POPS as p2 WHERE circuits.pop_ID_Z =p2.popID
I
- Original Message -
From: Rob Wultsch [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: MYSQL General List mysql@lists.mysql.com
Sent: Friday, May 23, 2008 11:10:56 AM GMT -08:00 US/Canada Pacific
Subject: Re: Query Output Issue
On Fri, May 23, 2008 at 1:47 PM, [EMAIL PROTECTED] wrote
Greetings Niel,
Not much detail there (but I'll go off what you provided...). Some people
limit the actual MySQL system for times it TAKES MySQL to execute queries.
For THIS to be accomplished, MySQL has built-in functionality to measure the
time is takes queries to take place so it can ... limit
the query actually took or do I need to do this outside of my query.
Regards
Neil
Date: Wed, 14 May 2008 07:21:04 -0400From: [EMAIL PROTECTED]: [EMAIL
PROTECTED]: Re: Query execution time - MySQLCC: [EMAIL PROTECTED] Niel,Not much
detail there (but I'll go off what you provided...). Some people limit
actually took or do I need to do this outside of my query.
Regards
Neil
Date: Wed, 14 May 2008 07:21:04 -0400From: [EMAIL PROTECTED]: [EMAIL
PROTECTED]: Re: Query execution time - MySQLCC: [EMAIL PROTECTED] Niel,Not much
detail there (but I'll go off what you provided...). Some people limit
: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Query execution time - MySQL
If you using C++ then you can use this:
http://developer.gimp.org/api/2.0/glib/glib-Timers.html
I use this in my code, does an excelent job.
Also you
@lists.mysql.com Subject: Re: Query execution time -
MySQL Hi Neil, If your using Linux then you have to install the glib
RPM's in the usual way. I don't know about other platforms, but I am sure
there will be a version of glib out there... Also ensure the correct
include and link directives
Thanks for your help. In the end I've decided to use GetTickCount()
Neil
Date: Wed, 14 May 2008 13:44:22 +0100 From: [EMAIL PROTECTED] To: [EMAIL
PROTECTED] CC: mysql@lists.mysql.com Subject: Re: Query execution time -
MySQL Hi Neil, If your using Linux then you have to install
Neil Tompkins wrote:
Thanks for your help. In the end I've decided to use GetTickCount()
Neil
Date: Wed, 14 May 2008 13:44:22 +0100 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: Query execution time - MySQL Hi Neil, If your using Linux then you
As a note. The query itself may not be taking long but there are many
Sorting result and Copying to tmp table in myTop.
Thanks,
Michael
On Tue, May 6, 2008 at 3:26 PM, Michael Stearne [EMAIL PROTECTED] wrote:
Hi.
The main table for our site is called properties and it gets hit quite
Hi
The query is not optimized as it is scanning 45048 rows.
Vertical partitioning can be used because there is a lot of column in single
table.
On Tue, May 6, 2008 at 3:26 PM, Michael Stearne [EMAIL PROTECTED]
wrote:
Hi.
The main table for our site is called properties and it gets hit quite
Complementing the post above:
I have found that SUM(DISTINCT xxx) is valid with v.5x, not so in v.4x.
While I am trying to convince my ISP to switch the database to a v.5x
server, I would like some help with a workaround - please excuse my
newbness. I have tried :
(select
Complementing the post above:
I have found that SUM(DISTINCT xxx) is valid with v.5x, not so in v.4x.
While I am trying to convince my ISP to switch the database to a v.5x
server, I would like some help with a workaround - please excuse my
newbness. I have tried :
(select
On Wed, Apr 16, 2008 at 4:35 AM, sivasakthi [EMAIL PROTECTED] wrote:
Hi all,
Iam having the one table name called AccessDetails and data inside that
tables is following,
[snip=schema]
In that , I need to calculate the number of total sites , number of
total Accessed Sites,number of
Is the plus query return more then 50% of the records? If so, MySQL
won't return anything since the result set isn't that relevant.
Brent Baisley
Systems Architect
On Apr 11, 2008, at 8:08 AM, Barry wrote:
I am confused ( nothing new there), what I thought was a simple
search is proving
There are only 500 records in total of which three are relevant to the
'plus' query.
But there is only 1 relevant result from the 'real' query, and that did
return a result.
Brent Baisley wrote:
Is the plus query return more then 50% of the records? If so, MySQL
won't return anything
A late followup on this, so I top post to keep the history intact.
The composite primary key was the problem. Or rather, the missing
individual indexes for tag_id and ad_id.
We also changed to INNER JOINs instead, but that didn't affect the performance.
Thanks for all suggestions!
On
Hi,
On Wed, Mar 5, 2008 at 9:11 AM, Johan Thorvaldsson [EMAIL PROTECTED] wrote:
I need help to optimize this following query. It runs very slow and I cant
find any direct errors in it.
SELECT
1 * t1.termfreq as viktatantal,
t1.tag, t1.url FROM tag_keys t1
LEFT JOIN tag_ad_map tm1 ON
Thanks baron for you reply. Here is the result from the explain:
1 SIMPLE t2 ref PRIMARY,url url 194 const 1 Using where; Using temporary;
Using filesort
1 SIMPLE tm1 index PRIMARY PRIMARY 8 NULL 149115 Using index
1 SIMPLE t1 eq_ref PRIMARY,url PRIMARY 4 rubbetdev.tm1.tag_id 1 Using where
1
CREATE TABLE structure looks like this:
CREATE TABLE `tag_ad_map` (
`ad_id` int(11) NOT NULL default '0',
`tag_id` int(11) NOT NULL default '0',
`termfreq` int(11) NOT NULL default '0',
PRIMARY KEY (`tag_id`,`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
CREATE TABLE `tag_keys` (
Also you have a composite key on for the prymary key in tag_keys .
ad_id should probably be a seperate index for
LEFT JOIN tag_ad_map tm2 ON tm1.ad_id = tm2.ad_id to join well. The
Index should be ignored because the left most portion of the the index
is not used...
On 3/5/08, Rob Wultsch [EMAIL
From a brief glance:
1 * seems odd to me. Is this an attempt at some sort of cast?
ORDER BY viktatantal DESC, RAND()
LIMIT 80
How many results would this return without the limit. The ORDER BY RAND() will
never help a query. All the possible results have to be computed...
Do you mean LEFT
James;
This finds common rows.
Eh!? ... HAVING COUNT(*)=1 returns ONLY pairs that are different:
drop table if exists a,b;
create table a(i int,j int,k int);
insert into a values(1,10,100),(2,20,200),(3,30,300);
create table b select * from a;
update b set k=301 where k=300;
select * from a;
From: Peter Brawley
I'd like to run a query to find the records that
are present in one database but not the other.
See 'Compare data in two tables' at
http://www.artfulsoftware.com/infotree/queries.php.
Thanks. That's a start.
SELECT
MIN(TableName) as TableName, id, col1, col2, col3,
On Feb 11, 2008 7:27 PM, James Eaton [EMAIL PROTECTED] wrote:
SELECT
MIN(TableName) as TableName, id, col1, col2, col3, ...
FROM (
SELECT 'Table a' as TableName, a.id, a.col1, a.col2, a.col3, ...
FROM a
UNION ALL
SELECT 'Table b' as TableName, b.id, b.col1, b.col2, b.col3, ...
FROM
James
I'd like to run a query to find the records that
are present in one database but not the other.
See 'Compare data in two tables' at
http://www.artfulsoftware.com/infotree/queries.php.
PB
James Eaton wrote:
I have two different databases on the same 5.0 server that have the
same
-What I'am trying to do:
Bit hard to explain. I've got a table consisting of ip addresses
(ipv4_src), destination addresses (ipv4_dst), and port numbers
(port_dst) and some other irrelevant columns. Ultimately my goal is to
find a linear order in a subset of ports. For example, host A connects
to
Joris Kinable schrieb:
Optimize query
I've got one query, which I would like to improve a lot since it takes
very long (24 hours) to execute. Here is the idea:
1. Take the table ipv4_srcipv4_dstport_dst (other rows in this
table are not mentioned for clearity) and remove all duplicate
tuple's.
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
Hi Richard,
Richard Reina wrote:
I have a database table paycheck like this.
empno, date, gross, fed_with
1234 2007-09-01 1153.85 108.26
1323 2007-09-01 461.54 83.08
1289 2007-09-01 1153.85 94.41
1234 2007-09-15 1153.85 108.26
1323 2007-09-15 491.94 87.18
1289
you need to group the result sets by date, look at the manual link below:
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html
Richard Reina wrote:
I have a database table paycheck like this.
empno, date, gross, fed_with
1234 2007-09-01 1153.85 108.26
1323 2007-09-01
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 30, 2007 1:55 AM
To: Andrey Dmitriev
Cc: mysql@lists.mysql.com
Subject: Re: query question
Thanks.. It doesn't seem to work though.. I did verify I am on 5.0
Try lose the space after group_concat.
PB
Andrey Dmitriev wrote:
Thanks
I knew I’ve seen this error before ☺
Thanks a lot.
-andrey
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 30, 2007 1:55 AM
To: Andrey Dmitriev
Cc: mysql@lists.mysql.com
Subject: Re: query question
Thanks.. It doesn't seem to work
Hi,
Andrey Dmitriev wrote:
This is kind of achievable in Oracle in either sqlplus mode, or with the
use of analytical functions. Or in the worst case by writing a function.
But basically I have a few tables
Services, Hosts, service_names
And I can have a query something like
select
To: Andrey Dmitriev
Cc: mysql@lists.mysql.com
Subject: Re: query question
Hi,
Andrey Dmitriev wrote:
This is kind of achievable in Oracle in either sqlplus mode, or with
the
use of analytical functions. Or in the worst case by writing a
function.
But basically I have a few tables
Services
mysql.group_concat does not exist
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Monday, October 29, 2007 4:00 PM
To: Andrey Dmitriev
Cc: mysql@lists.mysql.com
Subject: Re: query question
Hi,
Andrey Dmitriev wrote:
This is kind of achievable in Oracle in either
Auch, thanks for pointing that out, what a terrible mistake.
I am aware of the performance issue, and so is the customer. But with a
table that's only going to hold maximally 60.000 records in 10 years,
I'm not afraid it'll cause significant problems. If it gets out of hand
we'll have to
I put it here:
http://pro.datisstom.nl/tests/bench.tar.bz2
The encryption isn't really a *real* security measure, except for when
somebody is stupid enough to install phpMyAdmin or anything equivalent
and try to get personal data. The problem is the password needs to be
anywhere on the
Hi John,
OK, no conspiracy here. Here is your problem:
25 $qry = sprintf(SELECT id, line FROM `encryptietest`
WHERE AES_DECRYPT(`field`, '%') LIKE '%%%s%%', $enckey, $word);
You are missing the s in %s for your first string argument, which
causes the query to be syntactically
Have you tried reversing the order of your tests, to see if there is some
influence from caching?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
Yes, I did, and shutdowns between the tests and between reversing the tests.
--
/ Humanique
/ Webstrategie en ontwikkeling
/ http://www.humanique.com/
-
Humanique zoekt een ervaren Web-ontwikkelaar (PHP).
Bekijk de vacature op http://www.humanique.com/
-
Jerry Schwartz wrote:
Have you tried
Hi John,
Your attachment for the php code got stripped somewhere. Can you post
it somewhere (http preferable)? In either case it's going to result in
a full table scan, so they are actually both a bad strategy long term,
but they should in theory perform as you would expect, with with
That is a string comparison, so they will never be equal. You don't
have to put quotes around field names unless you are using reserved
words, which you shouldn't. If you do use quotes around field
names, you need to use `backticks`.
On Oct 10, 2007, at 1:15 PM, Martijn Tonies wrote:
russbucket wrote:
I have the following query:
SELECT *
FROM Sight_Hearing_Help
WHERE 'type_help' = Eye Exam Glasses
AND 'board_action_date' BETWEEN 07-01-2007 AND 12-31-2007
LIMIT 0 , 60;
Returns empty row every time. The board_action_date is a varchar field.
Not a date field. I have
[snip]
SELECT *
FROM Sight_Hearing_Help
WHERE 'type_help' = Eye Exam Glasses
AND 'board_action_date' BETWEEN 07-01-2007 AND 12-31-2007
LIMIT 0 , 60;
[/snip]
Try WHERE type_help LIKE '%Eye Exam Glasses%' and look at your dates
in the database themselves even if they are varchars, they are
Oh boy.. having the date stored as a varchar in that particular format will be
profoundly problematic. You might want to store it -MM-DD or the SQL
BETWEEN will mangle the expected return results.
Does it work (return a non-empty result-set) when you omit the LIMIT clause?
Does it work
Have you tried testing the two parts of your WHERE clause separately?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
-Original
russbucket wrote:
Sorry about double post, I am having problems with my ISP.
I have the following query:
SELECT *
FROM Sight_Hearing_Help
WHERE 'type_help' = Eye Exam Glasses
AND 'board_action_date' BETWEEN 07-01-2007 AND 12-31-2007
LIMIT 0 , 60;
Returns empty row every time. The
Sorry about double post, I am having problems with my ISP.
I have the following query:
SELECT *
FROM Sight_Hearing_Help
WHERE 'type_help' = Eye Exam Glasses
AND 'board_action_date' BETWEEN 07-01-2007 AND 12-31-2007
LIMIT 0 , 60;
Returns empty row every time. The board_action_date is
Will Nordin wrote:
MySQL Ver 8.41 Distrib 5.0.27
Intel Xeon
3.60 GHz
2.0 G of RAM
Windows Server 2003
Service Pack 1
The following query will sometimes work and sometimes fail. When it
fails it kills the mysqld service and requires it to be restarted.
Sometimes if I add additional
Finally I decided to use:
--
SELECT id FROM mytable WHERE MATCH(firstname, lastname, comments)
AGAINST ('+johnie' IN BOOLEAN MODE) ORDER BY firstname, lastname
It works (except with acute vowel words in UTF8).
Thank you very much.
On 9/20/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Thank you Michael for your answer.
On 9/19/07, Michael Dykman [EMAIL PROTECTED] wrote:
The whitespace counts... try LIKE '%johnie%' (or better '_johnie_' ..
the underscorematches any single character).
I want to match '(johnie)' and not 'johnies' or 'aljohnier', what it's
the query does with
Thank you Chris for your answer.
On 9/19/07, Chris Sansom [EMAIL PROTECTED] wrote:
Well I'm hardly the world's greatest expert, but I'm curious as to
why you're always separating '%' from 'johnie' with a space, because
that way it will only find Johnie if he has a space before or after
him
If you need something more complicated, such as only ignoring (, then you
need to get more complicated. You might even need a regular expression.
I'm to browse:
http://dev.mysql.com/doc/refman/5.0/en/regexp.html
http://www.wellho.net/regex/mysql.html
Thank you very much!
Regards,
Jerry
thomas Armstrong wrote:
If you need something more complicated, such as only ignoring (, then you
need to get more complicated. You might even need a regular expression.
I'm to browse:
http://dev.mysql.com/doc/refman/5.0/en/regexp.html
http://www.wellho.net/regex/mysql.html
You know, you
: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
-Original Message-
From: thomas Armstrong [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 20, 2007 3:52 AM
To: Michael Dykman
Cc: mysql@lists.mysql.com
Subject: Re: Query to find foo within (foo)
Thank you Michael
20, 2007 1:28 PM
To: 'thomas Armstrong'; 'Michael Dykman'
Cc: mysql@lists.mysql.com
Subject: RE: Query to find foo within (foo)
If you want to match only (johnie) or johnie , then you
could use a
regular expression test. They can get as complicated as your
brain will
tolerate.
Regards
At 19:34 +0200 19/9/07, thomas Armstrong wrote:
I've got this table in mySQL:
item 1:
-- firstname: John (Johnie)
-- phone: 555-600-200
item 2:
-- firstname: Peter
-- phone: 555-300-400
I created this SQL query to find 'johnie':
SELECT friends.id FROM friends WHERE
You are putting a space between johnie and the % wildcards. That space is
not ignored, it is part of the pattern. LIKE %johnie% will find every
occurrence of johnie no matter what surrounds it.
If you need something more complicated, such as only ignoring (, then you
need to get more complicated.
Peter Teunissen wrote:
Hi All,
I'd like to restrict queries using the username of the user that issued
the query. I know about the available user restrictions in the database,
but they seem limited to whole tables and columns. What I need is
limiting the access on row level. If I can access
Hi Jim -
I'm using MySQL on Fedora 6 as well, with no performance problems. Did not
need to do anything to speed it up on Fedora.
It's difficult to answer the question why one is faster than the other, as
there are any number of potential differences. Some more specifics about
your setup
The comma at the end of the SELECT statement needs to be removed
Naz Gassiep wrote:
Hi,
I'm trying to execute this query:
SELECT group_post.group_thread_id,
FROM group_post
LEFT OUTER JOIN group_post_moderation ON (group_post.group_post_id
=
Hi,
Your questions are answered in the manual:
http://dev.mysql.com/doc/refman/5.0/en/query-cache-how.html
It is a known limitation.
Edoardo Serra wrote:
Hi all,
I'm benchmarking performance improvement with MySQL Query Cache
turned on but I'm facing some problem with queries inside
We solved it here,
There was a problem in the query, we removed the t1 at the 'group by'
section. The problem was really a sintax error in the code not in the
server.
Thanks,
Douglas
2007/7/19, Michael Dykman [EMAIL PROTECTED]:
instead of leaving it in PHP, please print out your fully
Hi,
If at all possible, normalizing the data is far and away the best solution.
Failing that, you can use regular expressions
RLIKE REPLACE(col, ' ', '|')
or INSTR(). Another solution is fulltext search, but it would have many
limitations depending on what you really need to do.
: mysql@lists.mysql.com
Subject: Re: Query against two data types
Hi,
If at all possible, normalizing the data is far and away the best
solution.
Failing that, you can use regular expressions
RLIKE REPLACE(col, ' ', '|')
or INSTR(). Another solution is fulltext search, but it would have
On Wed, Jun 27, 2007 at 01:27:24PM +1200, Ian Collins wrote:
Are HANDLER queries cached in the query cache?
No, they are not. The query cache only caches the results of SELECT
statements.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
You may have encountered a bug; one thing you could do to avoid having to
downgrade is specify the column number you wish to sort on (4th column in
your case), as in:
ORDER BY 4 DESC LIMIT 10;
Dan
On 6/22/07, Andrew Carlson [EMAIL PROTECTED] wrote:
I upgraded to Mysql 5.0.42 from 4.1.14
Hi,
Paul J. Boyes wrote:
Hello,
I am hoping to get pointed in the right direction/save some time...
I have a db in which some web services are constantly inserting/updating
data. However, when I run selects from the command line mysql app, I do
not see the changes that these services have
This is our problem:
http://bugs.mysql.com/bug.php?id=27210
Thanks,
Paul
Baron Schwartz wrote:
Hi,
Paul J. Boyes wrote:
Hello,
I am hoping to get pointed in the right direction/save some time...
I have a db in which some web services are constantly
inserting/updating data. However,
I have a table of properties that is linked to a table f images with a one
property to many images relationship. I have manged this with nested
queries but want to try and do it on one line. My current query
$query = SELECT * FROM images, properties WHERE images.property_id =
On Wed, May 09, 2007 at 07:14:38PM +0200, Martijn Tonies wrote:
I have a table of properties that is linked to a table f images with a one
property to many images relationship. I have manged this with nested
queries but want to try and do it on one line. My current query
$query = SELECT *
No I want all the properties only one regardless of how many images are
attached to them. Think I need a distinct in there somewhere,
- Original Message -
From: Jon Ribbens [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, May 09, 2007 6:56 PM
Subject: Re: Query problem
how do I return a single row per property even if it has 3 or 4 images
attached to it.
Please reply to the list instead of directly to me.
You could do a:
select p.from properties p where exists (select i.* from images i
where i.property_id = p.property_id)
I have a table of properties
Can you post your table definitions and some sample data.
Also what is the end requirement - how should the end result look like?
Anoop
On 4/23/07, Clyde Lewis [EMAIL PROTECTED] wrote:
Guys,
I have the following table that contains some information about a
cars. I'm trying to write a query
Hi Renish,
What is the query that you ran, please let us know.
regards
anandkl
On 4/17/07, Renish koshy [EMAIL PROTECTED] wrote:
I had a trial version of Navicat 7.2 in my system. Now I installed the
full
version 7.0.9 enterprise Navicat. After that when I run the existing
query,,I get a n
I guess it is nothing to do with the query as it was working perfectly
fine be4 installing the Navicat enterprise version 7.0.9 .thanks a lot
On 4/17/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi Renish,
What is the query that you ran, please let us know.
regards
anandkl
I guess it is nothing to do with the query as it was working perfectly
fine be4 installing the Navicat enterprise version 7.0.9 .thanks a lot
Why don't you install 7.2 full version? Why did you go back a few versions?
Martijn Tonies
Database Workbench - development tool for MySQL, and
Hi Aaron,
Aaron Clausen wrote:
I have a couple of very simple tables to handle a client signin site:
The client table has the following fields:
client_id int(11) primary key auto_increment
first_name char(90)
last_name char(90)
The signin table has the following fields
record_id int
201 - 300 of 1474 matches
Mail list logo