On Fri, 12 Nov 2004, Fagyal Csongor wrote:
Hi List,
I am putting in a separate disk for our MySQL (4.1.7) server. I have
some MyISAM, some InnoDB tables. Lots of reads, lots of writes (mostly
atomic ones, insert/update one row), a few million rows per table,
approx. 100-400 queries per
This is my query
select id, status from sale where user_id = 1 GROUP BY id;
I need to know how many rows or how many entries this query returns. I
tried to use count and sum. But the result is wrong.
I want to be able to make select and know how many rows this query
returns. Now, I use
Thanks for the advice Steven, I'll bear it in mind and do some reading.
Graham
-Original Message-
From: Steven Roussey [mailto:[EMAIL PROTECTED]
Sent: 13 November 2004 02:52
To: 'Graham Cossey'
Cc: [EMAIL PROTECTED]
Subject: RE: Help with query performance anomaly
For production
Smart Software is the key to many problems hardware with 'standard'
software cannot solve or handle.
I believe that mySQL will, by year 2012, be able to handle it
gracefully. It will be able to do so much more by then (easy and
robust clustering / HA, for example) and even incorporate
On 12 Nov 2004, at 20:04, Ron Thomas wrote:
What do most people use for a report designer for linux? I need to
design a report similar to a
phone book directory, ie, multi-column with page breaks when the first
letter of the field changes.
use perl;
Something like DBI will talk to the MySQL
I hope that the original poster notes that none of the comments in this
thread actually answer the question about how scaleable MySQL will be in
2012. No one has talked about that for one simple reason: no one knows.
Frankly, I think the entire question was naive from the start. I can't think
of
GH wrote:
I am trying to insert data in the ProgressNotes Table using the
following query but it does not work. Can someone please assist? Thank
You.
[snip]
'Understandably, the consumers were upset. The Dean (SR) was kind
enough to try and help explain to our members that there was a
Have you read the page in the manual which documents the string functions
http://dev.mysql.com/doc/mysql/en/String_functions.html?
UPDATE your_table
SET name_col = REPLACE(name_col, 'Peter', 'Paul');
Now, when you say, all fields in a table, do you mean every row of a
particular column, or
I've had this going over on the php-general list.
Thought I would throw it out here . Running PHP 4.0.22
Keep getting this error -
SELECT PostStart, JobTitle, Industry, LocationState,
VendorID FROM VendorJobsSELECT PostStart, JobTitle,
Industry, LocationState, VendorID FROM VendorJobsWHERE
On Sat, Nov 13, 2004 at 12:30:43PM -0800, Stuart Felenstein wrote:
$sql = SELECT PostStart, JobTitle, Industry,
LocationState, VendorID
FROM VendorJobs;
echo $sql;
//if ($Ind)
$sql .= WHERE VendorJobs.Industry = $s_Ind;
As you can see above s_ind is an array , comma
delimited.
--- Jim Winstead [EMAIL PROTECTED] wrote:
You can't compare a column with a comma-delimited
list of numbers like
that...
What should the seperator be then ?
Thank you
Stuart
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
On Sat, Nov 13, 2004 at 12:46:12PM -0800, Stuart Felenstein wrote:
--- Jim Winstead [EMAIL PROTECTED] wrote:
You can't compare a column with a comma-delimited
list of numbers like
that...
What should the seperator be then ?
My point was that you can't compare a column with an
--- Jim Winstead [EMAIL PROTECTED] wrote:
My point was that you can't compare a column with an
array
of numbers using the '=' operator. You have to use
the IN
operator, as in the line of code I posted:
Thank you Jim , it's working now!
Stuart
--
MySQL General Mailing List
For list
Sasha Pachev [EMAIL PROTECTED] wrote:
Check if you have any replication restricting rules on the slave.
There might be a bug that incorrectly flags a query to be excluded.
If that is the case, then try to re-write the rules to see if you can
get around the bug.
Yes. I have recently add the
SELECT TYTUL FROM tKsidata
WHERE MATCH (TYTUL) AGAINST (space)
ORDER BY TYTUL
TYTUL
Shaping Space 2ed
National Air Space Museum
Light Space
Free Space Architecture
Does Economics Space Matter ?
Economies of Signs Space
Industry Space Competition Contribution of Economists of P
Money Space
I would like to know how I can make two columns out put as one?
For Example I have
+---+-+--+---+-+
| AttID | SessionDate | LastName | FirstName | Present |
+---+-+--+---+-+
| 2 | 2004-10-30 | Smith | Dale
SELECT AttID ,SessionDate , CONCAT( FirstName, , LastName ), Present
FROM myTable
- Original Message -
From: GH [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, November 14, 2004 5:32 AM
Subject: Concatinating Two Columns
I would like to know how I can make two columns out put
17 matches
Mail list logo