Tutorial by Examples: in

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

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

Install Yii2 advanced in ubuntu

First we need to install composer. Steps to install composer Install Composer. curl -sS https://getcomposer.org/installer | php Now change directory: sudo mv composer.phar /usr/local/bin/composer Check composer working composer Now Composer installed. There two ways to install Yii2 adv...

yii2 • Getting started with yii2

Interfaces

Introduction Interfaces are definitions of the public APIs classes must implement to satisfy the interface. They work as "contracts", specifying what a set of subclasses does, but not how they do it. Interface definition is much alike class definition, changing the keyword class to inter...

PHP • Classes and Objects

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

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

Intent URI

This example shows, how to start intent from browser: <a href="intent://host.com/path#Intent;package=com.sample.test;scheme=yourscheme;end">Start intent</a> This intent will start app with package com.sample.test or will open google play with this package. Also this intent...

Android • Intent

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

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

Read value of pointer that was freed

Even just reading the value of a pointer that was freed (i.e. without trying to dereference the pointer) is undefined behavior(UB), e.g. char *p = malloc(5); free(p); if (p == NULL) /* NOTE: even without dereferencing, this may have UB */ { } Quoting ISO/IEC 9899:2011, section 6.2.4 §2: ...

C Language • Undefined behavior

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

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

Installation or Setup

Windows PowerShell is included with the Windows Management Framework. Installation and Setup are not required on modern versions of Windows. Updates to PowerShell can be accomplished by installing a newer version of the Windows Management Framework. Other Platforms "Beta" version of P...

PowerShell • Getting started with PowerShell

Installation on Mac

The easiest way to set up NumPy on Mac is with pip pip install numpy Installation using Conda. Conda available for Windows, Mac, and Linux Install Conda. There are two ways to install Conda, either with Anaconda (Full package, include numpy) or Miniconda (only Conda,Python, and the package...

numpy • Getting started with numpy