Tutorial by Examples

CREATE TABLE stack( id INT, username VARCHAR(30) NOT NULL, password VARCHAR(30) NOT NULL ); INSERT INTO stack (`id`, `username`, `password`) VALUES (1, 'Foo', 'hiddenGem'); INSERT INTO stack (`id`, `username`, `password`) VALUES (2, 'Baa', 'verySecret'); Query SELECT id FROM ...

Query SELECT * FROM stack; Result +------+----------+----------+ | id | username | password | +------+----------+----------+ | 1 | admin | admin | | 2 | stack | stack | +------+----------+----------+ 2 rows in set (0.00 sec) You can select all columns from one table...

Query SELECT * FROM stack WHERE username = "admin" AND password = "admin"; Result +------+----------+----------+ | id | username | password | +------+----------+----------+ | 1 | admin | admin | +------+----------+----------+ 1 row in set (0.00 sec) Query...

CREATE TABLE stack ( id int AUTO_INCREMENT PRIMARY KEY, username VARCHAR(100) NOT NULL ); INSERT stack(username) VALUES ('admin'),('k admin'),('adm'),('a adm b'),('b XadmY c'), ('adm now'), ('not here'); "adm" anywhere: SELECT * FROM stack WHERE username LIKE "%adm%&q...

SQL aliases are used to temporarily rename a table or a column. They are generally used to improve readability. Query SELECT username AS val FROM stack; SELECT username val FROM stack; (Note: AS is syntactically optional.) Result +-------+ | val | +-------+ | admin | | stack | +----...

It's also possible to use data binding within your RecyclerView Adapter. Data model public class Item { private String name; public String getName() { return name; } } XML Layout <TextView android:layout_width="wrap_content" android:layou...

With the ~ selector, you can easily implement a global accessible boolean without using JavaScript. Add boolean as a checkbox To the very beginning of your document, add as much booleans as you want with a unique id and the hidden attribute set: <input type="checkbox" id="sideba...

The horizontally justified navigation (menu) bar has some number of items that should be justified. The first (left) item has no left margin within the container, the last (right) item has no right margin within the container. The distance between items is equal, independent on the individual item w...

The backface-visibility property relates to 3D transforms. With 3D transforms and the backface-visibility property, you're able to rotate an element such that the original front of an element no longer faces the screen. For example, this would flip an element away from the screen: JSFIDDLE <d...

C++11 The C++11 standards guarantees that the initialization of function scope objects are initialized in a synchronized manner. This can be used to implement a thread-safe singleton with lazy initialization. class Foo { public: static Foo& instance() { static Foo inst; ...

This is a simple application with primefaces, it is a login page: 1-Configuration of web.xml: <?xml version="1.0" encoding="UTF-8"?> <web-app version="3.1" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-...

Suppose you have complex code that creates and returns a list by starting with a blank list and repeatedly appending to it: def create(): result = [] # logic here... result.append(value) # possibly in several places # more logic... return result # possibly in several places...

Clojure functions can be defined with zero or more parameters. (defn welcome "Without parameters" [] "Hello!") (defn square "Take one parameter" [x] (* x x)) (defn multiplier "Two parameters" [x y] (* x y)) ...

First, Install gulp and gulp-concat plugin to your project localy npm install --save-dev gulp gulp-concat and add gulp-concat task to your gulpfile.js var gulp = require('gulp'); var concat = require('gulp-concat'); gulp.task('default', function() { }); gulp.task('css', function() { ...

First, Install gulp, gulp-clean-css and gulp-rename to project directory localy npm install --save-dev gulp gulp-clean-css gulp-rename Than add following minify-css task to your gulpfile.js var gulp = require('gulp'); var cleanCSS = require('gulp-clean-css'); var rename = require('gulp-rename...

First, Install gulp and gulp-minify to project directory locally npm install --save-dev gulp gulp-minify Then add following min-js task to your gulpfile.js var gulp = require('gulp'); var minify = require('gulp-minify'); gulp.task('min-js', function() { return gulp.src('lib/*.js') ...

An existing working copy can be quickly transformed to reflect the contents of a different branch in the same repository. For example, you might have a working copy of the trunk and now need to work on a development branch. Instead of checking out a completely new working copy (which can waste a l...

"Tags" are a type of label that can be applied to a repository at a certain point in time. They are frequently used to give human-readable names to important milestones so that they can be easily accessed later (for example, "version-1.2"). Creating a tag is exactly the same as...

Introduction As memory prices dropped, Intel-based PCs were able to have more and more RAM affordably, alleviating many users' problems with running many of the ever-larger applications that were being produced simultaneously. While virtual memory allowed memory to be virtually "created" ...

Since the Physical Address Extension (PAE) mode that was introduced in the Pentium Pro (and Pentum M) was such a change to the Operating System memory management subsystem, when Intel designed the Pentium II they decided to enhance the "normal" Page mode to support the new Physical Address...