add missing column alias to the select portion of insert statements
Those that came before me had a habit of not adding these and it becomes a pain point when debugging.
--ex of how it looks like now
INSERT INTO desttable
(
id
,name
,phone
)
SELECT
code AS id
,user
,tel
FROM origintable
--what I would like the addon to do
INSERT INTO desttable
(
id
,name
,phone
)
SELECT
code AS id
,user AS name
,tel AS phone
FROM origintable
1
vote
Anonymous
shared this idea