innodb_data_file_path

2010-01-02 Thread Jeetendra Ranjan
Hi, I am using MySQL 5.0.85-community on Fedora 8. When i set innodb_data_home_dir = innodb_data_file_path = /dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw and restart the server it gives an error Starting MySQL.Manager of pid-file quit without updating file.[FAILED] Please suggest how to resolve

Render row without duplicates

2010-01-02 Thread bharani kumar
Hi My fields something like hospital1,hospital2,hospital3,patientname, Exact table look like PatientName Hospital1Code Hospital2Code Hospital3Code Bharani 1234NULL NULL Kumar 56781234 NULL Senthil

Re: Render row without duplicates

2010-01-02 Thread Benedikt Schackenberg
Am 02.01.2010 13:43, schrieb bharani kumar: No Duplicate records, select hospital1code from *yourtable* grop by hospital1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Render row without duplicates

2010-01-02 Thread Gary Smith
bharani kumar wrote: Hi My fields something like hospital1,hospital2,hospital3,patientname, [...] i know , i can display all hospital code with unique , but i dont in the single column , with unique record, Can you tell me how to do this ? Would it be possible to reconsider your

Re: Render row without duplicates

2010-01-02 Thread Gary Smith
Benedikt Schackenberg wrote: Am 02.01.2010 13:43, schrieb bharani kumar: No Duplicate records, select hospital1code from *yourtable* grop by hospital1 This won't work as he's also looking for entities in the hospital2code and hospital3code fields to be returned in the same resultset, but

Re: Render row without duplicates

2010-01-02 Thread Jim Lyons
Your table structure makes the SQL a little inelegant, but I'd say this would give you what you seem to want: select Hospital1Code from tab where Hospital1Code is not null union select Hospital2Code from tab where Hospital2Code is not null union select Hospital3Code from tab where

Re: How Set Up This Table

2010-01-02 Thread Arthur Fuller
Hi Victor. I think that the first thing you need to consider is whether a product can be in more than one package, and second is whether a package can be in another package. Also, I don't know why you need to auto-generate in either case. It's pretty simple DDL. Case 1: product can only be in

Re: How Set Up This Table

2010-01-02 Thread Victor Subervi
On Sat, Jan 2, 2010 at 11:20 AM, Arthur Fuller fuller.art...@gmail.comwrote: Hi Victor. I think that the first thing you need to consider is whether a product can be in more than one package, and second is whether a package can be in another package. Also, I don't know why you need to

Re: How Set Up This Table

2010-01-02 Thread prabhat kumar
primary key is a candidate key to uniquely identify each row in a table. A unique key or primary key comprises a single column or set of columns. No two distinct rows in a table can have the same value (or combination of values) in those columns. Depending on its design, a table may have

Re: How Set Up This Table

2010-01-02 Thread Victor Subervi
On Sat, Jan 2, 2010 at 12:03 PM, prabhat kumar aim.prab...@gmail.comwrote: primary key Oh! PK is primary key! a compound key is a key that consists of 2 or more attributes that uniquely identify an entity occurrence. Thanks. V

Re: How Set Up This Table

2010-01-02 Thread Victor Subervi
On Sat, Jan 2, 2010 at 11:20 AM, Arthur Fuller fuller.art...@gmail.comwrote: Hi Victor. I think that the first thing you need to consider is whether a product can be in more than one package, and second is whether a package can be in another package. Also, I don't know why you need to

Re: Render row without duplicates

2010-01-02 Thread bharani kumar
Hi First i want to thanks to my mysql groups, Sorry , just now i find time to see mail, Am not sure, but i guess this union solves my problem, But let me check it, give me a time..plz On Sat, Jan 2, 2010 at 7:24 PM, Jim Lyons jlyons4...@gmail.com wrote: Your table structure makes the SQL a

Importing table contents

2010-01-02 Thread Patrice Olivier-Wilson
I have 2 databases, different domains. Both have a table named 'tips'... both have different contents in the table. Using phpMyAdmin for GUI. I want to export databaseA tips as sql (done) then import content into databaseB tips. But when I run that operation, the databaseB says that there is

Re: Importing table contents

2010-01-02 Thread Gary Smith
Patrice Olivier-Wilson wrote: I have 2 databases, different domains. Both have a table named 'tips'... both have different contents in the table. Using phpMyAdmin for GUI. I want to export databaseA tips as sql (done) then import content into databaseB tips. But when I run that operation, the

Re: Importing table contents

2010-01-02 Thread Patrice Olivier-Wilson
Gary Smith wrote: Patrice Olivier-Wilson wrote: I have 2 databases, different domains. Both have a table named 'tips'... both have different contents in the table. Using phpMyAdmin for GUI. I want to export databaseA tips as sql (done) then import content into databaseB tips. But when I run

Re: Importing table contents

2010-01-02 Thread Gary Smith
Patrice Olivier-Wilson wrote: I have data I need to keep in both db just trying to merge. There's two ways around this: First is to not export the structure (uncheck structure). The second is to export with if not exists. This should (IIRC) do a create table if not exists, so it'll do

Re: Importing table contents

2010-01-02 Thread Patrice Olivier-Wilson
Gary Smith wrote: Patrice Olivier-Wilson wrote: I have data I need to keep in both db just trying to merge. There's two ways around this: First is to not export the structure (uncheck structure). The second is to export with if not exists. This should (IIRC) do a create table if not

Getting the sum() for a column from a joined table

2010-01-02 Thread Octavian R��ni��
Hi, I have 3 tables, `agents`, `clients` and `sales` and I want to select a single agent from the `agents` table, and 2 more columns that contain the number of clients for the selected user (from the `clients` table) and the sum of the sales for the selected user (from the `sales` table). Is

Re: Importing table contents

2010-01-02 Thread Gary Smith
Patrice Olivier-Wilson wrote: Gave it a try got this: MySQL said: #1062 - Duplicate entry '1' for key 1 Yeah, that's what I was saying about in my previous mail. It looks like you've got a primary key on one of your columns, and you're attempting to insert data into it with a duplicate

Re: Importing table contents

2010-01-02 Thread Patrice Olivier-Wilson
Gary Smith wrote: Patrice Olivier-Wilson wrote: Gave it a try got this: MySQL said: #1062 - Duplicate entry '1' for key 1 Yeah, that's what I was saying about in my previous mail. It looks like you've got a primary key on one of your columns, and you're attempting to insert data into it with

RE: Getting the sum() for a column from a joined table

2010-01-02 Thread LIU YAN
hi , Octavian you can try this SQL. = select agents.id, agents.name, (select count(*) from clients where agent=agents.id), (select sum(value) from sales where agent=agents.id) from agents where agent.id=100 =

Instll php on Window 2003 64Bit questions

2010-01-02 Thread Edward S.P. Leong
Dear All, If the OS is Windows 2003 64Bit (IIS)... So, which php package must download and how to config it for running with IIS ? Due to I don't quite the online manual: http://www.php.net/manual/en/install.windows.iis.php Which installation mode is suitable of it ? Thanks ! Edward. -- MySQL

Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2010-01-02 Thread Edward S.P. Leong
Jerry Schwartz wrote: From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Tuesday, December 29, 2009 10:35 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: Dear Jerry, Sorry,