Problem with UPDATE query

Hi! Is it's possible to execute such query in MySQL? update table_name set table1.field1=table2.field2 where table1.key=table2.key Thanx Andis - Before posting, please check: http://www.mysql.com/manual.php

Re: Re: MySQL bug? - problems with character-set

I created character-set myself. Here, in Latvia, we use windows-1257. Problem is, when I use MySQL under Linux, conversation occurs better. Under windows98 I have problems as I wrote before. Cheracter-set I created myself, because included isn't correct. Andis - Original Message

Re: Re: Re: MySQL bug? - problems with character-set latvian.conf [1/3]

From: Andis [EMAIL PROTECTED] To: [EMAIL PROTECTED], Victoria Reznichenko [EMAIL PROTECTED] References: 001d01c2394e$85803740$[EMAIL PROTECTED] [EMAIL PROTECTED] 003601c239ea$f0f7d720$[EMAIL PROTECTED] [EMAIL PROTECTED] 001001c23a13$5ba93280$[EMAIL PROTECTED] Victoria Reznichenko [EMAIL

MySQL bug? - problems with character-set

, under window - wrong, because result contain lower-case and upper-case symbols together It's loks like this:'HErE I tIPED MY LaNGUaGE CHaraCtERS' Now I feel confused, hov I can test, is my conf file. Andis Grasis - Before posting

Re: MySQL bug? - problems with character-set

Hi! It's just a simple example, because I don't want send latvian-specific symbols. This problem occurs with latvian-specific symbols only. Configuration file I cheked some 4-5 times. I'm confused now. Regards from Latvia! Andis Grasis - Original Message - From: Victoria Reznichenko

Waste of data while using MySQL database

in this situation (users waste what them did). As I understand, MySQL server don't write data on disc immediatly, but after some time. What can I do for saving data regularly (for example once at hour or something like that)? With best regards - Andis Grasis Latvia

How connect MsAccess to MySQL

Hi! I used ODBC driver to connect to MySQL server from MsAccess. Is there another method how I can get data from MySQL and show it's in MsAccess forms? Thanks for any response! Andis

Case insensitive records search

! Andis

How create another language support under MySQL???

any support for Latvian language. How is possible correct this problem? Andis

How about Latvian language support?

I'm from Latvia. Currently my database contain words, which contain Latvian specific characters. MySQL works under RedHat6.2. Is anybody now how is possible to teach MySQL correctly sort textual strings with Latvian characters? Andis

Tables relationships

uch things and if Yes then - how it's could be realised Help me please! Andis. P.S. Sorry about my English.