Introduction to SQL Basics in MySQL

Q

Where to find answers to frequently asked questions on Introduction to SQL Basics in MySQL?

✍: FYIcenter.com

A

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Introduction to SQL Basics in MySQL. Clear answers are provided with tutorial exercises on character and numeric data types; quoting character strings; ASCII and UTF8 character sets; NULL values and NULL conditions; IN and LIKE conditions.

What Is SQL Standard in MySQL

Groups of Data Types in MySQL

Character String Data Types in MySQL

Difference between CHAR and NCHAR in MySQL

Difference between CHAR and VARCHAR in MySQL

Difference between BINARY and VARBINARY in MySQL

Numeric Data Types in MySQL

Date and Time Data Types in MySQL

Evaluating Expressions with SELECT Statements in MySQL

Including Comments in SQL Statements in MySQL

Entering Character Strings in MySQL

Escape Special Characters in MySQL

Concatenating Character Strings in MySQL

Entering Numeric Values in MySQL

Entering Characters as HEX Numbers in MySQL

Entering Numeric Values as HEX Numbers in MySQL

Entering Binary Numbers in MySQL

Entering Boolean Values in MySQL

What Is NULL Value in MySQL

Expressions with NULL Values in MySQL

Converting Numeric Values to Character Strings in MySQL

Converting Character Strings to Numeric Values in MySQL

Using IN Conditions in MySQL

Using LIKE Conditions in MySQL

Using Regular Expression with REGEXP in MySQL

Using CASE Expression in MySQL

⇒ What Is SQL Standard in MySQL

⇐ Returning Query Output in XML Format in MySQL

⇑⇑ MySQL Database Tutorials

2018-04-21, 2897🔥, 0💬