On 19 Dec 2008 15:49:32 GMT, End of Road wrote:

Set your output connection to the charset that you want the data
converted to. That'll mean reading and understanding
http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html very
well, and writing your applications to account for possible data loss
from characters in the database that don't fit into latin1 mapping.

Always use manualy Query
(UPDATE table SET column = replace(column,"-","") WHERE `column` REGEXP '-')

My question:
How to build a "trigger" for the update database which removes the sign "-"?

I am relativly new to MySql so I may be doing this wrong. On a site I
am working on I have a table called block that looks like this:

primary key (auto inc)
owner id (key to account table)
blocked id (key to account table)

Where owner id and blocked id are keys into an account table.
The table has indexes on both the owner id and blocked id fields.

This table is used for users to block contact from other users. For
example if user id #1 didn't want to be contacted by user id #2 then
there would be an entry in the table where owner id = 1, and blocked
id = 2.

For a user to see all the users he has blocked I would select all rows
where owner id = the user who wants to know.

To test if a user is blocked from contacting another user I would
select where the owner id = user to be contacted and blocked id = user
who wants to contact.

This all seems straight forward and logical. The following is where I
wonder if I am doing it right.

Bill H wrote:

Bill H wrote:

flycondor wrote:

flycondor schreef:

(http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html)
"The slow query log consists of all SQL statements that took more than
long_query_time seconds to execute and "

and COMMIT, is a SQL statement...

so, what's the question ?

Hello,

For me the moment I work with Mysql 5.0.41 and 5.0.51 under Windows.
I have just downloaded the last version 5.0.67
(mysql-essential-5.0.67-win32.msi).

How to upgrade each version without losing the configuration and data. Do I
have to reinstall Mysql ?
What is the best way to do that ?

thanks a lot
fabrice

i am trying a few combinations and they dont work.

update rawdatas r, rawdatas r1
set r.Created_at=r1.tradedatetime
where r.id=r1.id and r.processed_indicator is null;
i also tried

update rawdatas r set r.Created_at=r.tradedatetime

where r.processed_indicator is null;

Hello,

If I have the following tables:

first second
Id Foo Id Bar
1 10 3 35
2 20 4 45
3 30

And I want this result:

Id Foo Bar
1 10 NULL
2 20 NULL
3 30 35
4 NULL 45

What kind of JOIN must I use? I can have LEFT or RIGHT, but it seems
that here I would need both simultaneously. I thought there was such a
thing, but I couldn't find it in the manual.

Please help!

Greetings,
Thomas