Re: Questions about mysql-proxy...

2012-04-04 Thread Claudio Nanni
Wes, Thanks for these questions about this 'ghost' of the MySQL world, it seems more a legend than a real thing! I am sorry I do not have the answers but I would love to hear some. All I can say is that MySQL Proxy is currently (still) in Alpha http://dev.mysql.com/downloads/mysql-proxy/ https://l

Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted

2012-04-04 Thread Wes Modes
Thanks, Ian. W. On 4/4/2012 4:02 AM, Ian wrote: > On 04/04/2012 01:11, Wes Modes wrote: >> On 4/3/2012 3:04 AM, Ian wrote: >>> On 03/04/2012 00:47, Wes Modes wrote: Thanks again for sharing your knowledge. I do believe the answers I've receiving, but since I have requirements that I ca

Re: create multiple tables in a single query

2012-04-04 Thread joe j
Thanks to Rick I would go for a single table. I tried the following, but hasn't been successful yet. First I created one 'master' table for one country, with a country column (ctry) as Rick suggested, then I tried to use the loop suggested by Johan to insert the records for each of the remaining co

Re: create multiple tables in a single query

2012-04-04 Thread Rick James
That sounds like the wrong way to design the schema. Why not have `country` as a column in a single table? On 4/3/12 6:22 PM, Hal?sz S?ndor wrote: 2012/04/03 22:27 +0200, joe j So what I am trying to get is a script that runs through a list of country names (US, UK, NL, etc) and create ta

Argh. Packages.

2012-04-04 Thread Johan De Meersman
A little heads-up for those thinking of toying with NDB. Not the actual NDB, mind you, the packaging. While the packages you download are very eloquently named (mysql-cluster-gpl-7.2.5-debian5.0-x86_64.deb), someone inside Oracle either doesn't quite grok how dpkg works, or deliberately made a

Re: create multiple tables in a single query

2012-04-04 Thread joe j
Thanks. I was looking for a loop--not to gain speed but to reduce the length of my script file:) I'll try and hopefully it will work! J On Wed, Apr 4, 2012 at 12:16 PM, Johan De Meersman wrote: > - Original Message - >> From: "joe j" >> >> So what I am trying to get is a script that runs

Re: migrate existing data each additional product

2012-04-04 Thread haidarpesebe
Thanks for quick reply. And also thank you very much for the information. Best regard --Original Message-- From: Johan De Meersman To: Albahar Uya Cc: MySQL Lists Subject: Re: migrate existing data each additional product Sent: Apr 4, 2012 17:33 - Original Message - > From: "Haida

Re: migrate existing data each additional product

2012-04-04 Thread Johan De Meersman
- Original Message - > From: "HaidarPesebe" > > I asked for help, how to order that each time I add an item then the > item number in column 1 move to column 2, column 2 moves to the > column 3, column 3 to 4 and so on. > > product | 1 | 2 | 3 | 4 | total > [...] What a most peculia

Re: create multiple tables in a single query

2012-04-04 Thread Johan De Meersman
- Original Message - > From: "joe j" > > So what I am trying to get is a script that runs through a list of > country names (US, UK, NL, etc) and create tables for each one of > them as above. Is this feasible in MySql? You can't create multiple tables with one statement; but you *can* p

Re: create multiple tables in a single query

2012-04-04 Thread Hal�sz S�ndor
2012/04/03 22:27 +0200, joe j So what I am trying to get is a script that runs through a list of country names (US, UK, NL, etc) and create tables for each one of them as above. Is this feasible in MySql? There are PROCEDUREs, and there is PREPARE. Look them up. -- MySQL Gener

Re: JOIN giving duplicate records

2012-04-04 Thread Hal�sz S�ndor
;>>> 2012/04/03 18:18 +0100, Tompkins Neil Before sending the table definition, and queries etc, can anyone advise why my query with four INNER JOIN might be give me back duplicate results e.g 100,UK,12121 100,UK,12121 Basically the query the statement AND (hotel_facilities.hotelfacilitytyp