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
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
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
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
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 `table_tmp` (..) # identical table
- INSERT INTO `table_tmp` SELECT * FROM
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