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

ALTER TABLE - Statement to Alter Table Structures
A tutorial example is provided on how to use ALTER TABLE statements to add, delete, modify, columns and indexes. 2022-10-01, 188🔥, 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, 186🔥, 0💬

Using SELECT to Query Database
This chapter provides tutorial notes on SELECT query statements. Topics include SELECT statement syntax, FROM clause, WHERE clause, GROUP BY clause, ORDER BY clause, JOIN table operations. 2022-10-01, 185🔥, 0💬

%mysql% Variable for MySQL Server Path
Tutorial example on how to create an environment variable '%mysql%' to represent the MySQL Server directory path name. This gives a quick way to invoke a MySQL command like '%mysql%\bin\mysql'. 2022-10-01, 185🔥, 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, 185🔥, 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, 184🔥, 0💬

Archived: MySQL Connector/J 5.1 Installation
This section describes how to download and install MySQL Connector/J (JDBC driver) required to run Java programs to access MySQL servers. 2022-10-01, 184🔥, 0💬

What Is InnoDB Storage Engine
This section describes the InnoDB storage engine, the default storage engine in the newer versions of MySQL server. 2022-10-01, 184🔥, 0💬

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

Numeric Value Functions
Describes some commonly used numeric functions like, ABS(), CEILING(), COS(), PI(), RANDOM(), ROUND(), and TRUNCATE(). 2022-10-01, 182🔥, 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, 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💬

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

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

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, 179🔥, 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💬

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

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

XML Document Functions
Describes some commonly used XML document functions like, ExtractValue() and UpdateXML(). 2022-10-01, 177🔥, 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 Reference REST SOAP Sorting Swing TV Series UML Unicode VBScript Web Web-Services Windows WSDL XML XMLPad XSD XSL-FO