もらったEXCELデータからUPDATE文を一括で作成したい時にたまに使うのでメモ
="UPDATE データベース名 SET カラム名='"& B2 & "' WHERE カラム名='" & A2 & "';"
Qiita Teams that are logged in
You are not logged in to any team
Log in to Qiita Team
Community
OrganizationAdvent CalendarQiitadon (β)Service
Qiita JobsQiita ZineQiita Blog1
Improve article
Send edit requestArticle information
RevisionsEdit RequestsShow all likersShow article in MarkdownReport article
More than 1 year has passed since last update.
1
Improve article
Send edit requestArticle information
RevisionsEdit RequestsShow all likersShow article in MarkdownReport article
Why not register and get more from Qiita?
- We will deliver articles that match youBy following users and tags, you can catch up information on technical fields that you are interested in as a whole
- you can read useful information later efficientlyBy "stocking" the articles you like, you can search right away
1
Improve article
Send edit requestArticle information
RevisionsEdit RequestsShow all likersShow article in MarkdownReport article
Comments