Sam --
Please use REPLY-ALL when sending email to the list.
Can you use \t? I don't think so.
I know that if you want to enter in '\t', you will need to escape it '\\t',
but MySQL may treat that as something else. It may treat it as a TAB in its
own right, as I know that it will replace '\\
I'm not sure this will work for you, but look at the GROUP BY clause and
the
GROUP_CONCAT() function.
That was exactly what I needed! I converted my query as follows, and I'm
getting exactly what I was looking for:
SELECT S.*, CONCAT(C.FirstName,' ',C.LastName) AS CounselorName,
(SELECT
I'm not sure this will work for you, but look at the GROUP BY clause and the
GROUP_CONCAT() function.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Jesse [mailto:[EMAIL PROT
Using MySQL 5.0.22-community-nt-log
Is there a way to compose a query that would show multiple values in field?
In other words, I have a table structure like this:
Activity 1
Section 1
Schedule 1
Schedule 2
Section 2
Schedule 1
Activity 2
Section 1
Schedule 1
Sch
CONCAT_WS() works as well, but the format is still the same. You still want to
add your new data to your old data.
UPDATE tmpTable SET Textarea = CONCAT_WS(',',Textarea,'data you wish to add')
WHERE ID = someID
Just remember to make the delimiter something that you wouldn't normally see in
a t
It says nothing about how long it takes to process a query (service time);
it tells you on average how often queries come in (arrival rate). If the
service time is such that an arriving query is finished before the next one
arrives, you aren't in terrible shape as far as the queue of waiting querie
My idea of this is :
(Questions+Slow queries)/Uptime = Queries per second avg
(118794 + 16) / 84751) = 1,4018713643496831895788840249673
Uptime: 84751 Threads: 2 Questions: 118794 Slow queries: 16
Opens: 478 Flush tables: 1 Open tables: 29
Queries per second avg: 1.402
--
Later
Mogen
Hi Balaraju,
The validation should be enforced by your application.
You should not allow users to have proceed further if they dont give email's
or passwords less than 6 characters.
regards
anandkl
On 4/6/07, balaraju mandala <[EMAIL PROTECTED]> wrote:
Hi All,
What data will be inserted if so
Hi All,
What data will be inserted if some users use regional keyboards(like
Chineese or French characters supported).
Is my validation conditations will work for those?
I mean recently i observed that some registered users for our
application violated validation rules. Some users give single ch
It's just telling you how many queries per second on average the server
is receiving. This says nothing about how long it takes to execute a
particular query.
-Micah
On 04/06/2007 01:22 AM, C.R.Vegelin wrote:
Hi List,
Using printf(" System status: %s\n", mysqli_stat($link));
in a PHP script,
Ofcourse, the number of queries is just the value of Questions.
Christophe Gregoir wrote:
I have to admit, Google doesn't provide much information.
Let's take a closer look and see if we can't figure out ourselves what
that value means.
Here is the output of `mysqladmin status` on my developm
I have to admit, Google doesn't provide much information.
Let's take a closer look and see if we can't figure out ourselves what
that value means.
Here is the output of `mysqladmin status` on my development box:
Uptime: 7510 Threads: 3 Questions: 4123 Slow queries: 0 Opens:
713 Flush tab
Thanks Christophe,
Question rephrased:
how do you explain 0.05 q/s = 20 s/q
with an immediate response ?
Cor
- Original Message -
From: "Christophe Gregoir" <[EMAIL PROTECTED]>
To: "C.R.Vegelin" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, April 06, 2007 8:35 AM
Subject: Re: question abou
C.R.Vegelin wrote:
...
How should I interpret "Queries per second avg" ?
How about as 'queries per second on average' :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi List,
Using printf(" System status: %s\n", mysqli_stat($link));
in a PHP script, says: "Queries per second avg: 0.051".
This means that a query takes about 20 seconds ?
But the query result is given immediately.
How should I interpret "Queries per second avg" ?
I'm using version 5.0.15 NT.
Reg
15 matches
Mail list logo
