Skip to content

Instantly share code, notes, and snippets.

Keybase proof

I hereby claim:

  • I am ilhanyumer on github.
  • I am ilhan (https://keybase.io/ilhan) on keybase.
  • I have a public key ASDPL0_i9Lkg1U_-XwrtvW8l5XWzT0vbijudbmKqHEM1rwo

To claim this, I am signing this object:

@ilhanyumer
ilhanyumer / backupschema.bat
Last active July 16, 2020 09:59
Backup MySQL Schema
mysqldump -d -h 127.0.0.1 -u the_user_name -pThePassword DATABASE_NAME --skip-add-drop-table | sed 's/AUTO_INCREMENT=[0-9]*\b//' > the_database_backup.sql

Keybase proof

I hereby claim:

  • I am ilhanyumer on github.
  • I am ilhan (https://keybase.io/ilhan) on keybase.
  • I have a public key ASBihPs3GDJ-MRCWoIagO4qItP1hyEg1bNa88Ozy111kcAo

To claim this, I am signing this object:

@ilhanyumer
ilhanyumer / create-plpg.sql
Last active November 30, 2019 08:38
Simple PL/pgSQL
create or replace procedure test()
as $body$
declare
variable integer := 0;
begin
raise notice 'variable: %', variable;
end;
$body$
language plpgsql
<?php
// bu dosyayı çalıştırmak için CMD'ye
// php April4.php
// yazınız.
// .mp3 uzantılı dosyaların içeriği Base64'e dönüştürülecek.
// ve .base64 uzantılı yeni dosyalar oluşturulacak.
$iterator = new \GlobIterator(__DIR__ . '/*.mp3', FilesystemIterator::KEY_AS_FILENAME);
$files = iterator_to_array($iterator);