Numeric Literal Evaluation Examples
This section provides tutorial examples on how numeric literals are evaluated to values of different datatypes. 2022-10-01, ∼420🔥, 0💬
SQL and Database Terminologies
This section provides brief descriptions of terminologies related to SQl and database. 2022-10-01, ∼419🔥, 0💬
Operations and Functions for Bit Strings
Describes operations and functions for bit strings, sequences of bit values, 0 and 1. 2022-10-01, ∼418🔥, 0💬
Data Literal Evaluation
Describes how data literals will be evaluated into values of particular datatypes based on the expression context. 2022-10-01, ∼414🔥, 0💬
What Is a Stored Procedures
Describes what is a stored procedure - is an executable program that is stored in the database server. 2022-10-01, ∼414🔥, 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, ∼414🔥, 0💬
Flow Control Functions
Describes 4 types of flow control functions: CASE ... WHEN, CASE WHEN, IF and IFNULL. 2022-10-01, ∼413🔥, 0💬
Delete Records That Are Not Referenced
This section provides a tutorial example on bulk deletion for records that are not referenced by another table. 2022-10-01, ∼412🔥, 0💬
Table Column Types for Character Strings
Describes 4 types of table columns to store character strings: CHAR, VARCHAR, NCHAR and NCHAR VARYING. 2022-10-01, ∼411🔥, 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, ∼411🔥, 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, ∼411🔥, 0💬
Operations and Functions for Character Strings
Describes operations and functions for character strings, sequences of characters from predefined character sets. 2022-10-01, ∼409🔥, 0💬
"SHOW STATUS ..." - Server Status Variables
This section describes Server Status Variables, which are counters used by MySQL server to provide statistics information about its running status. 2022-10-01, ∼408🔥, 0💬
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, ∼406🔥, 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, ∼406🔥, 0💬
XML Document Functions
Describes some commonly used XML document functions like, ExtractValue() and UpdateXML(). 2022-10-01, ∼404🔥, 0💬
Bulk Delete with a Simple Condition
This section provides a tutorial example on bulk deletion with a simple condition on a large table. 2022-10-01, ∼404🔥, 0💬
Character String Functions
Describes some commonly used character string functions like, CONCAT(), CHAR_LENGTH(), SUBSTRING(), UPPER(), LOWER(), TRIM(), and POSITION(). 2022-10-01, ∼401🔥, 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, ∼401🔥, 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, ∼401🔥, 0💬
Secondary Index on InnoDB Table
This section describes what is secondary index on an InnoDB table. Any any non-primary index is called secondary index. 2022-10-01, ∼396🔥, 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, ∼395🔥, 0💬
Copyright © 2026 Dr. Herong Yang. All rights reserved.