说明案例sql语言data.pdfVIP

Objectives After completing this lesson, you should be able to do the following: • Describe each data manipulation language (DML) statement • Insert rows into a table • Update rows in a table • Delete rows from a table • Control transactions Lesson Agenda • Adding new rows in a table – INSERTstatement • Changing data in a table – UPDATE statement • Removing rows from a table: – DELETE statement – TRUNCATE statement • Database transactions control using COMMIT, ROLLBACK,