Hi all,
I am running a mysql cluster like this:
ndb_mgm show
Connected to Management Server at: localhost:1186
Cluster Configuration
-
[ndbd(NDB)] 2 node(s)
id=3@10.0.0.1 (Version: 5.0.22, Nodegroup: 0, Master)
id=4@10.0.0.2 (Version: 5.0.22, Nodegroup: 0)
Using Innodb under Windows XP, MySQL server installed to default location:
is it possible to let the mysql database be in C:\Program
Files\MySQL\MySQL server 5.0\data while we have our innodb specific data
files in C:\DataCollector\Resources\ ?
IOW (from my.ini):
#Path to installation
and, BTW, we are starting the service with --innodb-file-per-table in
case this matters,
les schaffer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I have a query that comes out like this.
Program Status Param1 Param2 Param3 Param4 Param5
A 1 1.1 2.2 3.3
4.4 5.5
B 2 2.2 3.3 4.4
5.5 6.6
C 3
Would like for the results to become pivoted and be transposed to look
like this.
There's a little step-by-step for this at
http://www.artfulsoftware.com/queries.php under 'Pivot tables', 'Group
column statistics in rows'.
PB
-
Ow Mun Heng wrote:
Hi,
I have a query that comes out