Tutorial by Examples: ti

Basic table creation

The CREATE TABLE statement is used to create a table in a MySQL database. CREATE TABLE Person ( `PersonID` INTEGER NOT NULL PRIMARY KEY, `LastName` VARCHAR(80), `FirstName` VARCHAR(80), `Address` TEXT, `City` VARCHAR(100) ) Engine=InnoDB; Ev...

MySQL • Table Creation

Table creation with Primary Key

CREATE TABLE Person ( PersonID INT UNSIGNED NOT NULL, LastName VARCHAR(66) NOT NULL, FirstName VARCHAR(66), Address VARCHAR(255), City VARCHAR(66), PRIMARY KEY (PersonID) ); A primary key is a NOT NULL single or a multi-column identifier whic...

MySQL • Table Creation

Table creation with Foreign Key

CREATE TABLE Account ( AccountID INT UNSIGNED NOT NULL, AccountNo INT UNSIGNED NOT NULL, PersonID INT UNSIGNED, PRIMARY KEY (AccountID), FOREIGN KEY (PersonID) REFERENCES Person (PersonID) ) ENGINE=InnoDB; Foreign key: A Foreign Key (FK) is either a single col...

MySQL • Table Creation

Installation or Setup

Detailed instructions on getting pandas set up or installed can be found here in the official documentation. Installing pandas with Anaconda Installing pandas and the rest of the NumPy and SciPy stack can be a little difficult for inexperienced users. The simplest way to install not only pandas, ...

pandas • Getting started with pandas

Installation or Setup

ReactJS is a JavaScript library contained in a single file react-<version>.js that can be included in any HTML page. People also commonly install the React DOM library react-dom-<version>.js along with the main React file: Basic Inclusion <!DOCTYPE html> <html> <...

React • Getting started with React

Installation or Setup

Knockout is available on most JavaScript platforms, or as a standalone script. Include as a script You can download the script from it's download page, then include it in your page with a standard script tag <script type='text/javascript' src='knockout-3.4.0.js'></script> Using a C...

knockout.js • Getting started with knockout.js

Clearing an activity stack

Sometimes you may want to start a new activity while removing previous activities from the back stack, so the back button doesn't take you back to them. One example of this might be starting an app on the Login activity, taking you through to the Main activity of your application, but on logging out...

Android • Intent

Use anonymous functions with apply

apply is used to evaluate a function (maybe an anonymous one) over the margins of an array or matrix. Let's use the iris dataset to illustrate this idea. The iris dataset has measurements of 150 flowers from 3 species. Let's see how this dataset is structured: > head(iris) Sepal.Length Sep...

R Language • *apply family of functions (functionals)

Cloning an existing table

A table can be replicated as follows: CREATE TABLE ClonedPersons LIKE Persons; The new table will have exactly the same structure as the original table, including indexes and column attributes. As well as manually creating a table, it is also possible to create table by selecting data from anot...

MySQL • Table Creation

Array definition

Dim array(9) As Integer ' Defines an array variable with 10 Integer elements (0-9). Dim array = New Integer(10) {} ' Defines an array variable with 11 Integer elements (0-10) 'using New. Dim array As Integer() = {1, 2, 3, 4} ' Defines an Integer array variable a...

Visual Basic .NET Language • Array

Manipulating Array Elements

Adding elements: [1, 2, 3] << 4 # => [1, 2, 3, 4] [1, 2, 3].push(4) # => [1, 2, 3, 4] [1, 2, 3].unshift(4) # => [4, 1, 2, 3] [1, 2, 3] << [4, 5] # => [1, 2, 3, [4, 5]] Removing elements: array = [1, 2, 3, 4] array.pop # => 4 array # => [1, 2, 3] ...

Ruby Language • Arrays

while, until

A while loop executes the block while the given condition is met: i = 0 while i < 5 puts "Iteration ##{i}" i +=1 end An until loop executes the block while the conditional is false: i = 0 until i == 5 puts "Iteration ##{i}" i +=1 end

Ruby Language • Control Flow

Print statement vs. Print function

In Python 2, print is a statement: Python 2.x2.7 print "Hello World" print # print a newline print "No newline", # add trailing comma to remove newline print >>sys.stderr, "Error" # print to stderr print("hello"...

Python Language • Incompatibilities moving from Python 2 to Python 3

Installation and Setup

Prerequisites and Requirements for Magento Community Edition 1.9 Hosting Apache 2.x ( with mod_rewrite ) or Nginx 1.7.x Due to the demands of processing Magento operations, it is recommended that you install Magento on a server with at least 2 GB of RAM. This will ensure that all of the s...

magento • Getting started with magento

Using Entity Framework from C# (Code First)

Code first allows you to create your entities (classes) without using a GUI designer or a .edmx file. It is named Code first, because you can create your models first and Entity framework will create database according to mappings for you automatically. Or you can also use this approach with existin...

Entity Framework • Getting started with Entity Framework

Installation or Setup

Windows If you have Visual Studio (any version including express and community) installed, F# should already be included. Just choose F# as the language when you create a new project. Or see http://fsharp.org/use/windows/ for more options. OS X Xamarin Studio supports F#. Alternately, you could u...

F# • Getting started with F#

Installation/Setup

Downloading: Download Bootstrap directly or clone, etc. from the GitHub repository Download your customized version of Bootstrap from official docs Install with bower: bower install bootstrap Install with npm: npm install bootstrap Install with composer: composer require twbs/bootstrap The...

twitter-bootstrap • Getting started with twitter-bootstrap

Function Arguments, "arguments" object, rest and spread parameters

Functions can take inputs in form of variables that can be used and assigned inside their own scope. The following function takes two numeric values and returns their sum: function addition (argument1, argument2){ return argument1 + argument2; } console.log(addition(2, 3)); // -> 5 ...

JavaScript • Functions

Arrays union, intersection and difference

x = [5, 5, 1, 3] y = [5, 2, 4, 3] Union (|) contains elements from both arrays, with duplicates removed: x | y => [5, 1, 3, 2, 4] Intersection (&) contains elements which are present both in first and second array: x & y => [5, 3] Difference (-) contains elements which ar...

Ruby Language • Arrays

Stability in Sorting

Stability in sorting means whether a sort algorithm maintains the relative order of the equals keys of the original input in the result output. So a sorting algorithm is said to be stable if two objects with equal keys appear in the same order in sorted output as they appear in the input unsorted a...

algorithm • Sorting