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,
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
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
=
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
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 primary
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 i
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 ex
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 w
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 t
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
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 a
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 wrote:
> Your table structure makes the SQL a little inelegant, but
On Sat, Jan 2, 2010 at 11:20 AM, Arthur Fuller wrote:
> 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
>
On Sat, Jan 2, 2010 at 12:03 PM, prabhat kumar wrote:
> 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
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
arbitraril
On Sat, Jan 2, 2010 at 11:20 AM, Arthur Fuller wrote:
> 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
>
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 one
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 Hospital3
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
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 table
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
Hi
My fields something like
hospital1,hospital2,hospital3,patientname,
Exact table look like
PatientName Hospital1Code Hospital2Code Hospital3Code
Bharani 1234NULL NULL
Kumar 56781234 NULL
Senthil
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
23 matches
Mail list logo
