mysql:12645
From: "F.Y" <"F.Y" <fumi_sby@xxxxxxxxxx>>
Date: Wed, 18 Jan 2006 09:07:15 +0900 (JST)
Subject: [mysql 12645] Re: Insert 構文で alias って使えない?
insert into tbl_name(col_name1, col_name2) select col_name2 + 1 from tbl_name where col_name1 = 'aaa'; と書かない理由は何? > おっしゃるとおり、一旦サブクエリの値を取り出すしかないようです. > > スッキリしました. -------------------------------------- GANBARE! NIPPON! Yahoo! JAPAN JOC OFFICIAL INTERNET PORTAL SITE PARTNER http://pr.mail.yahoo.co.jp/ganbare-nippon/
12642 2006-01-17 21:19 [Shuichi Nakagawa <na] Insert構文でaliasって使えない? 12643 2006-01-18 07:02 ┗[oppara <mlml@xxxxxxx] 12644 2006-01-18 08:29 ┗[Shuichi Nakagawa <na] -> 12645 2006-01-18 09:07 ┗["F.Y" <fumi_sby@xxxx] 12646 2006-01-18 09:27 ┣["F.Y" <fumi_sby@xxxx] 12647 2006-01-18 09:37 ┃┗["F.Y" <fumi_sby@xxxx] 12648 2006-01-18 09:58 ┗[Shuichi Nakagawa <na] 12649 2006-01-18 10:12 ┗["F.Y" <fumi_sby@xxxx] 12650 2006-01-18 10:40 ┗[Shuichi Nakagawa <na] 12651 2006-01-18 11:40 ┗[Shuichi Nakagawa <na]