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
oks 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
---
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!
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 a