Tutorial Books:
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, 195🔥, 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, 194🔥, 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, 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, 190🔥, 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, 190🔥, 0💬
JDBC Driver Connection URL
Describes the connection URL format and how to create connection objects with the DriverManager class. 2022-10-01, 188🔥, 0💬
Date and Time Functions
Describes some commonly used date and time functions like, CURRENT_DATE(), CURRENT_TIME(), and EXTRACT(). 2022-10-01, 188🔥, 0💬
Getting Driver and Server Information
Describes how to get JDBC driver and database information through the DatabaseMetaData object. 2022-10-01, 187🔥, 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, 187🔥, 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, 184🔥, 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, 184🔥, 0💬
Popular Posts:
Want to know when is the 2019 Chinese New Year day? Look for free Chinese calendars for 2019? Chines...
Where to find lucky wedding dates for year 2029? Lucky Wedding Dates: 2029 - Year of the Rooster ⇒...
This section describes what is WADL (Web Application Description Language), an XML-based file format...
This section provides a tutorial example on how to disable and remove 'PDF Link Helper' addon from I...
This chapter provides tutorial notes and example codes on PHP data types and data literals. Topics i...