Skip to content

Instantly share code, notes, and snippets.

@sezemiadmin

sezemiadmin/backup.sql

Last active August 17, 2018 09:49
Show Gist options
  • Save sezemiadmin/2c281976dc2c35b888c7c337b5a944fa to your computer and use it in GitHub Desktop.
Save sezemiadmin/2c281976dc2c35b888c7c337b5a944fa to your computer and use it in GitHub Desktop.
Download ZIP
ハンズオンで学ぶデータベース障害のパターンと復旧 のサンプル
Raw
backup.sql
CREATE TABLE emp2 AS SELECT * FROM EMP;
Raw
recovery.sql
INSRET INTO emp
SELECT * FROM emp2
WHERE ID = hoge;
Raw
sql_injection.sql
WHERE
emp_id = ' ' OR 'x'='x' // employees という従業員テーブルがある想定
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment