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 Character Strings
Describes 4 types of table columns to store character strings: CHAR, VARCHAR, NCHAR and NCHAR VARYING. 2022-10-01, 203🔥, 0💬

Character Strings and Bit Strings
This chapter provides tutorial notes on character strings and bit strings. Topics include character string operations and functions; bit string operations and functions. 2022-10-01, 202🔥, 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, 202🔥, 0💬

Statistic Information on InnoDB Tables
This section provides a tutorial example on how to collect and review statistic information on InnoDB tables in MySQL server. 2022-10-01, 201🔥, 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, 199🔥, 0💬

JOIN - Operation to Join Two Tables
Describes JOIN operations to join two tables in different ways: CROSS JOIN, INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN. 2022-10-01, 199🔥, 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, 199🔥, 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, 198🔥, 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, 198🔥, 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, 198🔥, 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, 197🔥, 0💬

Storage Engines in MySQL Server
This chapter provides tutorial notes on MySQL storage engines. Topics include listing of pluggable storage engines; cluster index data structure used on InnoDB storage engine; system variables, status variables and statistical information on InnoDB engine. 2022-10-01, 197🔥, 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, 196🔥, 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, 195🔥, 0💬

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

Date and Time Functions
Describes some commonly used date and time functions like, CURRENT_DATE(), CURRENT_TIME(), and EXTRACT(). 2022-10-01, 194🔥, 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, 194🔥, 0💬

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

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

Numeric Literal Evaluation Examples
This section provides tutorial examples on how numeric literals are evaluated to values of different datatypes. 2022-10-01, 191🔥, 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, 191🔥, 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