Skip to content

Instantly share code, notes, and snippets.

@erkineren
erkineren / db-change-character-set-quickly.sql
Last active June 18, 2019 15:08
Change db tables and columns charset quickly - Veritabanı tablo ve kolonlar karakter setini hızlı değiştir
SELECT CONCAT('ALTER TABLE ',TABLE_SCHEMA,'.',TABLE_NAME,' CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;')
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'db_name';
# Example Output - Örnek Çıktı:
# ALTER TABLE db_name.table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
@erkineren
erkineren / mysql.functions.sql
Last active November 27, 2019 12:56
MySQL Snippets
CREATE FUNCTION `random_datetime_in_range`(
`min_date` TIMESTAMP,
`max_date` TIMESTAMP
)
RETURNS TIMESTAMP
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT 'Returns new timestamp between %min_data% and %max_date%'
@erkineren
erkineren / certbot-wildcard.sh
Created January 12, 2020 17:59
certbot lets encrypt create wildcard certificate and install
certbot certonly --manual --preferred-challenges dns --server https://acme-v02.api.letsencrypt.org/directory --manual-public-ip-logging-ok -d '*.domain.tld' -d domain.tld && \
certbot --preferred-challenges dns --server https://acme-v02.api.letsencrypt.org/directory --manual-public-ip-logging-ok -d '*.domain.tld' -d domain.tld
%UserProfile%\AppData\Local\Mailbird\Store\Store.db
@erkineren
erkineren / media-query.css
Created April 4, 2020 14:49 — forked from gokulkrishh/media-query.css
CSS Media Queries for Desktop, Tablet, Mobile.
/*
##Device = Desktops
##Screen = 1281px to higher resolution desktops
*/
@media (min-width: 1281px) {
//CSS
@erkineren
erkineren / emulator-install-using-avdmanager.md
Created September 10, 2021 15:34 — forked from mrk-han/emulator-install-using-avdmanager.md
Installing and creating Emulators with AVDMANAGER (For Continuous Integration Server or Local Use)

Install and Create Emulators using AVDMANAGER and SDKMANAGER

TL;DR

For generic skin emulator with default apis (without google apis):

  1. List All System Images Available for Download: sdkmanager --list | grep system-images

  2. Download Image: sdkmanager --install "system-images;android-29;default;x86"

@erkineren
erkineren / abdf.md
Last active January 25, 2022 08:44
flutter adbf > build + install + stop + start + logcat

flutter adbf > build + install + stop + start + logcat

INFO

adbf.sh is adb-flutter command line script that composed with flutter and adb commands. Go to code

USAGE

  • Default behaviour (flutter build + stop app + install app + start app + show logcat of app) adbf.sh