Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

MYSQL > Keywords > Flashcards

Keywords Flashcards

1
Q

ADD

A

Adds a column in an existing table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

ADD CONSTRAINT

A

Adds a constraint after a table is already created

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

ALTER

A

Adds, deletes, or modifies columns in a table, or changes the data type of a column in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

ALTER COLUMN

A

Changes the data type of a column in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

ALTER TABLE

A

Adds, deletes, or modifies columns in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

ALL

A

Returns true if all of the subquery values meet the condition

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

AND

A

Only includes rows where both conditions is true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

ANY

A

Returns true if any of the subquery values meet the condition

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

AS

A

Renames a column or table with an alias

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

ASC

A

Sorts the result set in ascending order

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

BACKUP DATABASE

A

Creates a back up of an existing database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

BETWEEN

A

Selects values within a given range

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

CASE

A

Creates different outputs based on conditions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

CHECK

A

A constraint that limits the value that can be placed in a column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

COLUMN

A

Changes the data type of a column or deletes a column in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

CONSTRAINT

A

Adds or deletes a constraint

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

CREATE

A

Creates a database, index, view, table, or procedure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

CREATE DATABASE

A

Creates a new SQL database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

CREATE INDEX

A

Creates an index on a table (allows duplicate values)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

CREATE OR REPLACE VIEW

A

Updates a view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

CREATE TABLE

A

Creates a new table in the database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

CREATE PROCEDURE

A

Creates a stored procedure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

CREATE UNIQUE INDEX

A

Creates a unique index on a table (no duplicate values)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

CREATE VIEW

A

Creates a view based on the result set of a SELECT statement

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

DATABASE

A

Creates or deletes an SQL database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

DEFAULT

A

A constraint that provides a default value for a column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

DELETE

A

Deletes rows from a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

DESC

A

Sorts the result set in descending order

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

DISTINCT

A

Selects only distinct (different) values

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

DROP

A

Deletes a column, constraint, database, index, table, or view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

DROP COLUMN

A

Deletes a column in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

DROP CONSTRAINT

A

Deletes a UNIQUE, PRIMARY KEY, FOREIGN KEY, or CHECK constraint

33
Q

DROP DATABASE

A

Deletes an existing SQL database

34
Q

DROP DEFAULT

A

Deletes a DEFAULT constraint

35
Q

DROP INDEX

A

Deletes an index in a table

36
Q

DROP TABLE

A

Deletes an existing table in the database

37
Q

DROP VIEW

A

Deletes a view

38
Q

EXEC

A

Executes a stored procedure

39
Q

EXISTS

A

Tests for the existence of any record in a subquery

40
Q

FOREIGN KEY

A

A constraint that is a key used to link two tables together

41
Q

FROM

A

Specifies which table to select or delete data from

42
Q

FULL OUTER JOIN

A

Returns all rows when there is a match in either left table or right table

43
Q

GROUP BY

A

Groups the result set (used with aggregate functions: COUNT, MAX, MIN, SUM, AVG)

44
Q

HAVING

A

Used instead of WHERE with aggregate functions

45
Q

IN

A

Allows you to specify multiple values in a WHERE clause

46
Q

INDEX

A

Creates or deletes an index in a table

47
Q

INNER JOIN

A

Returns rows that have matching values in both tables

48
Q

INSERT INTO

A

Inserts new rows in a table

49
Q

INSERT INTO SELECT

A

Copies data from one table into another table

50
Q

IS NULL

A

Tests for empty values

51
Q

IS NOT NULL

A

Tests for non-empty values

52
Q

JOIN

A

Joins tables

53
Q

LEFT JOIN

A

Returns all rows from the left table, and the matching rows from the right table

54
Q

LIKE

A

Searches for a specified pattern in a column

55
Q

LIMIT

A

Specifies the number of records to return in the result set

56
Q

NOT

A

Only includes rows where a condition is not true

57
Q

NOT NULL

A

A constraint that enforces a column to not accept NULL values

58
Q

OR

A

Includes rows where either condition is true

59
Q

ORDER BY

A

Sorts the result set in ascending or descending order

60
Q

OUTER JOIN

A

Returns all rows when there is a match in either left table or right table

61
Q

PRIMARY KEY

A

A constraint that uniquely identifies each record in a database table

62
Q

PROCEDURE

A

A stored procedure

63
Q

RIGHT JOIN

A

Returns all rows from the right table, and the matching rows from the left table

64
Q

ROWNUM

A

Specifies the number of records to return in the result set

65
Q

SELECT

A

Selects data from a database

66
Q

SELECT DISTINCT

A

Selects only distinct (different) values

67
Q

SELECT INTO

A

Copies data from one table into a new table

68
Q

SELECT TOP

A

Specifies the number of records to return in the result set

69
Q

SET

A

Specifies which columns and values that should be updated in a table

70
Q

TABLE

A

Creates a table, or adds, deletes, or modifies columns in a table, or deletes a table or data inside a table

71
Q

TOP

A

Specifies the number of records to return in the result set

72
Q

TRUNCATE TABLE

A

Deletes the data inside a table, but not the table itself

73
Q

UNION

A

Combines the result set of two or more SELECT statements (only distinct values)

74
Q

UNION ALL

A

Combines the result set of two or more SELECT statements (allows duplicate values)

75
Q

UNIQUE

A

A constraint that ensures that all values in a column are unique

76
Q

UPDATE

A

Updates existing rows in a table

77
Q

VALUES

A

Specifies the values of an INSERT INTO statement

78
Q

VIEW

A

Creates, updates, or deletes a view

79
Q

WHERE

A

Filters a result set to include only records that fulfill a specified condition

MYSQL (19 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions