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

Operations and Functions for Character Strings
Describes operations and functions for character strings, sequences of characters from predefined character sets.
2022-10-01, 176🔥, 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, 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💬

"INSERT INTO" Statements
Describes how to insert data rows with INSERT INTO statements.
2022-10-01, 175🔥, 0💬

Data Literal Evaluation
Describes how data literals will be evaluated into values of particular datatypes based on the expression context.
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💬

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, 175🔥, 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, 174🔥, 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, 174🔥, 0💬

Table Column Types for JSON Documents
Describes 1 type of table column to store JSON documents: JSON.
2022-10-01, 174🔥, 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, 174🔥, 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, 173🔥, 0💬

DELETE FROM - Statement to Delete Records from Tables
A tutorial example is provided on how to use DELETE FROM statements to delete records from tables.
2022-10-01, 172🔥, 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, 172🔥, 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, 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💬

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, 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, 170🔥, 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, 169🔥, 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, 169🔥, 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, 168🔥, 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, 168🔥, 0💬

Operations and Functions for Bit Strings
Describes operations and functions for bit strings, sequences of bit values, 0 and 1.
2022-10-01, 168🔥, 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, 167🔥, 0💬

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