Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
PHP Ch 4 MySQL

PHP Ch 4 MySQL

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(0)
(0)
23 cards
()
Section 1

Preview this deck

select now()

Front

1 / 23

PHPSQL
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (23)

Section 1

(23 cards)

select now()

Front

displays the current date and time

Back

floats (4 byte precision), doubles (8 byte precision), decimals (exact as possible). Just use decimal

Front

floats in mysql

Back

nvarchar(100) (the n stands for unicode and is preferred)

Front

memory space is reduced if less than 100 characters.

Back

TINYINT(1 OR 0);

Front

MySQL's boolean type is ___ with 0 = False and 1 = True.

Back

1. Windows + R 2. Type cmd 3. Enter the mySQL path

Front

First steps to use MySQL

Back

C.R.U.D

Front

create, read, update and delete, are the four basic functions of persistent storage for databases.

Back

Index

Front

An __ of a database is a way of keeping an eye on a value of a column(s) for faster retrieve time, but slower update time.

Back

MySQL

Front

The most common version of the Structured Query Language, a language for creating, maintaining, and querying a database.

Back

Ctrl + Enter

Front

execute current statement

Back

varchar[length]

Front

String data type used when you have varying string lengths (pg 115 - 16)

Back

string, number, datetime

Front

3 general Column data types?

Back

Unsigned

Front

Only zeros and positive numbers

Back

EXIT (or QUIT)

Front

Commands used to exit the client. Does not require a semicolon.

Back

Not Null

Front

The clause in a CREATE TABLE command used to indicate which columns cannot contain null values

Back

drop and create example

Front

Example

Back

Key

Front

Primary Key Auto_Increment

Back

Summary

Front

1. Determine Database ,Table, Column names 2. Types (Text, Numbers, Dates) DataTypes (pg. 115) 3. Null or Not Null 4. Identify the Primary Key 5. Assign numeric types UNSIGNED if no negatives will exist

Back

localhost/phpMyAdmin

Front

URL used to access databases. Databases are shown on the left.

Back

char(100)

Front

100 memory space is taken up, even if you don't see it.

Back

char[length]

Front

String data type to use when you know the length of characters for a string. (pg 115 - 16)

Back

unsigned, not null, default value, auto_increment

Front

4 Column properties?

Back

Ctrl + Shift + Enter

Front

Execute everything

Back

4. Enter USE test;

Front

the USE command selects the database to be used. 'test' is a default database that is provided.

Back