SELECT Statements
A tutorial example is provided on how to use SELECT statements to retrieve from database as multiple rows and multiple fields in each row. 2022-10-01, ∼327🔥, 0💬
Operations and Functions for Bit Strings
Describes operations and functions for bit strings, sequences of bit values, 0 and 1. 2022-10-01, ∼326🔥, 0💬
Character String Functions
Describes some commonly used character string functions like, CONCAT(), CHAR_LENGTH(), SUBSTRING(), UPPER(), LOWER(), TRIM(), and POSITION(). 2022-10-01, ∼326🔥, 0💬
JoinTable.sql - Example of Join Tables
This section provides tutorial examples on how different join operations work: CROSS JOIN, INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN. 2022-10-01, ∼326🔥, 0💬
Data Literal Evaluation
Describes how data literals will be evaluated into values of particular datatypes based on the expression context. 2022-10-01, ∼325🔥, 0💬
What Is Expression
This section provides quick introductions of main expression categories: numeric, character string, bit string, data and time, and time interval. 2022-10-01, ∼325🔥, 0💬
WHERE Clause of a SELECT Statement
This section provides tutorial examples on how to use the WHERE clause to filter rows out of the base table in a SELECT statement. 2022-10-01, ∼325🔥, 0💬
Hex String Literal Evaluation Examples
This section provides tutorial examples on how hex string literals are evaluated to values of different datatypes. 2022-10-01, ∼324🔥, 0💬
MySQL Server File Locations on CentOS
This section provides a tutorial example on how to find and view MySQL Server file locations for MySQL 8.0 server on CentOS 8 systems. 2022-10-01, ∼322🔥, 0💬
UPDATE - Statement to Update Records in Tables
This section provides a tutorial example on how to use UPDATE statements to update records stored in tables. 2022-10-01, ∼321🔥, 0💬
Date and Time Functions
Describes some commonly used date and time functions like, CURRENT_DATE(), CURRENT_TIME(), and EXTRACT(). 2022-10-01, ∼320🔥, 0💬
MySQL Status Variables for InnoDB Engine
This section describes some important MySQL status variables that represent statistic counts related the InnoDB storage engine. 2022-10-01, ∼319🔥, 0💬
Connection URL Tests on Older MySQL Connector/J
Describes the connection URL format test program and result with older MySQL Connector/J releases. 2022-10-01, ∼317🔥, 0💬
XML Document Functions
Describes some commonly used XML document functions like, ExtractValue() and UpdateXML(). 2022-10-01, ∼317🔥, 0💬
Table Column Types for Look Up Values
Describes 2 types of table columns to store look up values: ENUM and SET. 2022-10-01, ∼312🔥, 0💬
Cast Function
Describes the CAST() function, which can be used to convert a value of any datatype to any other datatype. 2022-10-01, ∼310🔥, 0💬
CREATE PROCEDURE - Statement to Create Stored Procedures
This section provides tutorial examples on how to use CREATE PROCEDURE statements to create stored procedures. 2022-10-01, ∼308🔥, 0💬
mysqli_connect() and Other MySQL Functions
Describes functions supported by the MySQL extension library, php_mysql.dll. mysql_connect() creates a connection to the specified MySQL server. 2022-10-01, ∼304🔥, 0💬
Date and Time Operations
This section provides a list of date and time operations supported by SQL and some examples. 2022-10-01, ∼304🔥, 0💬
Copyright © 2026 Dr. Herong Yang. All rights reserved.