Rizuki Ryumada ryumada

basic psql commands for easy read

commands	description
`GRANT ALL PRIVILEGES ON DATABASE <<nama database>> TO <<nama user>>;`	Query to grant All Previledges to a user
`sudo -u postgres psql`	Linux ubuntu login to superadmin
`CREATE USER <<nama user>> WITH ENCRYPTED PASSWORD '<<password>>';`	Query to create user
`\l`	get database list in the postgres server
`\c database_name`	connect to a database (You need to connect to a database first before you can run the below commands)
`\d table_name`	show table details

You can fix that by following these steps:

Place your cursor into the styles with blacked-out numbering.
Press ctrl + shift + S, then a popup will be showed up like the screenshot below
Without changing anything, just press reapply button and your numbering will be back to normal again.
If not, you must remake again your multilevel list

This does not contain a common SQL Query, maybe I will add it in the future. it still just contains any command that is commonly used via terminal/console.

Table of contents:

Add Column to table
Change the name of the attribute and its type.
Create a table
Delete a database
Delete a table
Delete an attribute / column
Login to enter MySQL System

	const getDaterangeOneMonth = () => {
	let date = new Date();

	let dateLater = new Date();
	dateLater.setDate(date.getDate() + 30);

	return `${date.toISOString().split("T")[0]} - ${dateLater.toISOString().split("T")[0]}`;
	}

	console.log(getDaterangeOneMonth); // 2021-10-25 - 2021-11-24

	# refresh local branches to remote server
	git remote update origin --prune

	# remove cloned branch item
	# remove staged branch item
	git rm -rf

	# remove files in origin after add it to .gitignore
	# remove cached file in origin
	git rm --cached file1.txt

	<div class="container pt-5">
	<div class="row">
	<div class="col-lg-8">
	<form class="form-validate-summernote">
	<div class="form-group">
	<label>Name</label>
	<input class="form-control" name="form2-name" type="text" required="required" data-msg="Please enter your name"/>
	</div>
	<div class="form-group">
	<label>Text</label>

	// generates random words
	function createRandomWord(length) {
	var consonants = 'bcdfghjlmnpqrstv',
	vowels = 'aeiou',
	rand = function(limit) {
	return Math.floor(Math.random()*limit);
	},
	i, word='', length = parseInt(length,10),
	consonants = consonants.split(''),
	vowels = vowels.split('');

	<?php

	namespace App\Console\Commands;

	use Illuminate\Console\Command;
	use Illuminate\Support\Facades\Artisan;

	class RefreshDatabaseCommand extends Command
	{

	let string = <?php echo "`" . trim(preg_replace('/\s\s+/', ' ', nl2br($summary_notes[$whoami]['text']))) . "`"; ?>;

	console.log(string);

	Swal.fire({
	title: 'Form Validation Error',
	html: "Please fill the required input form.",
	icon: 'warning',
	showCancelButton: false,
	// confirmButtonColor: '#99FF99',
	// cancelButtonColor: '#d33',
	confirmButtonText: 'Ok, I wiil check it.',
	allowOutsideClick: false,
	allowEscapeKey: false,