Tutorial by Examples
Before you can use amCharts, you will need to include required JavaScript Libraries.
There is one main library that is required for all amCharts operations - amcharts.js. It needs to be included first and is mandatory.
Each chart type requires chart-type specific include. For example Serial chart,...
Description
The SQL standard provides two additional aggregate operators. These use the polymorphic value "ALL" to denote the set of all values that an attribute can take.
The two operators are:
with data cube that it provides all possible combinations than the argument attributes o...
The method charCodeAt retrieves the Unicode character code of a single character:
var charCode = "µ".charCodeAt(); // The character code of the letter µ is 181
To get the character code of a character in a string, the 0-based position of the character is passed as a parameter to charCo...
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the VALUES LESS THAN operator. For the next few examples, ...
List partitioning is similar to range partitioning in many ways. As in partitioning by RANGE, each partition must be explicitly defined. The chief difference between the two types of partitioning is that, in list partitioning, each partition is defined and selected based on the membership of a colum...
Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of partitions. With range or list partitioning, you must specify explicitly into which partition a given column value or set of column values is to be stored; with hash partitioning, MySQL take...
The UNION operator is used to combine the result-set (only distinct values) of two or more SELECT statements.
Query: (To selects all the different cities (only distinct values) from the "Customers" and the "Suppliers" tables)
SELECT City FROM Customers
UNION
SELECT City FROM ...
UNION ALL to select all (duplicate values also) cities from the "Customers" and "Suppliers" tables.
Query:
SELECT City FROM Customers
UNION ALL
SELECT City FROM Suppliers
ORDER BY City;
Result:
Number of Records: 12
City
-------
Aachen
Albuquerque
Anchorage
Ann A...
UNION ALL to select all(duplicate values also) German cities from the "Customers" and "Suppliers" tables.
Here Country="Germany" is to be specified in the where clause.
Query:
SELECT City, Country FROM Customers
WHERE Country='Germany'
UNION ALL
SELECT City, Count...
Full width table cell background images
<html xmlns:v="urn:schemas-microsoft-com:vml">
<head>
<style>
v:* { behavior: url(#default#VML); display: inline-block; }
</style>
</head>
<body>
<center>
<...
Some email clients (notably Windows Desktop Outlook) collapse tables with no content, even if there are dimensions or padding.
To prevent these clients from collapsing the spacer table, you can add an invisible &nbsp; that serves as content. Then zero out the character's font-size and line-heig...
