RSRobince Studio

SQL INSERT, UPDATE and DELETE

Besides reading, SQL changes data: INSERT adds rows, UPDATE changes them, DELETE removes them.

Try it yourself

Loading editor…

Always add a WHERE to UPDATE and DELETE, or every row is affected.
SQL COUNT, SUM and GROUP BY SQL JOIN