It's also the simplest use case of INSERT imaginable and fails to be applicable ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		netule on Sept 30, 2022 \| parent \| context \| favorite \| on: Select * from cloud It's also the simplest use case of INSERT imaginable and fails to be applicable with a slightly more complex one: `INSERT INTO table1 (col_1, col_2, col3) SELECT COUNT(col_6), col_4, col_5 FROM table2 INNER JOIN...`

dllthomas on Sept 30, 2022 [–]

I think in principle we could allow

    INSERT INTO table1
        col_1 = COUNT(table2.col_6),
        col_2 = table2.col_4,
        col3 = table2.col_5
    FROM table2 INNER JOIN ...

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact