\documentclass[10pt,a4paper]{article}

% Packages
\usepackage{fancyhdr}           % For header and footer
\usepackage{multicol}           % Allows multicols in tables
\usepackage{tabularx}           % Intelligent column widths
\usepackage{tabulary}           % Used in header and footer
\usepackage{hhline}             % Border under tables
\usepackage{graphicx}           % For images
\usepackage{xcolor}             % For hex colours
%\usepackage[utf8x]{inputenc}    % For unicode character support
\usepackage[T1]{fontenc}        % Without this we get weird character replacements
\usepackage{colortbl}           % For coloured tables
\usepackage{setspace}           % For line height
\usepackage{lastpage}           % Needed for total page number
\usepackage{seqsplit}           % Splits long words.
%\usepackage{opensans}          % Can't make this work so far. Shame. Would be lovely.
\usepackage[normalem]{ulem}     % For underlining links
% Most of the following are not required for the majority
% of cheat sheets but are needed for some symbol support.
\usepackage{amsmath}            % Symbols
\usepackage{MnSymbol}           % Symbols
\usepackage{wasysym}            % Symbols
%\usepackage[english,german,french,spanish,italian]{babel}              % Languages

% Document Info
\author{beeftornado}
\pdfinfo{
  /Title (mysql-5-7-data-types.pdf)
  /Creator (Cheatography)
  /Author (beeftornado)
  /Subject (MySQL 5.7 Data Types Cheat Sheet)
}

% Lengths and widths
\addtolength{\textwidth}{6cm}
\addtolength{\textheight}{-1cm}
\addtolength{\hoffset}{-3cm}
\addtolength{\voffset}{-2cm}
\setlength{\tabcolsep}{0.2cm} % Space between columns
\setlength{\headsep}{-12pt} % Reduce space between header and content
\setlength{\headheight}{85pt} % If less, LaTeX automatically increases it
\renewcommand{\footrulewidth}{0pt} % Remove footer line
\renewcommand{\headrulewidth}{0pt} % Remove header line
\renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit
% This two commands together give roughly
% the right line height in the tables
\renewcommand{\arraystretch}{1.3}
\onehalfspacing

% Commands
\newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour
\newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols
\newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns
\newcommand{\tn}{\tabularnewline} % Required as custom column type in use

% Font and Colours
\definecolor{HeadBackground}{HTML}{333333}
\definecolor{FootBackground}{HTML}{666666}
\definecolor{TextColor}{HTML}{333333}
\definecolor{DarkBackground}{HTML}{A3A3A3}
\definecolor{LightBackground}{HTML}{F3F3F3}
\renewcommand{\familydefault}{\sfdefault}
\color{TextColor}

% Header and Footer
\pagestyle{fancy}
\fancyhead{} % Set header to blank
\fancyfoot{} % Set footer to blank
\fancyhead[L]{
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{C}
    \SetRowColor{DarkBackground}
    \vspace{-7pt}
    {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent
        \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}}
    }
\end{tabulary}
\columnbreak
\begin{tabulary}{11cm}{L}
    \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{MySQL 5.7 Data Types Cheat Sheet}}}} \\
    \normalsize{by \textcolor{DarkBackground}{beeftornado} via \textcolor{DarkBackground}{\uline{cheatography.com/66503/cs/16598/}}}
\end{tabulary}
\end{multicols}}

\fancyfoot[L]{ \footnotesize
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{LL}
  \SetRowColor{FootBackground}
  \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}}  \\
  \vspace{-2pt}beeftornado \\
  \uline{cheatography.com/beeftornado} \\
  \end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}}  \\
   \vspace{-2pt}Published 8th August, 2018.\\
   Updated 8th August, 2018.\\
   Page {\thepage} of \pageref{LastPage}.
\end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}}  \\
  \SetRowColor{white}
  \vspace{-5pt}
  %\includegraphics[width=48px,height=48px]{dave.jpeg}
  Measure your website readability!\\
  www.readability-score.com
\end{tabulary}
\end{multicols}}




\begin{document}
\raggedright
\raggedcolumns

% Set font size to small. Switch to any value
% from this page to resize cheat sheet text:
% www.emerson.emory.edu/services/latex/latex_169.html
\footnotesize % Small font.

\begin{multicols*}{2}

