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
Hi
My fields something like
hospital1,hospital2,hospital3,patientname,
Exact table look like
PatientName Hospital1Code Hospital2Code Hospital3Code
Bharani 1234NULL NULL
Kumar 56781234 NULL
Senthil
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
=
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
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,
23 matches
Mail list logo