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

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

Numeric Value Functions
Describes some commonly used numeric functions like, ABS(), CEILING(), COS(), PI(), RANDOM(), ROUND(), and TRUNCATE(). 2022-10-01, 180🔥, 0💬

Table Column Types for Byte Strings
Describes 2 types of table columns to store Byte strings: BINARY and VARBINARY. 2022-10-01, 180🔥, 0💬

Table Column Types for Date and Time Values
Describes 6 types of table columns to store date and time values: TIME, DATE, TIMESTAMP, TIME WITH TIME ZONE, TIMESTAMP WITH TIME ZONE, and INTERVAL. 2022-10-01, 179🔥, 0💬

CREATE PROCEDURE - Statement to Create Stored Procedures
This section provides tutorial examples on how to use CREATE PROCEDURE statements to create stored procedures. 2022-10-01, 179🔥, 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, 179🔥, 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, 178🔥, 0💬

Table Column Types for Look Up Values
Describes 2 types of table columns to store look up values: ENUM and SET. 2022-10-01, 178🔥, 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, 178🔥, 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, 177🔥, 0💬

XML Document Functions
Describes some commonly used XML document functions like, ExtractValue() and UpdateXML(). 2022-10-01, 177🔥, 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, 177🔥, 0💬

Creating Tables with AUTO_INCREMENT Columns
Describes how to create a table with an AUTO_INCREMENT column. 2022-10-01, 176🔥, 0💬

Commonly Used Functions
This chapter provides tutorial notes on built-in functions. Topics include commonly used flow control functions, character string functions, numeric functions, data and time functions, the cast function. 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💬

Defining and Calling Stored Procedures
This chapter provides tutorial notes on store procedures. Topics include what is a stored procedure; creating a stored procedure; calling a stored procedure to run; passing data into and out of stored procedures. 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💬

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

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

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

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

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