Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
[mySQL] UPDATE problem - possible timeout - HELP!
Hi, I have a problem with the following code: UPDATE History JOIN Kinos SET History.KinoID=Kinos.id WHERE History.Kino=Kinos.Kino; when it's executed phpmyadmin shows only a white page (the left frame is still there) or this: "Proxy Error The proxy server received an invalid response from an... -
WHERE condition doesn't work..... HELP!!!!
I got it :D I don't know why but the entries in tbale city weren't ok. I truncated the tabele and inserted them a second time. Works just fine. Thanks for all the great tips. I wouldn't have known this. -
WHERE condition doesn't work..... HELP!!!!
The problem seems to be in table "City": SELECT CHAR_LENGTH( 'Frankfurt am Main' ) , LENGTH( 'Frankfurt am Main' ) , 'Frankfurt am Main';# Zeilen: 1 SELECT CHAR_LENGTH( City ) , LENGTH( City ) , City FROM Cinemas WHERE City = 'Frankfurt am Main';# Zeilen: 4 SELECT CHAR_LENGTH( City ) ... -
WHERE condition doesn't work..... HELP!!!!
Nothing works :( I tried: UPDATE Cinemas JOIN City ON (Cinemas.City=City.City) SET Cinemas.CityID=City.id; UPDATE Cinemas,City SET Cinemas.CityID=City.id WHERE Cinemas.City=City.City; SELECT Cinemas.City, City.City FROM Cinemas INNER JOIN City ON Cinemas.City=City.City SELECT * FROM Cinemas... -
WHERE condition doesn't work..... HELP!!!!
Hi, I have got two tables. One with a list of cities (table_name: City columns: 2 col_1: id col_2: City) the other one with a list of names of movie theatres in several cities (table_name: Cinemas columns: 16 col_1: id col_2: City col_3... col_16: CityID) I'm trying to UPDATE 'Cinemas'...
