1054 error, unknown column in where clause -

-

i keep getting error when column exist, can tell me why?

this query: 

update testtable2 set testtable2.be = testtable1.`1962` testtable2.`year`= 1962       , testtable2.permno = testtable1.testcolumn

and response:

error code: 1054. unknown column 'testtable1.testcolumn' in 'where clause'

testtable1 structure:

`testcolumn` varchar(255) default null, `firstyear` varchar(255) default null, `lastyear` varchar(255) default null, `1926` varchar(255) default null, `1927` varchar(255) default null, `1928` varchar(255) default null, `1929` varchar(255) default null, `1930` varchar(255) default null, `1931` varchar(255) default null, `1932` varchar(255) default null, `1933` varchar(255) default null, `1934` varchar(255) default null, `1935` varchar(255) default null, `1936` varchar(255) default null, `1937` varchar(255) default null, `1938` varchar(255) default null, `1939` varchar(255) default null, `1940` varchar(255) default null, `1941` varchar(255) default null, `1942` varchar(255) default null, `1943` varchar(255) default null, `1944` varchar(255) default null, `1945` varchar(255) default null, `1946` varchar(255) default null, `1947` varchar(255) default null, `1948` varchar(255) default null, `1949` varchar(255) default null, `1950` varchar(255) default null, `1951` varchar(255) default null, `1952` varchar(255) default null, `1953` varchar(255) default null, `1954` varchar(255) default null, `1955` varchar(255) default null, `1956` varchar(255) default null, `1957` varchar(255) default null, `1958` varchar(255) default null, `1959` varchar(255) default null, `1960` varchar(255) default null, `1961` varchar(255) default null, `1962` varchar(255) default null, `1963` varchar(255) default null, `1964` varchar(255) default null, `1965` varchar(255) default null, `1966` varchar(255) default null, `1967` varchar(255) default null, `1968` varchar(255) default null, `1969` varchar(255) default null, `1970` varchar(255) default null, `1971` varchar(255) default null, `1972` varchar(255) default null, `1973` varchar(255) default null, `1974` varchar(255) default null, `1975` varchar(255) default null, `1976` varchar(255) default null, `1977` varchar(255) default null, `1978` varchar(255) default null, `1979` varchar(255) default null, `1980` varchar(255) default null, `1981` varchar(255) default null, `1982` varchar(255) default null, `1983` varchar(255) default null, `1984` varchar(255) default null, `1985` varchar(255) default null, `1986` varchar(255) default null, `1987` varchar(255) default null, `1988` varchar(255) default null, `1989` varchar(255) default null, `1990` varchar(255) default null, `1991` varchar(255) default null, `1992` varchar(255) default null, `1993` varchar(255) default null, `1994` varchar(255) default null, `1995` varchar(255) default null, `1996` varchar(255) default null, `1997` varchar(255) default null, `1998` varchar(255) default null, `1999` varchar(255) default null, `2000` varchar(255) default null, `2001` varchar(255) default null, ) engine=innodb default charset=utf8

testtable2 structure:

`permno` varchar(255) default null, `year`   varchar(255) default null, `be`     varchar(255) default null

you forgot join them think...

update testtable2 tt2 inner join testtable1 tt1 on     tt1.testcolumn = tt2.permno , tt2.`year`= 1962 set tt2.be = tt1.`1962`

or simpler approach:

update testtable2, testtable1 set testtable2.be = testtable1.`1962 testtable2.`year`= 1962   , testtable2.permno = testtable1.testcolumn

Comments

Post a Comment

Popular posts from this blog

How has firefox/gecko HTML+CSS rendering changed in version 38? -

-
i have a little website header no longer renders correctly, since updating firefox 38.0.5 [the faceplant logo missing top right, , main logo no longer centred]. still renders expected in other browsers. how has engine's rendering changed in update? according mdn , list of changes is: css support ruby-position , ruby-align have been added , available default ( bug 1055676 , bug 1123917 , bug 1039006 ). the :unresolved pseudo-class has been implemented custom elements ( bug 1111633 ). the predefined style ethiopic-numeric uses space, instead of dot, suffix match recent change spec ( bug 1120721 ). css transitions on generated content (with ::before , ::after ) on both inline , block splits them start expected specification ( bug 1110277 ). the implementation of css logical properties made big progress. [...] how css transitions start has been modified match recent change of specifications, aiming @ having interoperable behavio
Read more

javascript - Complex json ng-repeat -

-
i try ng-repeat on object, tried several times still stuck. if have idea, , if it's possible share tips kind of situation. [ { "abonnement": { "id": "1", "nom": "bas prix", "tarif": "2.49", "communication": "2h de communication", "vers": "vers fixes et mobiles", "zone": "zone nationale" } }, { "abonnement": { "id": "2", "nom": "national", "tarif": "9.99", "communication": "t\u00e9l\u00e9phonie et sms illimit\u00e9s", "vers": "vers fixes et mobiles", "zone": "zone nationale" } }, { "abonnement": { "id": "3", "nom": "euro", "tarif&
Read more

jquery - Cloning of rows and columns from the old table into the new with colSpan and rowSpan -

-
i using clone jquery. necessary clone gray area in new table. problem cloned rows , columns can has rowspan , colspan. the gray area intersection data-fix-cols , data-fix-rows. my solution not work: <table id="old-table" data-fix-cols='3' data-fix-rows='4'> <tbody> <tr> <td class="gray">clone me</td> <td colspan="2" rowspan="2" class="gray">clone me</td> <td>ashgabat</td> <td>barcelona</td> <td>berlin</td> </tr> <tr> <td rowspan="3" class="gray">clone me</td> <td>bucharest</td> <td>warsaw</td> <td>washington</td> </tr> <tr> <td class="gray">clone me</td>
Read more