Popular Books:
Data Literals
Describes how to enter data into programs as data literals for different datatypes. 2022-10-01, ∼251🔥, 0💬
SQL and Database Terminologies
This section provides brief descriptions of terminologies related to SQl and database. 2022-10-01, ∼249🔥, 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💬
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, ∼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💬
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💬
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, ∼243🔥, 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💬
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, ∼240🔥, 0💬
References
This section provides a list of reference materials used in this book. 2022-10-01, ∼240🔥, 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💬
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, ∼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💬
Popular Posts:
This section describes how to load the Oracle JDBC driver class - ojdbc14.jar.
Information on how to obtain the full version of this book in PDF, EPUB, or other formats.
Want to know when is the 2014 Chinese New Year day? Look for free Chinese calendars for 2014? Chines...
Heavenly Stems and Earthly Branches Heavenly stems and earthly branches are collectively ...
This section describes the Base64URL encoding algorithm, which is a variation of the standard Base64...