IT의 신

마리아 db에서 같은 테이블에서 업데이트를 치려고 하는데 table is specified twice 이런 에러가 났다. 흠.. 구글링을 해보니 The solutions involving SELECT ... FROM (SELECT * FROM table) AS tmp just dump the entire content of a table into a temporary table, which can then be used in any further outer queries, like for example an update query. This forces the order of operations to be: Select everything first into a temporary table and the..