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

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, ∼323🔥, 0💬

Impact of Binary Logging on INSERT
This section provides a tutorial example to demonstrate the performance impact of binary logging, about 50% of execution time reduction on INSERT and other data change statements.
2022-10-01, ∼323🔥, 0💬

References
This section provides a list of reference materials used in this book.
2022-10-01, ∼322🔥, 0💬

PHP Programs and MySQL Server
This chapter provides notes and tutorial examples on MySQL server and PHP programs. Topics include configuring the PHP engine to use the MySQL extension library, commonly used MySQL functions, running SQL statements to create table, insert rows and fetch rows.
2022-10-01, ∼321🔥, 0💬

Perl Programs and MySQL Servers
This chapter provides notes and tutorial examples on MySQL server and Perl programs. Topics include what software and modules are needed to run Perl programs to access MySQL servers; a sample Perl program that connects to a MySQL server.
2022-10-01, ∼319🔥, 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, ∼318🔥, 0💬

Installing MySQL Server on Linux
This chapter provides introductions and tutorial examples about MySQL database server on CentOS systems. Topics include installing MySQL 8.0 on CentOS 8; starting and stoping 'mysqld' as a system service; setting MySQL 'root' password; MySQL file and data locations; MySQL log files; backing up MySQL...
2022-10-01, ∼318🔥, 0💬

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

Column Options When Creating Tables
A tutorial example is provided on how to use different column options like, NULL, UNIQUE, DEFAULT, PRIMARY KEY, when creating new tables.
2022-10-01, ∼316🔥, 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, ∼314🔥, 0💬

JSON Document Functions
Describes some commonly used JSON Document functions like, JSON_VALID(), JSON_TYPE(), JSON_ARRAY(), JSON_OBJECT(), JSON_EXTRACT(), JSON_REMOVE(), JSON_REPLACE(), JSON_SET(), and JSON_INSERT().
2022-10-01, ∼314🔥, 0💬

Creating Tables with AUTO_INCREMENT Columns
Describes how to create a table with an AUTO_INCREMENT column.
2022-10-01, ∼313🔥, 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, ∼313🔥, 0💬

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

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

Statistic Information on InnoDB Tables
This section provides a tutorial example on how to collect and review statistic information on InnoDB tables in MySQL server.
2022-10-01, ∼312🔥, 0💬

Introduction of MySQL Programs
Notes and tutorial examples are provided on MySQL 8.0 programs. Topics include a list of MySQL 8.0 major programs; introduction of mysqld, mysqladmin, mysql, mysqldump, and mysqlimport programs.
2022-10-01, ∼310🔥, 0💬

Performance Comparison of Inserting Integers vs. Strings
This section provides a tutorial example on how to check performance comparison between inserting integers and inserting strings to MySQL database.
2022-10-01, ∼309🔥, 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, ∼308🔥, 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, ∼308🔥, 0💬

Character String Functions
Describes some commonly used character string functions like, CONCAT(), CHAR_LENGTH(), SUBSTRING(), UPPER(), LOWER(), TRIM(), and POSITION().
2022-10-01, ∼307🔥, 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, ∼307🔥, 0💬

mysql - The Client Tool for End Users
This section provides a quick introduction of mysql, the client tool for end users to manage their data on MySQL servers. You can run mysql on a remote system to create new databases and new tables, to insert, update or delete data from tables.
2022-10-01, ∼306🔥, 0💬

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