Tutorial by Examples: int

Introduction (numeric)

MySQL offers a number of different numeric types. These can be broken down into GroupTypesInteger TypesINTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINTFixed Point TypesDECIMAL, NUMERICFloating Point TypesFLOAT, DOUBLEBit Value TypeBIT

MySQL • Data Types

Integer Types

Minimal unsigned value is always 0. TypeStorage(Bytes)Minimum Value(Signed)Maximum Value(Signed)Maximum Value(Unsigned)TINYINT1-27-12827-112728-1255SMALLINT2-215-32,768215-132,767216-165,535MEDIUMINT3-223-8,388,608223-18,388,607224-116,777,215INT4-231-2,147,483,648231-12,147,483,647232-14,294,967,2...

MySQL • Data Types

Fixed Point Types

MySQL's DECIMAL and NUMERIC types store exact numeric data values. It is recommended to use these types to preserve exact precision, such as for money. Decimal These values are stored in binary format. In a column declaration, the precision and scale should be specified Precision represents the n...

MySQL • Data Types

Floating Point Types

FLOAT and DOUBLE represent approximate data types. TypeStoragePrecisionRangeFLOAT4 bytes23 significant bits / ~7 decimal digits10^+/-38DOUBLE8 bytes53 significant bits / ~16 decimal digits10^+/-308 REAL is a synonym for FLOAT. DOUBLE PRECISION is a synonym for DOUBLE. Although MySQL also permits...

MySQL • Data Types

Introduction

A pointer is declared much like any other variable, except an asterisk (*) is placed between the type and the name of the variable to denote it is a pointer. int *pointer; /* inside a function, pointer is uninitialized and doesn't point to any valid object yet */ To declare two pointer variables...

C Language • Pointers

Implicits in the REPL

To view all the implicits in-scope during a REPL session: scala> :implicits To also include implicit conversions defined in Predef.scala: scala> :implicits -v If one has an expression and wishes to view the effect of all rewrite rules that apply to it (including implicits): scala> ...

Scala Language • Implicits

Internal Stylesheet

You can also include CSS elements internally by using the <style> tag: <head> <style type="text/css"> body { background-color: gray; } </style> </head> Multiple internal stylesheets can be included in a program as...

HTML • Using HTML with CSS

Value representation of floating point types

The standard requires that long double provides at least as much precision as double, which provides at least as much precision as float; and that a long double can represent any value that a double can represent, while a double can represent any value that a float can represent. The details of the ...

C++ • Implementation-defined behavior

Lists can be passed into subroutines

As to pass list into a subroutine, you specify the subroutine's name and then supply the list to it: test_subroutine( 'item1', 'item2' ); test_subroutine 'item1', 'item2'; # same Internally Perl makes aliases to those arguments and put them into the array @_ which is available within the s...

Perl Language • Lists

Check if all fields are rendered in the template

When rendering a form 'by hand', it can be useful to know if there are fields left to render or not. The function isRendered() from the FormView class returns true if there are still fields left to be rendered to the template. This snippet prints <h3>Extra fields</h3> if there are fiel...

symfony-forms • Forms

Printing tables

There are several packages that allow the output of data structures in form of HTML or LaTeX tables. They mostly differ in flexibility. Here I use the packages: knitr xtable pander For HTML documents --- title: "Printing Tables" author: "Martin Schmelzer" date: &quot...

R Language • Creating reports with RMarkdown

Skip assets (urls with dots in them) from wildcard route

module.exports.routes = { 'GET /foo/*': { fn: function(req, res) { res.send("FOO!"); }, skipAssets: true }, };

sails.js • Routing

[InternalsVisibleTo]

If you want to make internal classes or functions of an assembly accessable from another assembly you declare this by InternalsVisibleTo and the assembly name that is allowed to access. In this example code in the assembly MyAssembly.UnitTests is allowed to call internal elements from MyAssembly. ...

C# Language • AssemblyInfo.cs Examples

[StringLength(int)] attribute

using System.ComponentModel.DataAnnotations; public class Post { public int Id { get; set; } [StringLength(100)] public string Title { get; set;} [StringLength(300)] public string Abstract { get; set; } public string Description { get; set; } } Def...

Entity Framework • Code First DataAnnotations

Xcode Interface

In the Xcode, you have three separate areas of working - Navigators (in red), Debug area(in green) and Utilities(in blue). The workspace window always includes the editor area. When you select a file in your project, its contents appear in the editor area, where Xcode opens the file in an appropri...

iOS • Getting started with iOS

Configure LintOptions with gradle

You can configure lint by adding a lintOptions section in the build.gradle file: android { //..... lintOptions { // turn off checking the given issue id's disable 'TypographyFractions','TypographyQuotes' // turn on the given issue id's enable 'Rtl...

Android • Lint Warnings

How to configure the lint.xml file

You can specify your Lint checking preferences in the lint.xml file. If you are creating this file manually, place it in the root directory of your Android project. If you are configuring Lint preferences in Android Studio, the lint.xml file is automatically created and added to your Android project...

Android • Lint Warnings

Configuring lint checking in Java and XML source files

You can disable Lint checking from your Java and XML source files. Configuring lint checking in Java To disable Lint checking specifically for a Java class or method in your Android project, add the @SuppressLint annotation to that Java code. Example: @SuppressLint("NewApi") @Override...

Android • Lint Warnings

Partial Modules and Interfaces

Similar to partial classes the new version of Visual Basic is now able to handle partial modules and partial interfaces. The syntax and behaviour is exactly the same as it would be for partial classes. A partial module example: Partial Module Module1 Sub Main() Console.Write("Ping -&g...

Visual Basic .NET Language • Visual Basic 14.0 Features

Login example in the Model View Presenter (MVP) pattern

Let's see MVP in action using a simple Login Screen. There are two Buttons—one for login action and another for a registration screen; two EditTexts—one for the email and the other for the password. LoginFragment (The View) public class LoginFragment extends Fragment implements LoginContract.Prese...

Android • MVP Architecture