We had an awkward setup, which forced us to use PGSQL for SpamAssassin.
Unfortunately the SA queries are not processed well by PGSQL.
Back in January we switched SA processing to MySQL. Bingo! Instant improvement
in overall performance, and no PGSQL maintenance required. This is not
sophistica
;ll be moving myself and one other developer to an SVN
environment; we will see how it goes.
Cheers - Miles Thompson
At 07:04 PM 3/30/2007, Michael Dykman wrote:
We keep all of the schema (one file per table) in SVN (subversion)
with a directory to represent each database. As the schema evo
e (AttributeID, Attribute_Value). Then just do an INSERT IGNORE. The
index will prevent a new non-unique from being entered and the IGNORE will
prevent an error.
- Original Message - From: "Miles Thompson"
<[EMAIL PROTECTED]>
To:
Sent: Monday, March 12, 2007 3:02 PM
Subje
e (AttributeID, Attribute_Value). Then just do an INSERT IGNORE. The
index will prevent a new non-unique from being entered and the IGNORE will
prevent an error.
- Original Message - From: "Miles Thompson"
<[EMAIL PROTECTED]>
To:
Sent: Monday, March 12, 2007 3:02 PM
Subje
I want to add records to an attributes table for every item which does not
have an attribute of a given value. The problem is that some records have
already had these values added.
Please have a look at the following query, an INSERT ... SELECT construct
which I believe will do the job:
INSE
Jay,
That looks a lot more professional - thanks.
Where can I get information on writing better SQL?
Regards - Miles Thompson
From: Jay Pipes <[EMAIL PROTECTED]>
DELETE bm_KW FROM bm_KW
INNER JOIN (
SELECT kw2.KeywordID
FROM bmjn_KW kw1
INNER JOIN bmjn_KW kw2
ON kw1.KeywordID
the bm_KW table is searched to determine if any of the
keywords used to describe it have been used before. If so a record is added
to bmjn_KW referencing the item and the KeywordID in bm_KW.
If the keyword has not been used it is added to bm_KW and then referenced as
described above.
Any thoughts
At 10:42 PM 2/25/2007, mos wrote:
At 06:13 PM 2/25/2007, Miles Thompson wrote:
Would someone please check this delete query?
This should delete all rows from the geodesic_user_data that have no
match in the subscriber table, but another set of eyes would be appreciated.
DELETE
Would someone please check this delete query?
This should delete all rows from the geodesic_user_data that have no match
in the subscriber table, but another set of eyes would be appreciated.
DELETE geodesic_user_data
FROM geodesic_user_data
LEFT JOIN subscriber ON geodesic_classifieds_userda
This works:
SELECT geodesic_classifieds_userdata.id FROM geodesic_classifieds_userdata
LEFT JOIN subscriber ON
geodesic_classifieds_userdata.id=subscriber.GeoClassID
WHERE subscriber.GeoClassID IS NULL;
Please check this syntax for a DELETE statement
DELETE geodesic_user_data gud, subscri
At 03:31 PM 1/24/2007, Martijn Tonies wrote:
Hello Randy,
> I have a table that has a column that has a timestamp Column.
>
> This table is going to get very large ( 1 or 2 million rows) and will
> be queried alot.
>
> Alot of these queries will be against timestamp column.
>
> These queries wi
well as id, retrieved cost values are indeterminate.
PB
-----
Miles Thompson wrote:
At 03:58 AM 1/19/2007, Felix Geerinckx wrote:
[EMAIL PROTECTED] (Miles Thompson) wrote in
news:[EMAIL PROTECTED]:
> This query:
>
> SELECT
> member_id,
> member_sub_id,
> IF(
then remove 5 and install 4.
Why or how is koha not compatible with version 5?
Regards - Miles Thompson
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.410 / Virus Database: 268.17.3/642 - Release Date: 1/20/2007
--
MySQL General Mailing List
For
At 03:58 AM 1/19/2007, Felix Geerinckx wrote:
[EMAIL PROTECTED] (Miles Thompson) wrote in
news:[EMAIL PROTECTED]:
> This query:
>
> SELECT
> member_id,
> member_sub_id,
> IF( ( monthly_cost = 10 ), ( SUM(( monthly_cost * 2.00 ) + 200 )
> ), ( SUM(
&
At 12:14 AM 1/19/2007, Dan Nelson wrote:
In the last episode (Jan 18), Miles Thompson said:
> The query displayed below performs flawlessly, except for these two
records:
>
>
7364 M0174000250510 Invoice 2006-12-13
2006-12-13 2006-12-31
>
ed in completely different contexts.
If your thinking that VB is "easy" is based on Microsoft's demonstrations,
believe me the real world does not work that way; there is much more back
end plumbing involved.
Regards - Miles Thompson
--
No virus found in this outgoing m
x, so I will do that.
Regards - Miles Thompson
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.410 / Virus Database: 268.16.14/636 - Release Date: 1/18/2007
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
At 12:54 PM 12/16/2006, you wrote:
Hiya,
Real easy quick question.
I need to design a database which holds users with email, name and some
other details.
I also want each user to be able to create one or more groups of users,
owned by themselves.
What would be the best design approach?
So far
://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res)
BRASILmailto:[EMAIL PROTECTED]
Leandro,
Help this poor English-speaker - what's the symbol you use to describe SolidDB?
Cheers - Miles Thompson
--
No virus found in this outgoing message.
Checked b
At 06:26 PM 10/5/2006, Ferindo Middleton wrote:
I have a primary key set on a table which consists of the combination of the
values: firstname, lastname, and a schedule_id (BIGINT(20))... I have this
so the records in this table do not have duplicates, being that no one
record should have the ex
At 10:55 AM 9/6/2006, spacemarc wrote:
Hi,
I want to get all records from Tab1 and the first 20 words for the fieldA
SELECT *, LEFT(fieldA, 20) AS fieldA FROM Tab1
But this query does not work: why?
thanks!
--
http://www.spacemarc.it
First of all - please reply to the list ..
I though
At 08:22 AM 9/6/2006, Nicholas Vettese wrote:
I have a registration script that inserts data into the database, and
then emails you an activation code to activate your account. The
problem is that when I click on the link in the email, the account does
not get updated. The portion of the scrip
ting * limit 5 where username = view.username. See where that's
headed? You may need a temporary table.
Sorry I've not been more help.
Regards - Miles Thompson
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.10.5/406 - Rele
this one:
http://www.php-mysql-tutorial.com/
which appears to be divided into sections appropriate to operations on the
database.
Then check the MySQL docs for specifics on SELECT, INSERT and UPDATE.
Fortunately your ALTER TABLE statement was incorrect, otherwise you would
have des
At 06:32 AM 8/3/2006, Ratheesh K J wrote:
Hello all,
Just wanted to know how many columns are preferable in table. At present
we are having nearly 50 - 60 columns in some of the tables. Is this ok or
should we be splitting the tables for normalization.
If we really need to split then how be
threads in Apache?
Have you rebuilt your indexes? Dropped them and replaced.
Run optimize database?
Done a dump and restore?
Miles Thompson
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.10.4/401 - Release Date: 7/26/2006
--
MySQL
%' OR pl.art_num LIKE '%Media%
Center%') " as the WHERE.
Apologies if this has been too pedantic.
Hope this is helpful - Miles Thompson
[1] MySQL 4.0 does another optimisation on LIKE. If you use ... LIKE
"%string%" and string is longer than 3 characters, MySQL wi
.
In a word - DON'T. "DESC" is a reserved word - if it is an abbreviation
for description, use "descr", if for descending, try "dscnd".
Use of reserved words for field names is bad practice and is guaranteed to
cause grief in the future.
Cheers - Miles Th
to answer your question.
Regards - Miles Thompson
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.9.10/387 - Release Date: 7/12/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
b file in
the other systems. Not very elegant...
Thanks for your answer.
yvan
I used the Workbench under XP - once I started adding relations and foreign
keys, everything fell apart.
So I took the generated SQL, edited it by hand and generated the tables.
It's still pretty rough.
At 12:36 AM 7/11/2006, you wrote:
I used to use UltraEdit, but then switched to EditPlus because it can edit
remote files almost transparently. (Opening a file FTP's it down, you edit
local copy, Saving FTP's it back.)
FYI - UltraEdit can do this - It uses SFTP over SSH to edit remote files.
;t edit files on the server, can it?
I used to use UltraEdit, but then switched to EditPlus because it can edit
remote files almost transparently. (Opening a file FTP's it down, you edit
local copy, Saving FTP's it back.)
Cheers - Miles Thompson
--
No virus found in this outgoing messa
EditPlus will match parentheses; I think the latest version of UltraEdit
does as well.
It is a real help at times.
Cheers - Miles Thompson
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.9.10/383 - Release Date: 7/7/2006
--
MySQL Gen
At 07:15 PM 6/21/2006, Karl Larsen wrote:
I have the subject book and I want to learn SQL from this book. Alas
the bookbiz.sql file on the cd-rom was last updated in 1996 :-) 10
years ago. I tried to load it on my version 4 mysql and it would not get
far at all. It appears that the softwa
ider, pair Networks, by default locks the
dbs down to their network only, but I have the option to open them up.
Dan
Miles Thompson wrote:
I have searched the MySQL Administrator forum for help on this, but no joy.
When I try to conect to a database on Dreamhost, using MySQL
Administrator,
he PING button
[OK] [PING]
--
It pings OK, and I can use phpMyAdmin, I just wanted to try a more direct tool.
Dreamhost has not been a lot of help. I suspect it's because MySQL
Administrator is too powerful.
Dan,
Did not know about events in MySQL. That's a terrific feature.
Miles
At 09:44 AM 6/2/2006, Dan Buettner wrote:
Alex, as Miles noted, this could easily be accomplished with an external
cron event. Doesn't have to be written in an external language like PHP
or perl, even - could be a se
not believe it has a built-in timer, except for
synchronization or replication.
Miles Thompson
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.8.1/354 - Release Date: 6/1/2006
--
MySQL General Mailing List
For list archiv
as I started adding foreign keys - BLOOM! BLOOM! - lines
and labels everywhere. The schema code it generated need a lot of editing
as well.
This is expecting rather a lot, but thought I would ask.
Regards - Miles Thompson
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Ve
MySQL
3.23 mysqld binary. Try using a full path to the MySQL 5.0.20 binary
and see if you still get errors.
-Sheeri
On 5/10/06, Miles Thompson <[EMAIL PROTECTED]> wrote:
I am trying to install two MySQL servers to run as Windows XP services.
One for work with php-gtk+ as mysqld1, MySQL
have any suggestions? They will be most welcome.
Regards - Miles Thompson
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.392 / Virus Database: 268.5.5/335 - Release Date: 5/9/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
h") ". (Check syntax!!) But that's likely to
be slower than cold molasses and run like a pig.
If you're not too far into the project, and you will have a lot of
subqueries, switch to PostgreSQL or a database that supports them.
I don't really have an answer. I hope s
42 matches
Mail list logo