Databases are used to store data
This line spoke the loudest to me. Over the years I had become very
proficient with FileMaker Pro's built in scripting language. I had even
gotten FileMaker to construct the web pages that would be used to
connect to FileMaker (including writing the
Hi,
I have 3 integer values in the table single_rooms, double_rooms, twin _ooms
but want to add them all up to do a comparison to see if the combined number of
rooms is less than ten.
Ta,
R.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 10 May 2007 10:08
To: mysql@lists.mysql.com
Subject: adding 3 values
Hi,
I have 3 integer values in the table single_rooms, double_rooms,
twin _ooms but want to add them all up to do a comparison
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 10 May 2007 10:08
To: mysql@lists.mysql.com
Subject: adding 3 values
Hi,
I have 3 integer values in the table single_rooms, double_rooms,
twin _ooms but want to add them all up to do a
Ok, I have this so far
$query = SELECT * FROM properties where
single_rooms+double_rooms+twin_rooms10 and rent 100;
This is fine but what I really want to do it this
$query = SELECT * FROM properties WHERE
single_rooms+double_rooms+twin_rooms10 AND
On Thu, May 10, 2007 at 03:37:26AM +0100, Jon Ribbens wrote:
I've just upgraded all the clients and servers to 5.0.41 (which looks
like it just came out); I'll see what happens.
It hasn't solved the problem, but it has changed the error message to:
OperationalError:
(2013, Lost
I'm a customer of MySQL Enterprise 5.0
The binary for Red Hat Enterprise 5 x64 compiled with Intel C++ does't
exists anymore ?
Tnks !
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello Gerald,
Data_lengthMax_data_length Index_length
596483288281474976710655 33758208
580 MB is table size and 32MB is index size.
The default maximum MyISAM size is 4GB.
Now, tell me where is an issue?
regards,
Nilnandan Joshi
DBA-SDU
Juriscape
Gerald
At 06:03 AM 5/10/2007, you wrote:
reading
authorization packet
If you do a google search:
http://www.google.ca/search?q=lost+mysql+connection+%22reading+authorization+packet%22hl=enstart=90sa=N
you'll find about a hundred web sites encountering the exact same error.
Ironically these
Some additional resources for fixing corrupt MyISAM tables:
http://dev.mysql.com/doc/refman/5.0/en/myisam-table-problems.html
http://dev.mysql.com/doc/refman/5.0/en/myisamchk.html
http://dev.mysql.com/doc/refman/5.0/en/table-maintenance.html , especially:
This is starting to get messy.
Can I set up an alias for the total?
That's exactly what HAVING is for.
PB
[EMAIL PROTECTED] wrote:
Ok, I have this so far
$query = SELECT * FROM properties where
single_rooms+double_rooms+twin_rooms10 and rent 100;
This is fine but what I really want to
On Thu, May 10, 2007 at 08:58:37AM -0600, mos wrote:
If you do a google search:
http://www.google.ca/search?q=lost+mysql+connection+%22reading+authorization+packet%22hl=enstart=90sa=N
you'll find about a hundred web sites encountering the exact same error.
Indeed, I noticed that ;-)
Maybe
On 5/9/07, James Tu [EMAIL PROTECTED] wrote:
The database server and the web server are on separate machines.
Table A contains a record for each user.
Let's say Table B contains 'relationship' information. They can be
of type 'friend' or 'family'.
If a user knows another user, this
I'm running the following query:
SELECT S.Name As School,S.State,
CASE WHEN Unfinished.Cnt IS NULL THEN 'Yes' ELSE 'bNo/b' END As
AllSubmitted,
COALESCE(Part.Cnt,0) As StudentCount,
COALESCE(Adv.Cnt,0) As AdvisorCount
FROM InvHead I
JOIN Schools S On S.ID=I.ChapterID
LEFT OUTER JOIN
Thanks David!
This the kind of answer that I was looking for (more about general
PHP and MySQL performance)
I think b/c of the way the tables are designed, I have to perform
multiple queries, unfortunately.
I think I'll have to do some performance testing at some point. But
for now I
On 5/10/07, James Tu [EMAIL PROTECTED] wrote:
I think b/c of the way the tables are designed, I have to perform
multiple queries, unfortunately.
Hi James,
My suggestion to you would be that if you have a situation you don't believe
you can handle in one query, post all the details to the
David:
I definitely can get the result set using one query, but what I do
with the result set has me thinking about breaking it up into two
queries.
Here's an example with a simple table:
describe collection;
+--+-+--+-
Dear MySQL users,
MySQL Community Server 5.0.41, a new version of the popular Open Source
Database Management System, has been released. The release is now
available in source and binary form from our download pages at
http://dev.mysql.com/downloads/
and mirror sites.
Note that not all
Hi Waldo, all!
[EMAIL PROTECTED] wrote:
I'm making an assessment of MySQL possible official adoption in my company.
A question I have is: with InnoDB codebase being owned by Oracle, is there
any impact to its reliability and support? Any other issues?
The developers of InnoDB have never
On 5/10/07, James Tu [EMAIL PROTECTED] wrote:
David:
I definitely can get the result set using one query, but what I do
with the result set has me thinking about breaking it up into two
queries.
Technical Details Omitted
Ah, OK, I misunderstood. You want to (get two results, each of which
I wrote a perl script to handle all of our regular mysql maintenance
tasks, which I thought might be useful to others. It's meant for an
enviroment with binary logging turned on, but is fairly flexible.
Although if you're backing up multiple databases you'll have to modify
it a bit, since in our
If you are dong as two seperate queries, I recommend using a
transactional table type setting the read isolation mode to repeatable
read and doing both your queries within a single transaction.
(David, sorry about the double send)
- michael
On 5/10/07, David T. Ashley [EMAIL PROTECTED] wrote:
Thanks for sharring Ofer.
I'll throw the one I wrote and use into the mix too.
http://daevid.com/examples/daily_backup_tgz.sh
Simply put it in your /etc/cron.daily/
And then every so often monitor /backups/ and delete stuff that's getting old.
(it does some cleanup)
d
-Original
-Original Message-
From: Daevid Vincent [mailto:[EMAIL PROTECTED]
Sent: Friday, May 04, 2007 1:22 AM
To: mysql@lists.mysql.com
Subject: How do I find products when a user types freeform
strings like 'Sony 20 TV' or '20 Sony TV'?
I'm having trouble figuring out the logic/query I
How would I find the next id and the prev id in sql statement like the one
below. The id number is not going to be in order so I can't do a or
limit 1 on the search
SELECT id FROM contacts WHERE category = '5' AND subcategory = '1' AND
members_id= '8' ORDER BY lastname
25 matches
Mail list logo