\begin{tabularx}{8.4cm}{x{2.016 cm} x{1.656 cm} x{1.872 cm} x{1.656 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{4}{x{8.4cm}}{\bf\textcolor{white}{Numeric Types}}  \tn
% Row 0
\SetRowColor{LightBackground}
 & Signed & Unsigned & Storage \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
TINYINT & 127 & 255 & 1 byte \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
SMALLINT & 32K & 65K & 2 bytes \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
MEDIUMINT & 8M & 16M & 3 bytes \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
INT & 2\textasciicircum{}31\textasciicircum{} & 2\textasciicircum{}32\textasciicircum{} & 4 bytes \tn 
% Row Count 5 (+ 1)
% Row 5
\SetRowColor{white}
BIGINT & 2\textasciicircum{}63\textasciicircum{}-1 & 2\textasciicircum{}64\textasciicircum{}-1 & 8 bytes \tn 
% Row Count 6 (+ 1)
% Row 6
\SetRowColor{LightBackground}
FLOAT &  &  & 4 bytes \tn 
% Row Count 7 (+ 1)
% Row 7
\SetRowColor{white}
DOUBLE &  &  & 8 bytes \tn 
% Row Count 8 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}----}
\SetRowColor{LightBackground}
\mymulticolumn{4}{x{8.4cm}}{2\textasciicircum{}24\textasciicircum{} = 16M \newline 2\textasciicircum{}31\textasciicircum{} = 2B \newline 2\textasciicircum{}32\textasciicircum{} = 4B}  \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}----}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{1.6 cm} x{6.4 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Date and Time Types}}  \tn
% Row 0
\SetRowColor{LightBackground}
YEAR & 1 byte \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
DATE & 3 bytes \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
TIME & 3 bytes + fractional seconds storage \tn 
% Row Count 4 (+ 2)
% Row 3
\SetRowColor{white}
\seqsplit{DATETIME} & 5 bytes + fractional seconds storage \tn 
% Row Count 6 (+ 2)
% Row 4
\SetRowColor{LightBackground}
\seqsplit{TIMESTAMP} & 4 bytes + fractional seconds storage \tn 
% Row Count 8 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{NOTE ON CHARSET}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{To calculate the number of bytes used to store a particular CHAR, VARCHAR, or TEXT column value, you must take into account the character set used for that column and whether the value contains multibyte characters. In particular, when using a utf8 Unicode character set, you must keep in mind that not all characters use the same number of bytes. utf8mb3 and utf8mb4 character sets can require up to three and four bytes per character, respectively. \newline % Row Count 10 (+ 10)
All columns share a {\bf{maximum row size}} of 65,535 bytes, excluding BLOB and TEXT columns.% Row Count 12 (+ 2)
} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{\{\{link="https://dev.mysql.com/doc/refman/5.7/en/storage-requirements.html"\}\}Official Documentation\{\{/link\}\}}  \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{1.92 cm} x{6.08 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{String Types}}  \tn
% Row 0
\SetRowColor{LightBackground}
\seqsplit{CHAR(`M`)} & `M` bytes, up to 255 \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
\seqsplit{BINARY(`M`)} & `M` bytes, up to 255 \tn 
% Row Count 3 (+ 2)
% Row 2
\SetRowColor{LightBackground}
\seqsplit{VARCHAR(`M`)} & `M` + 1 bytes, up to 255 \tn 
% Row Count 5 (+ 2)
% Row 3
\SetRowColor{white}
 & `M` + 2 bytes, more than 255 (65KB) \tn 
% Row Count 7 (+ 2)
% Row 4
\SetRowColor{LightBackground}
TINYBLOB & `L` + 1 bytes, where `L` \textless{} 2\textasciicircum{}8\textasciicircum{} \tn 
% Row Count 9 (+ 2)
% Row 5
\SetRowColor{white}
TINYTEXT & `L` + 1 bytes, where `L` \textless{} 2\textasciicircum{}8\textasciicircum{} (256B) \tn 
% Row Count 11 (+ 2)
% Row 6
\SetRowColor{LightBackground}
TEXT & `L` + 2 bytes, where `L` \textless{} 2\textasciicircum{}16\textasciicircum{} (65KB) \tn 
% Row Count 13 (+ 2)
% Row 7
\SetRowColor{white}
BLOB & `L` + 2 bytes, where `L` \textless{} 2\textasciicircum{}16\textasciicircum{} \tn 
% Row Count 15 (+ 2)
% Row 8
\SetRowColor{LightBackground}
\seqsplit{MEDIUMTEXT} & `L` + 3 bytes, where `L` \textless{} 2\textasciicircum{}24\textasciicircum{} (16MB) \tn 
% Row Count 17 (+ 2)
% Row 9
\SetRowColor{white}
\seqsplit{MEDIUMBLOB} & `L` + 3 bytes, where `L` \textless{} 2\textasciicircum{}24\textasciicircum{} \tn 
% Row Count 19 (+ 2)
% Row 10
\SetRowColor{LightBackground}
LONGTEXT & `L` + 4 bytes, where `L` \textless{} 2\textasciicircum{}32\textasciicircum{} (4GB) \tn 
% Row Count 21 (+ 2)
% Row 11
\SetRowColor{white}
LONGBLOB & `L` + 4 bytes, where `L` \textless{} 2\textasciicircum{}32\textasciicircum{} \tn 
% Row Count 23 (+ 2)
% Row 12
\SetRowColor{LightBackground}
JSON & `L` + 4 bytes, where `L` \textless{} 2\textasciicircum{}32\textasciicircum{} \tn 
% Row Count 25 (+ 2)
% Row 13
\SetRowColor{white}
ENUM & 1 or 2 bytes (65K max values) \tn 
% Row Count 26 (+ 1)
% Row 14
\SetRowColor{LightBackground}
SET & 1, 2, 3, 4, or 8 bytes (64 max values) \tn 
% Row Count 28 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{2\textasciicircum{}8\textasciicircum{} = 256 \newline 2\textasciicircum{}16\textasciicircum{} = 65K \newline 2\textasciicircum{}24\textasciicircum{} = 16M \newline 2\textasciicircum{}32\textasciicircum{} = 4B}  \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}


% That's all folks
\end{multicols*}

\end{document}