Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

IT207 - Databases and MySQL

memorize.ai (lvl 286)

(0)

32 cards

()

Section 1

Preview this deck

SELECT

Front

1 / 32

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (32)

Section 1

(32 cards)

SELECT

Front

retrieves records from a table

Back

COUNT()

Front

returns the number of rows (*) can be used as a function argument instead of a field name, which returns the number of rows in the table

Back

AND, OR

Front

can be used with SELECT to specify more detailed conditions about the records you want to return

Back

mysqli_free_result()

Front

php function that closes a resultset and frees system memory

Back

mysqli_fetch_assoc()

Front

php function that returns the fields in the current row of a resultset into an associative array and moves the result pointer to the next row

Back

junction table

Front

Creates a one-to-many relationship for each of the two tables in a many-to-many relationship contains foreign keys from the two tables

Back

field

Front

each column in a database table; the individual categories of information stored in a record

Back

mysqli_connect()

Front

php function that opens a connection to a specified MySQL database needs to be closed by the mysqli_close() function

Back

query

Front

a structured set of instructions and criteria for retrieving, adding, modifying, and deleting database information

Back

primary table

Front

the main table in a relationship that is referenced by another table

Back

database

Front

an ordered collection of information from which a computer program can quickly access information

Back

normalization

Front

breaking tables into multiple related tables to reduce redundant and duplicate information reduces the size of a database, decreases the opportunity for error

Back

mysqli_fetch_row()

Front

php function that returns the fields in the current row or a value of FALSE when it reaches the last row in the resultset

Back

DISTINCT

Front

can be used with the SELECT statement to retrieve records with different values in a column

Back

INSERT

Front

add individual records to a table

Back

one to one relationship

Front

exists between two tables when a related table contains exactly on record for each record in the primary table breaks information into multiple, logical sets

Back

ALTER TABLE

Front

The SQL command used to make changes to table structure. When the command is followed by a keyword (ADD or MODIFY), it adds a column or changes column characteristics.

Back

foreign key

Front

a field in a related table that refers to the primary key in the primary table; link records across multiple tables in a relational database

Back

many to many relationship

Front

exists in a relational database when many records in one table are related to many records in another table

Back

database management system (DBMS)

Front

an application or collection of applications used to access and manage a database

Back

schema

Front

the structure of a database including its tables, fields and relationships

Back

ORDER BY clause

Front

used with the SELECT statement to perform an alphanumeric sort of the results returned from a query

Back

related table/child table

Front

references the primary table in a relational database

Back

DESC keyword

Front

Used to sort data in descending order

Back

DROP TABLE

Front

A SQL command used to delete database objects such as tables, views, indexes, and users.

Back

primary key

Front

a field that contains a unique identifier for each record in a primary table which identifies records in a database to make retrievals and sorting faster PK = minimal super key superkey = uniquely identifies a row

Back

GROUP BY clause

Front

used to retrieve aggregate values for groups of records

Back

result pointer

Front

a special variable that represents the results of a query

Back

one to many relationship

Front

exists in a relational database when one record in a primary table has many related records in a related table

Back

mysqli_query()

Front

php function that sends SQL statements to MySQL; returns a result pointer that represents the query results or TRUE if the statement executes successfully, or FALSE for any SQL statements that fail

Back

structured query language (SQL)

Front

a standard data manipulation language used among many DBMS common keywords: DELETE, FROM, INSERT, INTO, ORDER BY, SELECT, UPDATE, WHERE

Back

record

Front

each row in a database table; a single complete set of related information

Back