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

Data Literals
Describes how to enter data into programs as data literals for different datatypes.
2022-10-01, ∼251🔥, 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, ∼251🔥, 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, ∼251🔥, 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, ∼249🔥, 0💬

mysqlimport - Loading Data from Files
This section provides some tutorial examples on how to use mysqlimport tool to load data of to tables on a MySQL server from data files.
2022-10-01, ∼248🔥, 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, ∼248🔥, 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, ∼248🔥, 0💬

FROM Clause of a SELECT Statement
A tutorial example is provided on how to use the FROM clause to provide tables, filters, aggregations and sorting order to SELECT statements.
2022-10-01, ∼248🔥, 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, ∼248🔥, 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, ∼248🔥, 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, ∼247🔥, 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, ∼247🔥, 0💬

SQL and Database Terminologies
This section provides brief descriptions of terminologies related to SQl and database.
2022-10-01, ∼246🔥, 0💬

MySQL Program Option Files
This section provides a tutorial example on how find the default option files for MySQL programs. The default option file for MySQL programs is /etc/my.cnf for Linux and macOS computers
2022-10-01, ∼246🔥, 0💬

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

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

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

Introduction of Datatype
This section provides quick introductions of datatypes supported by SQL: Character String, Bit String, Exact Number, Approximate Number, Date and Time.
2022-10-01, ∼239🔥, 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, ∼239🔥, 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, ∼239🔥, 0💬

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

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