Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Lecture 8: My SqL database PHP

memorize.ai (lvl 286)

(0)

9 cards

()

Section 1

Preview this deck

To identify a field as a primary key in MySQL

Front

1 / 9

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 (9)

Section 1

(9 cards)

To identify a field as a primary key in MySQL

Front

include the PRIMARY KEY keywords when you first define a field with the CREATE TABLE statement

Back

bulletproofing

Front

Writing code that anticipates and handles potential problems

Back

A result pointer

Front

a special type of variable that refers to the currently selected row in a resultset

Back

mysqli_query()

Front

function to send SQL statements to MySQL

Back

LOAD DATA

Front

statement and the mysqli_query() function with a local text file to add multiple records to a database

Back

AUTO_INCREMENT

Front

keyword is often used with a primary key to generate a unique ID for each new row in a table

Back

mysqli_ num_rows()

Front

find the number of records returned from the query

Back

PHP includes functionality

Front

allows you to work directly with different types of databases, without going through ODBC

Back

The error control operator (@)

Front

suppresses error messages

Back