Generalizations, Learn SQL, Codecademy, Manipulation

Lesson Summary

In this lesson, we go over the 6 commands we learned so far. The "CREATE TABLE" command allows us to create a new table. The "INSERT INTO" command allows us to insert data into a row of a table. The "SELECT" key word allows us to query data from a table. "UPDATE" allows us to edit a certain row of a tbale. "ALTER TABLE" allows us to change an existing table. Finally, the "DELETE FROM" command allows us to delete a row from a specified table.

Subscribe To Monthly Newsletter. Chance to Win Monthly Prizes

* indicates required