Hi,
Or if you are interested in limiting the number of rows add a limit clause,
so that entire resultset of entire table is not returned ,
I am not sure how will that be done , but i have seen some GUIs doing that,
would look for a solution from group.
Thanks
Abhishek
> -Original Message---
CONTACT the server admin and request access to the MySQL Instance located there
Martin
__
Verzicht und Vertraulichkeitanmerkung
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mittei
Possibly run your constructed query thru a regex expression e.g.
String mydata = "SELECT * from table WHERE a Date: Sun, 23 Sep 2012 18:38:58 -0400
> Subject: Re: How to block SELECT * FROM table; but not SELECT * FROMT table
> WHERE...;
> From: fuller.art...@gmail.com
> To: pownall...@gmail.com
Tim,
I think you misunderstood the question. Daniel wants to block Select
queries that ask for all rwows, and permit only queries that ask for some
rows, as restricted by the Where clause.
Unfortunately, I don't think that can be done. But I'm not certain of that;
there might be a trick.
Arthur
that does not change the fact that it is valid to NOT have a where
statement and for me it sound plain stupid to think about blocking
queries without where-statements - the application developers will
hopefully kill any admin who finds a solution for this...
* i maintain a cms-system sinc
select * from table where column=value means it will return only rows that
match. as long as you have proper indexing there should not be any issues.
On Sun, Sep 23, 2012 at 1:23 PM, Luis Daniel Lucio Quiroz <
luis.daniel.lu...@gmail.com> wrote:
> Helo,
>
> Just wondering if is possible to bloc
Am 23.09.2012 20:23, schrieb Luis Daniel Lucio Quiroz:
> Just wondering if is possible to block SELECT queries that doesnt have
> a WHERE statement within.
no and the idea is broken by design
what is wrong with a "select * from table" with small
tbales having only a handful of records?
how wil
Helo,
Just wondering if is possible to block SELECT queries that doesnt have
a WHERE statement within.
LD
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
If your remote host is not configured as a sql node to your cluster, you
don't need to just to import the schema. Run mysqldump on any client
machine specifying any of your configured sql nodes via -host=.
On 2012-09-23 1:40 PM, "Aastha" wrote:
Thanks!
And how do i connect the cluster from th
Thanks!
And how do i connect the cluster from the remote host.
When i try to connect one of the SQL node through remote host it says
access denied.
WHile the same is working fine from local host.
Kindly help.
Thanks!
On Sun, Sep 23, 2012 at 12:35 PM, Michael Dykman wrote:
> If all you need to tr
If all you need to transfer is schema, do it the same way you would any
other table type: use mysqldump with the - - no-data option.
On 2012-09-23 1:29 PM, "Aastha" wrote:
Thanks Nitin.
I specied the location of my.ini while starting the SQL node and it worked
fine.
I have anothe rquestion :
Ho
Thanks Nitin.
I specied the location of my.ini while starting the SQL node and it worked
fine.
I have anothe rquestion :
How to connect the cluster and reomte host. And i have to copy a schema
from one Mysql clsuter to another. How do i do that.
Regards,
On Sun, Sep 23, 2012 at 3:13 AM, Nitin Me
Hi Aastha,
I'm not 100% sure but you could try defining the full connectstring using:
ndb-connectstring = localhost:1186
See if that helps.
Regards,
From: Aastha
To: mysql@lists.mysql.com
Sent: Sunday, September 23, 2012 7:51 AM
Subject: Mysql cluster
13 matches
Mail list logo
