Hi All,
Some of the tables have the date column. what if the table doesn't have the
date column. The number of table in the database is more than 200. What else
is possible.
Is there is any other way to do this except stored procedure
Regards,
Krishna
On 7/5/07, Ananda Kumar <[EMAIL PROTECTED]>
Hi,
Run explain plan on both the machines and post the same.
~Alex
On 7/4/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello Ananda,
yes, the testmachine has the same data.
Regards,
Spiker
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldu
Chris,
Did you check if there are any user level MAX_USER_CONNECTIONS restriction
set while granting access ?
Thanks
Alex
On 7/4/07, Chris Faust <[EMAIL PROTECTED]> wrote:
Folks,
I'm wondering is someone could help us in trying to resolve the above
error,
we have read through what threads
Hi Anand,
Some of the tables have the date column. what if the table doesn't have the
date column. The number of table in the database is more than 200. What else
is possible.
Is there is any other way to do this except stored procedure
Regards,
Krishna
On 7/5/07, Ananda Kumar <[EMAIL PROTECTED
Hi Krishna,
You can write a stored proc, where, in the main cursor, select column having
unique value for the records to be deleted,
For example
select item_id from table_name where< sysdate - 180.
This cursor will give you value of a column older than 180 days,
and inside the main stored
Hi All,
I am just trying to delete one year data from many databases and the no. of
tables is more than 200. I want to keep only six months data on the mysql
server. Is there is any way to do this.
Please help me.
Regards,
Krishna
the thing to remember is that if you only want strings that start with
CAT you'd never want to query with %CAT% because this could match
DOG_CATHY.
% is a wildcard that matches any number of characters including none.
if you want to match a single character you use _
if you actually need to s
On 7/4/07, Dan Nelson <[EMAIL PROTECTED]> wrote:
In the last episode (Jul 04), David T. Ashley said:
> On 7/4/07, gary <[EMAIL PROTECTED]> wrote:
> > SELECT column FROM table WHERE column LIKE "CAT\_%";
>
> Would it be reasonable to assume that if "column" is indexed, the
> query would execut
In the last episode (Jul 04), David T. Ashley said:
> On 7/4/07, gary <[EMAIL PROTECTED]> wrote:
> > SELECT column FROM table WHERE column LIKE "CAT\_%";
>
> Would it be reasonable to assume that if "column" is indexed, the
> query would execute quickly, i.e. I would assume that the indexing
>
On 7/4/07, gary <[EMAIL PROTECTED]> wrote:
SELECT column FROM table WHERE column LIKE "CAT\_%";
Would it be reasonable to assume that if "column" is indexed, the query
would execute quickly, i.e. I would assume that the indexing would
facilitate this kind of query?
SELECT column FROM table WHERE column LIKE "CAT\_%";
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
If I have a table with rows like this, all varchar:
DOG_LUCY
DOG_CHARLIE
DOG_LASSIE
DOG_XRAY
CAT_MR_BIGGLESWORTH
CAT_SCRATCHER
CAT_WHISTLER
what is the form of a query that will return the rows where the first part
of the string matches?
For example, what if I'd like to return the rows that beg
Folks,
I'm wondering is someone could help us in trying to resolve the above error,
we have read through what threads we could find and tried all the
suggestions, but have had no luck.
There are no memory problems, in fact when this happens if there is still a
localhost client connection to
In the last episode (Jul 03), mos said:
> If I'm replicating a master database to a slave (MyISAM tables), but
> the slave is busy serving up web pages, how does it get write access
> to the slave's table if it is always being read? TIA
Mysql places inserts in front of selects in its internal
14 matches
Mail list logo