MySQL Ultimate Handbook Flashcards

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/32

flashcard set

Earn XP

Description and Tags

Vocabulary flashcards covering core MySQL database management concepts, SQL commands, data types, constraints, joins, transactions, views, indexes, subqueries, stored procedures, and triggers.

33 Terms

1
New cards

MySQL Workbench

A visual tool used for database development and administration that provides a graphical interface to design databases, write SQL queries, manage servers, create backups, and monitor performance.

2
New cards

Database Management System (DBMS)

Software that allows users to create, store, organize, retrieve, and manage data efficiently, acting as a bridge between users and databases.

3
New cards

Database

A container that stores related data in an organized way, holding one or more tables in MySQL.

4
New cards

INT Data Type

An integer data type in MySQL used for storing whole numbers.

5
New cards

VARCHAR(100) Data Type

A variable-length string data type that stores text up to 100 characters in length.

6
New cards

ENUM Data Type

A string object data type with a value chosen from a predefined list of permitted values.

7
New cards

DECIMAL(10, 2)

An exact numeric data type used for financial data where 10 represents the total number of digits and 2 represents the number of digits after the decimal point.

8
New cards

PRIMARY KEY Constraint

A constraint that uniquely identifies each row in a table, requiring values to be unique and non-NULL, with only one allowed per table.

9
New cards

UNIQUE Constraint

A constraint that ensures all values in a column are different from one another, while permitting one or more NULL values.

10
New cards

AUTO_INCREMENT Attribute

An attribute used with a primary key to automatically generate a unique sequential number for each new row inserted.

11
New cards

CHECK Constraint

A constraint that ensures all values stored in a column satisfy a specific defined condition.

12
New cards

DEFAULT Constraint

A constraint that sets a default value for a column if no value is explicitly provided during row insertion.

13
New cards

ALTER TABLE Statement

An SQL command used to modify the structure of an existing table, such as adding, dropping, modifying, or renaming columns.

14
New cards

AutoCommit Mode

A default setting in MySQL where every SQL statement is treated as an individual transaction and committed automatically.

15
New cards

COMMIT Command

An SQL command used to permanently save all database changes made during the current transaction.

16
New cards

ROLLBACK Command

An SQL command used to undo and revert all changes made since the last COMMIT or ROLLBACK.

17
New cards

Foreign Key

A column or field in one table that links to and references the primary key in another table to maintain data integrity between related tables.

18
New cards

ON DELETE CASCADE

A foreign key action that automatically deletes related child table rows when the referenced parent table row is deleted.

19
New cards

INNER JOIN

A join type that returns only matching rows from both tables based on the specified join condition.

20
New cards

LEFT JOIN

A join type that returns all rows from the left table and matching rows from the right table, returning NULLs when no match exists.

21
New cards

RIGHT JOIN

A join type that returns all rows from the right table and matching rows from the left table, returning NULLs when no match exists.

22
New cards

UNION Operator

An SQL operator used to combine the result sets of two or more SELECT queries into a single result set, automatically removing duplicate rows.

23
New cards

UNION ALL Operator

An SQL operator that combines the result sets of multiple SELECT queries while retaining all duplicate rows.

24
New cards

Self JOIN

A regular join operation in which a table is joined with itself using table aliases to evaluate relationships among rows within the same table.

25
New cards

MySQL View

A virtual table based on the result of a SELECT query that does not store data itself but dynamically reflects live data from base tables.

26
New cards

MySQL Index

A database structure used to speed up data retrieval and row lookup performance on table columns.

27
New cards

Subquery

A query nested inside another SQL statement (such as within SELECT, WHERE, or FROM clauses) used for dynamic filtering or calculations.

28
New cards

HAVING Clause

A clause used to filter grouped data after an aggregation operation has been performed with GROUP BY.

29
New cards

WITH ROLLUP Modifier

A modifier used with GROUP BY to generate summary rows representing subtotals and grand totals.

30
New cards

Stored Procedure

A saved block of SQL code with optional parameters stored in the database for reusable execution.

31
New cards

MySQL Trigger

A stored database program automatically executed in response to specific events (INSERT, UPDATE, or DELETE) on a table.

32
New cards

TRUNCATE TABLE Statement

A fast command that removes all rows from a table while retaining its structure, which cannot be rolled back in most cases.

33
New cards

DISTINCT Keyword

A keyword used in SELECT queries to eliminate duplicate records and return only unique values.