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

Table Column Types for Approximate Numbers
Describes 3 types of table columns to store approximate numbers: FLOAT, REAL and DOUBLE PRECISION. 2022-10-01, ∼264🔥, 0💬

Archived: Installing MySQL 5.0.2 (Alpha)
This section provides a tutorial example on how to install MySQL 5.0.2 (Alpha) on a Windows system. 2022-10-01, ∼263🔥, 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, ∼263🔥, 0💬

Data Literals
Describes how to enter data into programs as data literals for different datatypes. 2022-10-01, ∼263🔥, 0💬

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

Configuring PHP for MySQL Server Access
A tutorial example is provided on how to configure the PHP engine for MySQL server connection access. Setting, extension=php_mysql.dll, needs to be turned on in the configuration file php.ini. 2022-10-01, ∼261🔥, 0💬

System, User-Defined and Stored Procedure Variables
This chapter provides tutorial notes on 3 types of variables in MySQL: System Variables, User-Defined Variables and Stored Procedure Variables. System variables have two scopes: Global and Session. 2022-10-01, ∼261🔥, 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, ∼261🔥, 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, ∼259🔥, 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, ∼259🔥, 0💬

Use Index for Better Performance
This chapter provides tutorial notes on Index. Topics include introduction of index; using index to reduce searching time; creating composite indexes on value combinations of multiple columns. 2022-10-01, ∼259🔥, 0💬

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

Clustered Index Used by InnoDB Engine
This section describbes the Clustered Index data structure used by the InnoDB engine to stored indexed data rows of a table in MySQL server. 2022-10-01, ∼256🔥, 0💬

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

Window Functions for Statistical Analysis
This chapter provides tutorial notes on Window Functions. Topics include introduction of window functions; OVER clause to identify window functions; PARTITION BY clause to form multiple windows; ROWS and RANGE clauses to specify moving frames; WINDOW clause to name windows. 2022-10-01, ∼253🔥, 0💬

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

Creating Connections with DataSource Class
Describes how to create connection objects with the DataSource class. 2022-10-01, ∼250🔥, 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, ∼250🔥, 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