Problem with UPDATE query

[Andis Grasis]

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   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL bug? - problems with character-set

[Andis Grasis]

Hi!

I tested MySQL 3.23.51 under Windows and 3.23.49 under Linux RedHat 7.3 with
such SQL:

select lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS')

and recieved different results (of course, I used same config file with
case-sensitive configuration).
Result under Linux looks better, 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, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Case insensitive records search

[Andis Grasis]

Hi!

I have such SQL :

select CompanyName from Company where CompanyName like '%car%'

Really I need in query result all of companys, which contains symbols CAR in any case 
(car, Car,CAr, CAR, e.t.c).
I think that I need Case insensitive records search.

Is it's possible and how?

Thanks a lot!

Andis

Tables relationships

[Andis Grasis]

Is it's possible to make some kind of relationships between tables as it's realised in 
MsAccess. In MsAccess databases it's called "Enforce referential integerity" and it's 
have some subchoises: 1)cascade update related fields and 2)cascade delete related 
records. Is MySQL realize such things and if Yes then - how it's could be 
realised

Help me please!

Andis.

P.S. Sorry about my English.