Tables & Data Types Flashcards
Creating and Editing Tables (Schema)
1
Q
INT
A
Integer
2
Q
DECIMAL (M,N)
A
Decimals. (M) Total number of digits, (N) Digits after the decimal point
3
Q
VARCHAR (1)
A
String - (num)Max number of characters allowed
4
Q
BLOB
A
Binary Large Object - Stores large data (images, etc)
5
Q
DATE
A
YYYY-MM-DD
6
Q
TIMESTAMP
A
YYYY-MM-DD HH:MM:SS - used for recording
7
Q
ALL CAPS
A
Convention for typing RESERVED WORDS. Easily distinguish between code and general text
