MySQL Final Study Guide - Chapters 1 - 11 Quizes

SELECT - Answer- You can use the AS keyword with the CREATE TABLE statement to create a copy of a table from a ____________________ statement. SELECT DELETE WHERE LIKE DELETE - Answer- By default, MySQL automatically commits changes to the database immediately after each INSERT, UPDATE, and ______________ statement that you issue. ON DELETE AS COMMIT null - Answer- When you code a column list in an INSERT statement, you can omit columns with default values and columns that allow ____________________________ values. string open null quote subquery select - Answer- To insert rows selected from one or more tables into another table with an INSERT statement, you code a/an ___________________________ in place of the VALUES clause. subquery select join close like WHERE - Answer- When you code an UPDATE statement for one or more rows, the SET clause names the columns to be updated and the values to be assigned to those columns, and the ______________________ clause specifies the conditions a row must meet to be updated. JOIN SELECT GET WHERE