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 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

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

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

Creating Connections with DataSource Class
Describes how to create connection objects with the DataSource class. 2022-10-01, ∼350🔥, 0💬

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

Set MySQL Server "root" Password on CentOS
This section provides a tutorial example on how to set or reset 'root' password, in case it has no password or you can not remember the password, for MySQL 8.0 server on CentOS 8 systems. 2022-10-01, ∼350🔥, 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, ∼350🔥, 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, ∼349🔥, 0💬

Numeric Literal Evaluation Examples
This section provides tutorial examples on how numeric literals are evaluated to values of different datatypes. 2022-10-01, ∼348🔥, 0💬

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

SQL and Database Terminologies
This section provides brief descriptions of terminologies related to SQl and database. 2022-10-01, ∼345🔥, 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, ∼344🔥, 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, ∼343🔥, 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, ∼343🔥, 0💬

Getting Driver and Server Information
Describes how to get JDBC driver and database information through the DatabaseMetaData object. 2022-10-01, ∼342🔥, 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, ∼340🔥, 0💬

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

Flow Control Functions
Describes 4 types of flow control functions: CASE ... WHEN, CASE WHEN, IF and IFNULL. 2022-10-01, ∼339🔥, 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, ∼339🔥, 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, ∼337🔥, 0💬

Operations and Functions for Character Strings
Describes operations and functions for character strings, sequences of characters from predefined character sets. 2022-10-01, ∼336🔥, 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, ∼336🔥, 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 REST SOAP Sorting Swing TV Series UML Unicode VBScript Web Web-Services Windows WSDL XML XMLPad XSD XSL-FO