Android ASP Astrology Big5 Bitcoin Blowfish Built-in C# Calendar CD-DVD Cheminformatics Chinese Cryptography DES Email Encoding Ethereum Flash GB2312 General H Herong History HTML Java JavaScript JDBC JSP JVM Linux Molecule Movie Music MySQL Neural Network Perl PHP Physics PKI Publication Python Reference REST SOAP Sorting Swing TV Series UML Unicode VBScript Web Web-Services Windows WSDL XML XMLPad XSD XSL-FO

<< < 1 2 3 4 5 6 7 8 > >>   ∑:175  Sort:Date

Data Binary Representations
Describes how data of each datatype is represented in binary forms. SQL supports multiple binary representations of the same datatype using different storage sizes. 2022-10-01, 176🔥, 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, 176🔥, 0💬

Scopes of System Variables: Global and Session
This section describes global and session scopes of system variables. GLOBAL and SESSION keywords can be used to separate system variable scopes. 2022-10-01, 176🔥, 0💬

Examples of Different Types of Operation
This section provides tutorial examples of different types of operations: numeric, predicate, date and time. 2022-10-01, 175🔥, 0💬

Operations and Functions for Character Strings
Describes operations and functions for character strings, sequences of characters from predefined character sets. 2022-10-01, 175🔥, 0💬

Table Column Types for Approximate Numbers
Describes 3 types of table columns to store approximate numbers: FLOAT, REAL and DOUBLE PRECISION. 2022-10-01, 175🔥, 0💬

What Are Storage Engines
This section describes MySQL storage engines, which implement different strategies on how data is stored, updated and retrieved in storage devices. 2022-10-01, 175🔥, 0💬

MySqlLoop.php - MySQL Functions Test
A tutorial example is provided on how to use MySQL functions to connect to a MySQL server, and run SQL statements to create a table, insert rows and fetch rows with the MySQL server. 2022-10-01, 174🔥, 0💬

Data Literal Evaluation
Describes how data literals will be evaluated into values of particular datatypes based on the expression context. 2022-10-01, 174🔥, 0💬

References
This section provides a list of reference materials used in this book. 2022-10-01, 174🔥, 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, 173🔥, 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, 173🔥, 0💬

Performance of Inserting Integers to MySQL Database
This section provides a tutorial example on how to test the performance of inserting integers into MySQL server database using PHP 'mysqli' functions. MySQL server is 100 times slower on my CentOS computer and macOS computer. 2022-10-01, 173🔥, 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, 172🔥, 0💬

Accessing MySQL Servers from Perl Programs
A tutorial example is provided on what programs and modules are needed to access MySQL servers from Perl programs, and how to install them. 2022-10-01, 171🔥, 0💬

"INSERT INTO" Statements
Describes how to insert data rows with INSERT INTO statements. 2022-10-01, 171🔥, 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, 171🔥, 0💬

Table Column Types for JSON Documents
Describes 1 type of table column to store JSON documents: JSON. 2022-10-01, 171🔥, 0💬

Table Column Types for Spatial Geometry Data
Describes 8 types of table column to store Spatial Geometry Data: GEOMETRY, POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, GEOMETRYCOLLECTION, GEOMETRYCOLLECTION. 2022-10-01, 171🔥, 0💬

Connection, Performance and Second Instance on Linux
This chapter provides introductions and tutorial examples about more advanced topics on running MySQL server on CentOS systems, including MySQL socket and TCP/IP connections; Opening firewall for MySQL connections; testing performance on INSERT statements; creating second server instance; moving dat... 2022-10-01, 171🔥, 0💬

Clustered Index Used by InnoDB Engine
This section describbes the Clustered Index data structure used by the InnoDB engine to stored indexed data rows of a table in MySQL server. 2022-10-01, 171🔥, 0💬

Capture Slow Queries
This section provides a tutorial example on setup MySQL server to capture slow queries based on given conditions on execution time and number of rows examined. 2022-10-01, 170🔥, 0💬

HelloMySQL.pl - Sample Perl Program to Use MySQL
This section provides a sample Perl program, HelloMySQL.pl, which connects the MySQL server on the local machine, creates a table and inserts a record into the table. 2022-10-01, 169🔥, 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, 169🔥, 0💬

<< < 1 2 3 4 5 6 7 8 > >>   ∑:175  Sort:Date

Android ASP Astrology Big5 Bitcoin Blowfish Built-in C# Calendar CD-DVD Cheminformatics Chinese Cryptography DES Email Encoding Ethereum Flash GB2312 General H Herong History HTML Java JavaScript JDBC JSP JVM Linux Molecule Movie Music MySQL Neural Network Perl PHP Physics PKI Publication Python Reference REST SOAP Sorting Swing TV Series UML Unicode VBScript Web Web-Services Windows WSDL XML XMLPad XSD XSL-FO