Tutorial by Examples: table

db2 connect to {databaseName} db2 drop table {schema}.{table} db2 connect reset The schema is not necessary if it matches the current user name. The "db2" prefix is not necessary if you are already in a DB2 command prompt.

In your JS File add this option to your datatable: buttons: [ 'excel', 'pdf', 'copy' ] It will look like: $('#yourTableID').DataTable({ buttons: [ 'excel', 'pdf', 'copy' ] }); Add the necessary css files for the datatable with the buttons: <link rel="stylesheet" type=&quo...

On the official website of DataTable is an example of how a server-side process with PHP and MySQL can look. This example is deprecated and can no longer be used with PHP 7 (the function "mysql_pconnect" and the associated functions are deprecated, see this post). So this function gives y...

In order to trigger a "upgradeneeded" event you need to request the database with version higher than the current version - otherwise the event won't be triggered. function createTable(dbName, dbversion, tableName) { var request = indexedDB.open(dbName, dbversion); request.onupgrade...

This is a more generic solution applicable in system where the user has option to add indexes to the table that he uses: function createTable(dbName, tableName) { var request = indexedDB.open(dbName); request.onsuccess = function (e){ var database = e.target.result; var version = p...

Most Singleton examples use MonoBehaviour as the base class. The main disadvantage is that this Singleton class only lives during run time. This has some drawbacks: There is no way of directly editing the singleton fields other than changing the code. No way to store a reference to other assets...

Array ( [0] => Array ( [id] => 13 [category_id] => 7 [name] => Leaving Of Liverpool [description] => Leaving Of Liverpool [price] => 1.00 [virtual] => 1 [active] =...

The following rules define a simple strategy for creating immutable objects. Don't provide "setter" methods - methods that modify fields or objects referred to by fields. Make all fields final and private. Don't allow subclasses to override methods. The simplest way to do this is to d...

public final class Color { final private int red; final private int green; final private int blue; private void check(int red, int green, int blue) { if (red < 0 || red > 255 || green < 0 || green > 255 || blue < 0 || blue > 255) { throw ...

In this case class Point is mutable and some user can modify state of object of this class. class Point { private int x, y; public Point(int x, int y) { this.x = x; this.y = y; } public int getX() { return x; } public void setX(int ...

Sometimes we need to join multiple tables to get aggregate data in return. here is how we can achieve the same using CodeIgniter Query Builder / Active Records. public function getStudentInfo($studentid){ $query = $this->db->select("st.id, st.name, st.class, mk.maths, mk.science&quo...

Essence of searching lies in its order. Everyone wants search results to be shown in such a way that best suited results are shown on top. Relational database do not have such capability. Elasticsearch on the other hand shows results on the basis of relevancy by default. Setup Same as used in ...

<table id="countryList"> <thead> <tr> <th th:text="#{country.label.name}"> Country </th> <th th:text="#{country.label.capital}"> Capital </th> <th th:text="#{country.l...

$ sqoop import --connect jdbc:mysql://10.0.0.100/hadooptest --username hadoopuser -P --table table_name --hive-import --hive-table hive_table_name

import java.util.*; public class HashtableDemo { public static void main(String args[]) { // create and populate hash table Hashtable<Integer, String> map = new Hashtable<Integer, String>(); map.put(101,"C Language"); map.put(102, &quot...

| Name | Phone | Age | |-------+-------+-----| | Peter | 1234 | 17 | | Anna | 4321 | 25 | To add a Table in org-mode, simply surround your columns with a bar (|) | column1 | column2 | this column is wider | When you press Return from inside a column, org-mode will automatically creat...

This is a weird approach most of the people don't know this even exist. CREATE TABLE AliasNameDemo(id INT,firstname VARCHAR(20),lastname VARCHAR(20)) INSERT INTO AliasNameDemo VALUES (1,'MyFirstName','MyLastName') SELECT * FROM (SELECT firstname + ' ' + lastname FROM A...

Tables are most easily included with the DT package, which is an R interface to the JavaScript library DataTables. library(shiny) library(DT) ui <- fluidPage( dataTableOutput('myTable') ) server <- function(input, output, session){ output$myTable <- renderDataTable({ dat...

Grouping with the data.table package is done using the syntax dt[i, j, by] Which can be read out loud as: "Take dt, subset rows using i, then calculate j, grouped by by." Within the dt statement, multiple calculations or groups should be put in a list. Since an alias for list() is .(), bo...

Step 1: Make a design of GridView for displaying your data (HTML Code): <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"> <Columns> <asp:TemplateField HeaderText="ID"> <ItemTemplate> ...