Tutorial by Examples: g

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

Create an XML file using XMLWriter

Instantiate a XMLWriter object: $xml = new XMLWriter(); Next open the file to which you want to write. For example, to write to /var/www/example.com/xml/output.xml, use: $xml->openUri('file:///var/www/example.com/xml/output.xml'); To start the document (create the XML open tag): $xml-&gt...

PHP • XML

Show both staged and unstaged changes

To show all staged and unstaged changes, use: git diff HEAD NOTE: You can also use the following command: git status -vv The difference being that the output of the latter will actually tell you which changes are staged for commit and which are not.

Git • Git Diff

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

Linear regression on the mtcars dataset

The built-in mtcars data frame contains information about 32 cars, including their weight, fuel efficiency (in miles-per-gallon), speed, etc. (To find out more about the dataset, use help(mtcars)). If we are interested in the relationship between fuel efficiency (mpg) and weight (wt) we may start p...

R Language • Linear Models (Regression)

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

Reversing Strings

2.2 let aString = "This is a test string." // first, reverse the String's characters let reversedCharacters = aString.characters.reverse() // then convert back to a String with the String() initializer let reversedString = String(reversedCharacters) print(reversedString) // &q...

Swift Language • Strings and Characters

Adding the Doctype

The <!DOCTYPE> declaration should always be included at the top of the HTML document, before the <html> tag. 5 See HTML 5 Doctype for details on the HTML 5 Doctype. <!DOCTYPE html> 4.01 See HTML 4.01 Doctypes for details on how these types differ from each other. Stri...

HTML • Doctypes

Get the list of all databases on a server

Method 1: Below query will be applicable for SQL Server 2000+ version (Contains 12 columns) SELECT * FROM dbo.sysdatabases Method 2: Below query extract information about databases with more informations (ex: State, Isolation, recovery model etc.) Note: This is a catalog view and will be availa...

Microsoft SQL Server • Retrieve information about the database

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

Merge with a commit

Default behaviour is when the merge resolves as a fast-forward, only update the branch pointer, without creating a merge commit. Use --no-ff to resolve. git merge <branch_name> --no-ff -m "<commit message>"

Git • Merging

Obtaining OpenGL

One of the most common misconceptions about OpenGL is, that it were a library that could be installed from 3rd party sources. This misconception leads to many questions in the form "how to I install OpenGL" or "where to download the OpenGL SDK". This is not how OpenGL finds the ...

opengl • Getting started with opengl

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

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

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

Generic selection based on multiple arguments

If a selection on multiple arguments for a type generic expression is wanted, and all types in question are arithmetic types, an easy way to avoid nested _Generic expressions is to use addition of the parameters in the controlling expression: int max_int(int, int); unsigned max_unsigned(unsigned, ...

C Language • Generic selection

Using FOR XML PATH to concatenate values

The FOR XML PATH can be used for concatenating values into string. The example below concatenates values into a CSV string: DECLARE @DataSource TABLE ( [rowID] TINYINT ,[FirstName] NVARCHAR(32) ); INSERT INTO @DataSource ([rowID], [FirstName]) VALUES (1, 'Alex') ,(2, 'Peter') ...

Microsoft SQL Server • FOR XML PATH

Build and Install Erlang/OTP on Ubuntu

The following examples show two main methods for installing Erlang/OTP on Ubuntu. Method 1 - Pre-built Binary Package Simply run this command and it will download and install the latest stable Erlang release from Erlang Solutions. $ sudo apt-get install erlang Method 2 - Build and Install from...

Erlang Language • Installation

Strings: Bytes versus Unicode

Python 2.x2.7 In Python 2 there are two variants of string: those made of bytes with type (str) and those made of text with type (unicode). In Python 2, an object of type str is always a byte sequence, but is commonly used for both text and binary data. A string literal is interpreted as a byte s...

Python Language • Incompatibilities moving from Python 2 to Python 3

Integer Division

The standard division symbol (/) operates differently in Python 3 and Python 2 when applied to integers. When dividing an integer by another integer in Python 3, the division operation x / y represents a true division (uses __truediv__ method) and produces a floating point result. Meanwhile, the ...

Python Language • Incompatibilities moving from Python 2 to Python 3