Tutorial by Examples: ch

grant all privileges on schema_name.* to 'new_user_name'@'%' identified by 'newpassword'; Attention: This can be used to create new root user

If an integer x is a power of 2, only one bit is set, whereas x-1 has all bits set after that. For example: 4 is 100 and 3 is 011 as binary number, which satisfies the aforementioned condition. Zero is not a power of 2 and has to be checked explicitly. boolean isPowerOfTwo(int x) { return (x ...

In this example, we will launch a basic EC2 Instance with Amazon Linux in the quickest manner possible via the AWS Management Console. Amazon frequently improves the user experience of the AWM Management console, so you might experience some changes to the screens below. Important: launching an in...

Default WooCommerce checkout form comes with several fields for customers to enter their billing details. But in some cases, you might want to hide some of these fields. For example, if you are selling only virtual products, you can get rid of fields like billing address. Use the following code sn...

data table; set table; length state_full $8; if state = 'KS' then state_full = 'Kansas'; else if state = 'CO' then state_full = 'Colorado'; else state_full = 'Other'; run;

var express = require('express'); var app = express(); var router = express.Router(); app.route('/user') .get(function (req, res) { res.send('Get a random user') }) .post(function (req, res) { res.send('Add a user') }) .put(function (req, res) { res.send...

Takes an array of information to generate the CAPTCHA as input and creates the image to your specifications, returning an array of associative data about the image. [array] ( 'image' => IMAGE TAG 'time' => TIMESTAMP (in microtime) 'word' => CAPTCHA WORD ) The "imag...

Once loaded you can generate a captcha like this: $vals = array( 'word' => 'Random word', 'img_path' => './captcha/', 'img_url' => 'http://example.com/captcha/', 'font_path' => './path/to/fonts/texb.ttf', 'img_width' => '150', 'img_height'...

Import libraries (language dependency: python 2.7) import tensorflow as tf import numpy as np from sklearn.datasets import fetch_mldata from sklearn.model_selection import train_test_split load data, prepare data mnist = fetch_mldata('MNIST original', data_home='./') print "MNIST data,...

int[string] numbers = ["a" : 10, "b" : 20]; assert("a" in numbers); assert("b" in numbers); assert("c" in numbers);

type Props = { posts: Array<Article>, dispatch: Function, children: ReactElement } const AppContainer = ({ posts, dispatch, children }: Props) => ( <div className="main-app"> <Header {...{ posts, dispatch }} /> {children} </...

By default communication over the channcels is sync; when you send some value there must be a receiver. Otherwise you will get fatal error: all goroutines are asleep - deadlock! as follows: package main import "fmt" func main() { msg := make(chan string) msg <- "He...

Weighted Job Scheduling Algorithm can also be denoted as Weighted Activity Selection Algorithm. The problem is, given certain jobs with their start time and end time, and a profit you make when you finish the job, what is the maximum profit you can make given no two jobs can be executed in parallel...

One of the best features of async/await syntax is that standard try-catch coding style is possible, just like you were writing synchronous code. const myFunc = async (req, res) => { try { const result = await somePromise(); } catch (err) { // handle errors here } }); Here'...

Import the namespace System.Runtime.Caching(Make sure that you have added System.Runtime.Caching DLL to your project reference). Create an instance of MemoryCache class. MemoryCache memCache = MemoryCache.Default; Add values to MemoryCache public IQueryable<tblTag> GettblTags() ...

Most Rx operators take an optional scheduler on which to schedule their future iterations. If not supplied they will use their default configured scheduler. Supplying a scheduler can be useful for testing purposes in which we like to talk about virtual time instead of real time for speed of test exe...

YAML supports three styles of escape notation: Entity Escapes a. space: " " b. colon: ":" c. ampersand: "&" Unicode Escapes a. space: "\u0020" b. single quote: "\u0027" c. double quote: "\u0022" ...

We have a set of jobs J={a,b,c,d,e,f,g}. Let j in J be a job than its start at sj and ends at fj. Two jobs are compatible if they don't overlap. A picture as example: The goal is to find the maximum subset of mutually compatible jobs. There are several greedy approaches for this problem: Earli...

In order to create a scheduler,the entry needs to be created in liferay-portlet.xml provding scheduler class and trigger value for timing of scheduler triggering <portlet-name>GetSetGo</portlet-name> <icon>/icon.png</icon> <scheduler-entry> ...

Take a use case, like a chat app or a collaborative grocery list app (that basically requires a list of objects to be synced across users). If you use firebase database and add a value event listener to the chat parent node or grocery list parent node, you will end with entire chat structure from th...