Hi List,
What is the practical limit on size of the sql query in mysql 4.1.x
Anil
Hi Abhishek,
In a table i have 100s of rows with six categories like A,B,C,D,E,F
which is
marked with a column like
Table
ID Category
1 A
2 A
3 B
4 B
5 B
6 C
7 C
and so on 100 ids for each of six categories , i want to delete all
but 10
ids of each category, i wanted to know how to d
Not sure how to do it in a single query, but if you run this query repeatedly,
eventually you'll have only 10 left of each category.
DELETE tableName
FROM tableName, (SELECT MAX(ID) deleteID,count(ID) categCount FROM tableName GROUP BY Category HAVING categCount>10) AS Smry WHERE
tableName.ID=S
Has anyone seen any issues updating from 5.1.11 to a later version?
We use partitioning extensively and was wondering how badly we’re going to get
hosed upgrading.
We’re on Fedora Core and used the RPMs to install… I need to be able to turn
off general_log… It kills my DB every few days whe
Hi,
I have this database with utf-8 charset.
How can i change it to latin1 ?
I've seen the MySQL pages and run in the MySQL prompt:
ALTER DATABASE telbit CHARACTER SET latin1 COLLATE latin1_swedish_ci;
but i get an error saying that i have an error in my syntax.
Any help would be appreciated.
Is there a way to create temporary stored proc or func so that it is
store in memory rather than in the mysql.proc table?
The result I am going for is to abstract some encryption functions,
but I don't want the encryption process stored in the proc table; I
was thinking if there was a way t
Ravi Kumar. wrote:
Can any one help me please?
Ravi Kumar. wrote:
Hi All,
We have a MySQL 5.0 server (master) running on Windows. For backup, I
wish to setup another system with same version of MySQL to act as
backup / slave. But this slave can not have direct access to the
master. Is there
Hi All!
I have just released PrimeBase XT 0.9.86 (http://www.primebase.com/
xt), which will be my last release before the MySQL User Conference
this year. The most significant change in this version is the
reduction of the number of data logs used per table. This, and a
number of other mod
But this slave can not have direct access to the master. Is
there a way I can achive this?
If the slave cannot have access to Master how can we call it as a Slave. I
would rather call that as a server where you want to dump the mysql/data
directory of the Master. better write a nightly shell scr
