Skip to content

Instantly share code, notes, and snippets.

@ismanapa
ismanapa / delete.sql
Created October 24, 2017 06:37
Delete all the tables and views of the current database
SET FOREIGN_KEY_CHECKS = 0;
SET GROUP_CONCAT_MAX_LEN=32768;
SET @tables = NULL;
SELECT GROUP_CONCAT('`', table_name, '`') INTO @tables
FROM information_schema.tables
WHERE table_schema = (SELECT DATABASE());
SELECT IFNULL(@tables,'dummy') INTO @tables;
SET @tables = CONCAT('DROP TABLE IF EXISTS ', @tables);
PREPARE stmt FROM @tables;
@ismanapa
ismanapa / HAXM_error.png
Last active February 25, 2021 17:45
React Native environment installation
HAXM_error.png
@ismanapa
ismanapa / 📖 book.md
Created September 5, 2022 14:34
New book template for Obsidian and Templater

<%* const http = require("https"); const fs = require("fs");

isbn = await tp.system.prompt("ISBN");

const downloadFile = (url) => { return new Promise((resolve) => { const path = ${tp.file.path().split("/").slice(0,-1).join("/")}/attachments; const fileName = url.split("/").pop();

{
"rules": [
{
"description": "Insert (Ctrl) [+Terminal Emulators]",
"manipulators": [
{
"conditions": [
{
"bundle_identifiers": [
"^org\\.virtualbox\\.app\\.VirtualBoxVM$",