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

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

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

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

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

Date and Time Functions
Describes some commonly used date and time functions like, CURRENT_DATE(), CURRENT_TIME(), and EXTRACT(). 2022-10-01, ∼310🔥, 0💬

WHERE Clause of a SELECT Statement
This section provides tutorial examples on how to use the WHERE clause to filter rows out of the base table in a SELECT statement. 2022-10-01, ∼310🔥, 0💬

MySQL Status Variables for InnoDB Engine
This section describes some important MySQL status variables that represent statistic counts related the InnoDB storage engine. 2022-10-01, ∼310🔥, 0💬

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

MySQL Server Data Backups on CentOS
This section provides a tutorial example on how to create backups of MySQL databases and load it back to another MySQL server for MySQL 8.0 server on CentOS 8 systems. 2022-10-01, ∼307🔥, 0💬

UPDATE - Statement to Update Records in Tables
This section provides a tutorial example on how to use UPDATE statements to update records stored in tables. 2022-10-01, ∼306🔥, 0💬

"SHOW STATUS ..." - Server Status Variables
This section describes Server Status Variables, which are counters used by MySQL server to provide statistics information about its running status. 2022-10-01, ∼306🔥, 0💬

Bulk Changes on Large Tables
This chapter provides tutorial notes on bulk changes no large tables. Topics include general general guidelines for bulk changes; deleting records with simple conditions; deleting records that are not referenced. 2022-10-01, ∼305🔥, 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, ∼301🔥, 0💬

User-Defined vs. Stored Procedure Variables
This section provides a tutorial example to show you differences between user-defined variables and stored procedure variables: syntax, declaration and scope. 2022-10-01, ∼301🔥, 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