Shared Flashcard Set

Details

MySQL Chapter 06
N/A
12
Computer Science
Undergraduate 2
04/25/2011

Additional Computer Science Flashcards

 


 

Cards

Term
How to create a new table and populate it with data from an existing table
Definition
CREATE TABLE command for structure
INSERT INTO ___
SELECT ___
FROM ___
WHERE ___
Term
Changes in table structure
Definition
ALTER command
Term
ALTER command options
Definition
ADD
MODIFY
DROP
Term
ADD
Definition
Adds a column
Term
MODIFY
Definition
Changes column characteristics
Term
DROP
Definition
Deletes a column
Term
Changes made to table contents are not physically saved on disk until
Definition
Database is closed
Program is closed
COMMIT command is used
Term
COMMIT command
Definition
Will permanently save any changes made to any table's contents in the database
Term
ROLLBACK
Definition
Undoes changes since last COMMIT
Term
COMMIT and ROLLBACK
Definition
Only work with DML commands to add, modify, or delete table rows
Support transactions
Term
Transaction
Definition
A logical unit of work
Sequence of steps that accomplish a single task
Term
Practice Problems
Definition
Slide 6 , 14
Supporting users have an ad free experience!