Section 1
Preview this deck
mysqli_error
Front
| 5 | 0 | ||
| 4 | 0 | ||
| 3 | 0 | ||
| 2 | 0 | ||
| 1 | 0 |
Active users
0
All-time users
0
Favorites
0
Last updated
4 years ago
Date created
Mar 1, 2020
Cards (88)
Section 1
(50 cards)
mysqli_error
When using mysqli, the ______ function can be used to access a textual description of the most recent error that occurred on the server.
primary key
A table's ______ is used to uniquely identify each item in that table.
NOT NULL
To ensure a column value has a value, when creating the column you must add _____________
mysqli_real_escape_string
Function used to escape special characters in a string for use in an SQL statement
mysqli_select_db
Function used to select the default database to be used when performing queries against the database connection
AUTO_INCREMENT
To have a database column default to the next integer in an ongoing sequence, add ______ quantifier to the columns definition.
Case Sensitive
Although the entire language is not, we need to treat SQL as if it is ________ ________
result set
When executed successfully, the SELECT statement generates a _______, which is conceptually similar to a virtual table in that it can be treated as if its a table when it doesn't actually exist in the database.
CHAR(n)
This SQL datatype allows a input of a specified length where the length is the parameter
database
The overall container for a collection of MySQL data used to represent entities
BLOB
This data type is binary and allows for up to 64kb of data and is typically used for passing images or GIFS
Signed
This word goes after a DOUBLE variable and specifies the value can be below 0. This word will cause the range to be -2.15e+9 to 2.15e+9
daemon
The general name server administrators use to describe server programs that run all day every day without human intervention is _____.
DESCRIBE
Command used to see a database's field formats
purpose
Part of an organized database, __________ is what determines requirements
LOAD DATA
A SQL command that instructs the client to read a text file from disk and insert the data it contains into a database table.
mysqli_query
Function used to perform a query on the database
DROP TABLE IF EXISTS
Command to delete a table if it already exists
column
the name of a field within a row
Unsigned
This word goes after a DOUBLE variable and specifies the value can't be below 0. This word will cause the range to be 0 to 4.29e+9
rows columns
A database table is composed of one or more _____, each of which is composed of one or more ______.
case-insensitive
SQL commands and keywords are _______. The recommended style is uppercase.
TIMESTAMP
To have a database column default to the current date and time at which a row was created, set the datatype of that column to ________.
table
A subcontainer within a database that stores the actual data
natural join
In a relational database when two or more tables are joined together on the basis of common data in shared columns it is called a _________ __________
mysqli_connect
Function used to open a connection to the MySQL server. It takes parameters for host, username, and password.
\c
Canceling a line of input on the command line
VARCHAR(n)
This SQL datatype allows a input up to a certain length where the max length is the parameter
;
Punctuation used by MySQL to separate or end commands
predictability
Part of an organized database, __________ is what is needed to allow location to be easily identified
USE
Command used to switch to a database
ENGINE MyISAM
_____ tells MySQL the type of database engine to use for the creation of a table.
SELECT * FROM
Command used to show all data in a table
HELP CONTENTS
command used to get assistance with SQL Statements
sanitize
The process of eliminating potentially problematic characters from a value prior to using that value within a program is commonly called ________.
API
In order to communicate with a MySQL server from within our PHP program we use mysqli, which is a collection of routines that are installed as a PHP extension and collectively (and generally) known as an _____.
regularity
Part of an organized database, __________ standardizes structure
SOURCE
A SQL command that instructs the client to read a text file from disk and execute its contents as if they were typed interactively by the user.
WHERE
To control which rows of a table an UPDATE statement will effect, you should add a ______ clause.
UNIQUE
To ensure a column value does not have the same value as another column in the same table you must add ________
virtual
The results of a join action can be considered an example of a _____ table
case-sensitive
Table names are ____ on Linux and OSX, but the opposite on Windows. The recommended style is lowercase for tables.
sorting indexing
When it comes to database predictability ___________ rows only allows for one row to be searched at a time and is time consuming. The preferred method to ensure predictability is _________ rows.
CRUD
The conceptual model upon which SQL is constructed is commonly referred to as the ______ model.
row
A single record within a table, which may contain several fields
purpose predictability regularity
In order to be considered a database, a collection of data must possess the properties of organization and _____. The property of organization is generally achieved through ensuring data demonstrates both ______ and _______.
redundancy
When designing a database, it is generally desirable to avoid _____, which is the needless repetition of values stored in the tables.
HELP
command used to get assistance with SQL commands
SHOW
command used to display all databases
EXIT or QUIT
command used to end SQL session
Section 2
(38 cards)