Tutorial by Examples: table

local t1, t2, t3, t4 = {}, {}, {}, {} -- Create 4 tables local maintab = {t1, t2} -- Regular table, strong references to t1 and t2 local weaktab = setmetatable({t1, t2, t3, t4}, {__mode = 'v'}) -- table with weak references. t1, t2, t3, t4 = nil, nil, nil, nil -- No more "strong" refe...

If you want to have a table organized in column-store format instead of row store, add INDEX cci CLUSTERED COLUMNSTORE in definition of table: DROP TABLE IF EXISTS Product GO CREATE TABLE Product ( ProductID int, Name nvarchar(50) NOT NULL, Color nvarchar(15), Size nvarchar(5)...

CREATE CLUSTERED COLUMNSTORE INDEX enables you to organize a table in column format: DROP TABLE IF EXISTS Product GO CREATE TABLE Product ( Name nvarchar(50) NOT NULL, Color nvarchar(15), Size nvarchar(5) NULL, Price money NOT NULL, Quantity int ) GO CREATE CLUSTERED C...

In this example, we'll create the following table using iText 5: We need the PdfPTable and PdfPCell class to achieve this: public void createPdf(String dest) throws IOException, DocumentException { Document document = new Document(); PdfWriter.getInstance(document, new FileOutputStream...

In this example, we'll create the following table using iText 7: We'll need the Table and Cell class to achieve this: public void createPdf(String dest) throws IOException { PdfDocument pdf = new PdfDocument(new PdfWriter(dest)); try (Document document = new Document(pdf)) { T...

Executable JAR files are the simplest way to assemble Java code into a single file that can be executed. *(Editorial Note: Creation of JAR files should be covered by a separate Topic.) * Assuming that you have an executable JAR file with pathname <jar-path>, you should be able to run it as f...

In InnoDB, having a long PRIMARY KEY (either a single column with a lengthy value, or several columns that form a long composite value) wastes a lot of disk space. The primary key value for a row is duplicated in all the secondary index records that point to the same row. Create an AUTO_INCREME...

Build on the previous example by creating even more dynamic and powerful layouts with tablet .col-sm-* classes. <div class="row"> <div class="col-xs-12 col-sm-6 col-md-8">.col-xs-12 .col-sm-6 .col-md-8</div> <div class="col-xs-6 col-md-4">...

To make the table more readable, following are the ways to color it: Rows Columns Lines Cells Coloring Rows Use \rowcolor (provided by colortbl; also loaded by xcolor under the [table] package option). Example: \documentclass{article} \usepackage[table]{xcolor} \begin{document} \be...

Tableau is a family of interactive data visualization products focused on Business Intelligence, varying from Tableau Server, aimed for enterprises who want to share dashboards and data across departments, to Tableau Public, that anyone can use for free and publish their dashboards on-line. Indepen...

The following statement will create a new table called employee: CREATE TABLE EMPLOYEE ( EMPNO CHAR(6) NOT NULL, FIRSTNME VARCHAR(12) NOT NULL, LASTNAME VARCHAR(15) NOT NULL, SALARY DECIMAL(9,2) , PRIMARY KEY (EMPNO) ...

Let's suppose we are going to insert rows in the previously created table. We can explicitly name the columns we are going to out values is and its order: INSERT INTO EMPLOYEE (EMPNO, FIRSTNME, LASTNAME, SALARY) VALUES ( '123456', 'Ali', 'Veli', 100000); If we know the order and we are going...

We can limit no of rows from result using rownum clause select * from ( select val from mytable ) where rownum<=5 If we want first or last record then we want order by clause in inner query that will give result based on order. Last Five Record : select * from ( select val f...

let's assume we have three table which can be used for simple website with Tags. Fist table is for Posts. Second for Tags Third for Tags & Post relation fist table "videogame" idtitlereg_dateContent1BioShock Infinite2016-08-08.... "tags" table idname1yennefer2eliza...

function sumofsins1(n::Integer) r = 0 for i in 1:n r += sin(3.4) end return r end function sumofsins2(n::Integer) r = 0.0 for i in 1:n r += sin(3.4) end return r end Timing the above two functions shows major...

Native compiled table value function returns table as result. Code in natively compiled function will be transformed into C code and compiled as dll. Only inline table valued functions are supported in version 2016. To create a native table value function you need to: Use standard CREATE FUNCTIO...

Example Table There are several ways to inject your data into DataTables. Serverside Processing is just one method. In this manner, DataTables has a pre-configured endpoint to retrieve data from, and that endpoint is responsible for accepting all paging/filtering/sorting requests that DataTables ap...

We will see stream objects being returned by modules like fs etc but what if we want to create our own streamable object. To create Stream object we need to use the stream module provided by NodeJs var fs = require("fs"); var stream = require("stream").Writable; ...

What is UITableView? UITableView is a most frequently used user interface object that presents data in a scrollable list of multiple rows in a single column that can also be divided into sections.It allows vertical scrolling only and is a subclass of UIScrollView. Why do we use UITableView? We ca...

We will take vehicle hierarchy example as depicted below. Vehicle.java package com.thejavageek.jpa.entities; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Inheritance...