MySQL (8.0.22) drop table tab1;create table tab1(col1 int primary key);insert into tab1 values(1);insert into tab1 values(2);select * from tab1; drop procedure proc1; delimiter //create procedure proc1()begindeclare done int default 0;decl…

MySQL (8.0.22) select @@secure_file_priv; drop table tab1;drop table tab2; create table tab1(col1 int primary key,col2 int);create table tab2(col1 int primary key); insert into tab1 values(1,100);insert into tab1 values(2,200);insert into …

MySQL 調べた限り未対応 Oracle (12cR1) -- 設定 conn / as sysdbadrop flashback archive fla1;create flashback archive default fla1 tablespace users quota 1G retention 1 month; select * from dba_flashback_archive;select * from dba_flashback_ar…

MySQL (8)https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlock-detection.html 小さいトランザクションがロールバックされる InnoDB tries to pick small transactions to roll back, where the size of a transaction is determined by the number of…

Ubuntu (20)https://www.server-world.info/query?os=Ubuntu_18.04&p=pam_tally -- 1.設定vim /etc/ssh/sshd_configUsePAM yes systemctl restart sshdsystemctl status sshd vim /etc/pam.d/common-auth 下記を追加(3回失敗で無期限ロック) auth required p…

MySQL (8.0.22) 10進数→16進数 select conv(1,10,16);select conv(10,10,16);select conv(16,10,16);select conv(17,10,16); 16進数→10進数 select conv('1',16,10);select conv('A',16,10);select conv('10',16,10);select conv('11',16,10); Oracle (19c) …

MySQL (8.0.22) drop table tab1;create table tab1(col1 int); drop procedure proc1; delimiter //create procedure proc1()begindeclare i bigint;set i = 1;while i <= 100 do insert into tab1 values(floor(rand() * 1000)+1); set i = i + 1;end whil…

MySQL (8.0.23) mysqldumpでバックアップ取得し、別サーバにリストア -- 事前準備移設元:mmm181移設先:mmm182 2台の同スペックのサーバにMySQLをインストール移設元のみDB作成実施 -- 移設元でバックアップ取得 mysqldump -u root --databases test -p --qui…