Guys,
I doubt I'd qualify as an expert but here's my two pence worth ( ;^)
)I wrote a search engine a while back that relies heavily on full-text
searching and the three things I found that improved results were...
1) Precisely what Dan explains, doing extra biasing per field in the SQL
wi
2) Your OPTIMIZE statement does cause mysql to create a temporary table,
which eventually replaces your current one.
I suggest you try something along the lines of this and compare speed:
- LOCK TABLES ..
- CREATE TABLE `` (..) # identical table
- INSERT INTO `` SELECT * FROM `` WHERE date < (NOW(
I am trying to do an update, where item numbers 1-9 get four 0's added
to the front, 10-99 get three 0's etc.
Here is my query so far:
if image_location = 1 to 9
then update inventory_items set image_location = concat("", image_location)
end if
Looking at the mysql manual, it just says to do
haven't followed the complete thread so i don't know what you're
after, but maybe this helps?
SELECT latitude, longitude, SQRT( POW( 69.1 * ( latitude - [startlat]
) , 2 ) + POW( 69.1 * ( [startlng] - longitude ) * COS( latitude /
57.3 ) , 2 ) ) AS distance FROM foobar ORDER BY distance ASC
wher
Hi,
We are deploying a software upgrade and need to convert the MySQL database
of all installations from their previous character set (default) to UTF-8.
I have read the instructions at
http://dev.mysql.com/doc/refman/5.0/en/charset-conversion.html and the
discussion at http://bugs.mysql.com/bug.
On 2/2/07, Jim C. <[EMAIL PROTECTED]> wrote:
I'm having to move some data from MySQL to Postgres. I used mysqldump
--compatible=postgresql, but the compatibility is extremely lacking.
It looks more like the person that designed the schema has payed very
little attention to the SQL standard. You
