Alexander AlexRogalskiy

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

Download and install the docx2txt converter from http://docx2txt.sourceforge.net/

wget -O doc2txt.tar.gz http://docx2txt.cvs.sourceforge.net/viewvc/docx2txt/?view=tar
tar zxf docx2txt.tar.gz
cd docx2txt/docx2txt/

sudo make

Before we look at some common commands, I just want to note a few keyboard commands that are very helpful:

In this tutorial, you will learn how to implement a custom IdentifierGenerator to support auto-generated and manually assigned Ids using Hibernate.

	#-----------------------------------------------------------------------------------------------------
	# if user is not root, pass all commands via sudo #
	if [ $UID -ne 0 ]; then
	alias reboot='sudo reboot'
	alias update='sudo apt-get upgrade'
	fi
	#-----------------------------------------------------------------------------------------------------
	### Get os name via uname ###
	_myos="$(uname)"

	# Important note: If you want the code in this project to be formatted as per the formatting configuration mentioned in this '.editorconfig' file, then open webstorm, go to 'File' => 'Setting' => 'Editor' => 'Code Style' => 'EditorConfig' => Set 'Enable EditorConfig Support' to true => Click 'Apply' => Click 'Ok'
	# For Knowledge: The formatting settings of webstorm IDE of various file types, like Javascript, json, Typescript files, only apply when the above mentioned checkbox of 'Enable EditorConfig support' is set to false.

	[*]
	charset = utf-8
	end_of_line = lf
	indent_size = 2
	indent_style = space
	insert_final_newline = false
	max_line_length = 120

	import kotlinx.coroutines.experimental.*
	import kotlinx.coroutines.experimental.channels.*

	class FixedPool(val workerCount: Int) {

	val channel = Channel<Task>()
	val jobs = mutableListOf<Job>()

	init {
	start() // start immediately

	public class Counter {

	private int count = 0;

	public int getCount() {
	return count ;
	}

	/**
	* The "synchronized" keyword is crucial here; removing it will lead to serious

	BEGIN;

	DO $$
	BEGIN
	IF NOT EXISTS (SELECT 1 FROM pg_type WHERE typname = 'task_status') THEN
	create type task_status AS ENUM ('todo', 'doing', 'blocked', 'done');
	END IF;
	END
	$$;
	CREATE TABLE IF NOT EXISTS