Popular Books:
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, 176🔥, 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, 175🔥, 0💬
Introduction of Datatype
This section provides quick introductions of datatypes supported by SQL: Character String, Bit String, Exact Number, Approximate Number, Date and Time. 2022-10-01, 173🔥, 0💬
Operations and Functions for Bit Strings
Describes operations and functions for bit strings, sequences of bit values, 0 and 1. 2022-10-01, 171🔥, 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, 171🔥, 0💬
System Variables Like @@version
This section provides a quick introduction on system variables, which are used by MySQL server to represent system information or control system behaviors. 2022-10-01, 171🔥, 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, 169🔥, 0💬
Arithmetic Operations
This section provides a list of numeric operations supported by SQL and some examples. 2022-10-01, 169🔥, 0💬
"SHOW" - Show Server Information
This section provides a tutorial on how to use 'show' statements to display MySQL server information. 2022-10-01, 168🔥, 0💬
UPDATE with Joined Tables
This section provides a tutorial example on how to use UPDATE statements to update records in one or multiple tables with joined tables. 2022-10-01, 165🔥, 0💬
ORDER BY Clause of a SELECT Statement
This section provides tutorial examples on how to use the ORDER BY clause to sort rows of the base table according to the given order. 2022-10-01, 162🔥, 0💬
InnoDB Table with Long Rows
This section provides a tutorial example showing index pages and data pages for an InnoDB table with long rows, about 1812 bytes. 2022-10-01, 162🔥, 0💬
Date and Time Operations
This section provides a list of date and time operations supported by SQL and some examples. 2022-10-01, 161🔥, 0💬
Flow Control Functions
Describes 4 types of flow control functions: CASE ... WHEN, CASE WHEN, IF and IFNULL. 2022-10-01, 161🔥, 0💬
Table Column Types for LOB (Large OBject)
Describes 8 types of table columns to store LOB (Large OBject) data: TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB, TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT. 2022-10-01, 161🔥, 0💬
Convert Table to InnoDB Storage Engine
This section provides a tutorial example on how to convert a database table from MyISAM to InnoDB engine without taking the MySQL server offline. 2022-10-01, 158🔥, 0💬
General Guidelines on Bulk Changes
This section provides a tutorial on how to install MySQL database server on macOS. 2022-10-01, 157🔥, 0💬
Popular Posts:
This section provides first 8336 hex digits of constant PI, 3.1415927..., needed for Blowfish encryp...
"Hello_REST" is an REST Web service for test purpose only. High level information about this "Hello_...
Want to know when is the 2024 Chinese New Year day? Look for free Chinese calendars for 2024? Chines...
This section provides a tutorial example on how 'byte' values are casted to 'int' values when they a...
This book is a collection of tutorial notes and example codes written by the author while he was lea...