Selectの結果をInsertする by PostgreSQL

Nov 30, 2014

AD:

いろいろなやり方を試したのですが、fieldsをはじめに指定する下記の方法でやると型の問題でエラーがでなくなりましたので、メモ

INSERT INTO users (name,email,group_id)
SELECT name,email,43
FROM users WHERE group_id = 1;

INSERT INTO users (name,email,group_id)

SELECT name,email,43

FROM users WHERE group_id = 1;

AD:

No Comments, Comment or Ping

Reply to “Selectの結果をInsertする by PostgreSQL”

Warning: Undefined variable $user_ID in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/themes/grid_focus_public_mizo/comments.php on line 66

You must be logged in to post a comment.

Selectの結果をInsertする by PostgreSQL

No Comments, Comment or Ping

Reply to “Selectの結果をInsertする by PostgreSQL”

Search Keyword

Meta

FacebookPage

Popular Posts

My Tags

Status

Links

ARCHIVES