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 a way I can achive
Greetings,
On 5.2.3:
select plugin_name, plugin_license from plugins;
+-++
| plugin_name | plugin_license |
+-++
| binlog | GPL|
| partition | GPL|
| ARCHIVE | GPL|
| BLACKHOLE | GPL
Sweet... thanks guys... it is working well now :-).
On 4/8/07, Mogens Melander <[EMAIL PROTECTED]> wrote:
Well, maybe you want to read up on isnull() and case (..) in the manual.
It's in there, somewhere.
mysql> SELECT CASE 1 WHEN 1 THEN 'one'
-> WHEN 2 THEN 'two' ELSE 'more' END;
Hi all,
I need a query for the fol. sol.
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