Re: why the sql so slowly?

How many records are there in this table. What is the select statement ur running. regards anandkl On Thu, Jun 17, 2010 at 10:05 AM, hewei wrote: > now , I need to select a table per minute. > 1. > the table struture: > - > CREATE

why the sql so slowly?

now , I need to select a table per minute. 1. the table struture: - CREATE TABLE `table_code` ( `timestamp` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `code` decimal(5,0) NOT NULL default '0', PRIMARY K

RE: opening a server to generalized queries but not "too" far

Daevid Vincent writes: > > > For the love of God and all that is holy, > > > do NOT put the user/pass on the URL like that!! > > What's so unholy (or even unwise) about it? > Oh my goodness, where to begin... > Well barring the fact that it'll be in the user's cache and browser It won't b

RE: opening a server to generalized queries but not "too" far

> -Original Message- > From: Don Cohen [mailto:don-mysq...@isis.cs3-inc.com] > Sent: Wednesday, June 16, 2010 2:48 PM > To: Daevid Vincent > Cc: mysql@lists.mysql.com > Subject: RE: opening a server to generalized queries but not "too" far > > Daevid Vincent writes: > > > For the lov

RE: opening a server to generalized queries but not "too" far

On Wed, June 16, 2010 14:47, Don Cohen wrote: > Daevid Vincent writes: > > > For the love of God and all that is holy, > > do NOT put the user/pass on the URL like that!! > What's so unholy (or even unwise) about it? The username and password shows up in logs on the server and in the browser'

RE: opening a server to generalized queries but not "too" far

Daevid Vincent writes: > For the love of God and all that is holy, > do NOT put the user/pass on the URL like that!! What's so unholy (or even unwise) about it? > Or use "mod_auth_mysql" to maintain your 'authorized' users to your page. Why is this so much better? In my case it's worse ca

RE: opening a server to generalized queries but not "too" far

> -Original Message- > From: Don Cohen [mailto:don-mysq...@isis.cs3-inc.com] > > The http request I have in mind will be something like > https://server.foo.com?user=john&password=wxyz&;... > and the resulting query something like > select ... from table where user=john and ... > (I w

Re: opening a server to generalized queries but not "too" far

MySQL doesn't have row level permissions, but this is what VIEWS are for. If you only want access to specific rows, create a view with that subset of data. You can create a function (privilege bound) to create the view to make this more dynamic. If you want direct access to the database, then you

Re: list rows with no recent updates

One option would be to add a column to the table with a last_updated timestamp. Everytime you update the row, update the last_updated field with the current timestamp. Therefore you could just query the timestamp column to get recently updated rows (or not so recently updated) as you please. -- A

Re: opening a server to generalized queries but not "too" far

Adam Alkins writes: > Sounds like you just want to GRANT access to specific tables (and with > limited commands), which is exactly what MySQL's privilege system does. How about this part? > > Finally, suppose I want to limit access to the table to the rows > > where col1=value1. If I just add

Re: opening a server to generalized queries but not "too" far

Sounds like you just want to GRANT access to specific tables (and with limited commands), which is exactly what MySQL's privilege system does. Refer to http://dev.mysql.com/doc/refman/5.1/en/grant.html For example, you can grant only SELECT privi

opening a server to generalized queries but not "too" far

This seems like a topic that must have been studied, but I'm having trouble figuring out what to search for in Google, since the usual discussion of sql injection is not what I'm looking for here. If anyone knows of references that discuss the issue, I'd like to see them. I'm also interested in a

Re: Strange GREATEST() result in 5.0.32

Steven, On Wed, Jun 16, 2010 at 9:09 AM, Steven Staples wrote: > Baron, > > Out of curiosity, do you (or anyone else) know what could be an issue with > upgrading to even 5.0.93?  or even the 5.1 branch? > > There are a lot of stored procedures/functions, as well as the fact that it > is being re

RE: MySQL For Huge Collections

From: Vikram A [mailto:vikkiatb...@yahoo.in] Sent: Wednesday, June 16, 2010 2:58 AM To: je...@gii.co.jp; Andy; mysql@lists.mysql.com Subject: Re: MySQL For Huge Collections Hi All, In this case how the images of a book will be stored, a chapter may contain number of images with different siz

RE: Strange GREATEST() result in 5.0.32

Baron, Out of curiosity, do you (or anyone else) know what could be an issue with upgrading to even 5.0.93? or even the 5.1 branch? There are a lot of stored procedures/functions, as well as the fact that it is being replicated (the backup server is running multiple instances, and is replicating

Re: [PHP] SQL Syntax

Hi! Daniel Brown wrote: > [Top-post.] > > You'll probably have much better luck on the MySQL General list. > CC'ed on this email. > > > On Tue, Jun 15, 2010 at 20:58, Jan Reiter wrote: >> Hi folks! >> >> [[...]] >> >> I have 2 tables. Table A containing 2 fields. A user ID and a pictu

RE: query help

i would monitor the performance on outer-join to determine if your server pegging cpu,disk i/o or memory when executing te outer-join then perhaps populating a temp table (and deleting the non-matching records..those records which will be considered in transaction) as joerg suggested i was

Re: query help

Thank you very much for all the insightful replies. I think I can get it to work with a join. Joerg Bruehe wrote: > > Hi! > > > Jay Blanchard wrote: > > [snip] > > I have a table similar to this: > > > > - > > |transactions | > > |ID |DATE |

Re: query help

Hi! Jay Blanchard wrote: > [snip] > I have a table similar to this: > > - > |transactions | > |ID |DATE |EMPLOYEE| > |234 |2010-01-05| 345| > |328 |2010-04-05| 344| > |239 |2010-01-10| 344| > > Is there a way to query such a table to gi

Version-differing replication trouble

Hey list, Got another strange problem. I'm in the process of migrating a 4.1 server to a 5.1. Replication is not compatible between them, so I have an intermediate 5.0 server. Setup is thus: 4.1 -> 5.0 -> 5.1 The server-id is different on all servers. It's been soft-set, followed by a flush log

Re: int(10) va int(11)

On Mon, 14 Jun 2010, Michael Dykman wrote: 11 characters of display allow for any int of any size, signed or unsigned. When you do not specify a length attribute in a declaration, MySQL uses 11 as the default. As an astrophysicist, I've always considered a flaw the fact that mysql (or SQL in

Re: [PHP] SQL Syntax

On Wed, 2010-06-16 at 08:59 +0100, Nigel Wood wrote: > I'd use: > drop temporary table if exists AttSearchMatches; > select pid as targetPid, count(*) as criteraMatched from B where > userId=35 and ( (b.aid=1 and b.value >50) OR (b.aid=3 and b.value > =4) ) group by pid having criteraMatched = 2; >

Re: [PHP] SQL Syntax

[ > I have 2 tables. Table A containing 2 fields. A user ID and a picture ID => > A(uid,pid) and another table B, containing 3 fields. The picture ID, an > attribute ID and a value for that attribute => B(pid,aid,value). > > Table B contains several rows for a single PID with various AIDs and value