Popular Books:
Data Literals
Describes how to enter data into programs as data literals for different datatypes. 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💬
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💬
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💬
SQL and Database Terminologies
This section provides brief descriptions of terminologies related to SQl and database. 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💬
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💬
Popular Posts:
This section describes how to create tables with CLOB columns in Oracle server.
This section provides a tutorial example on how to perform substructure match with the m.HasSubstruc...
The Dog The Dog is a giving, compassionate personality. He offers kind words, support and advice to ...
This section describes how to download and install JDK 12 on a Windows system.
This chapter provides a quick introduction of HTTPS (Hypertext Transfer Protocol Secure). Topics inc...