2020-04-01から1ヶ月間の記事一覧
MySQL 移行元: MySQL 5.6 mmm050移行先: MySQL 5.7 mmm051 【1】confファイルの設定[移行元での作業] vim /etc/my.cnf [mysqld]・・・log_binserver_id=101binlog_format=STATEMENTmax_binlog_size=100Mexpire_logs_days=30sync_binlog=1innodb_flush_log_at…
MySQL (5.6) drop table tab1;create table tab1(col1 int auto_increment primary key,col2 varchar(100)); insert into tab1(col2) values('A');insert into tab1(col2) values('A');insert into tab1(col1,col2) values(12,'B');insert into tab1(col2) v…
Ubuntu (16)https://ja.stackoverflow.com/questions/17999/ifs%E3%81%AB%E6%94%B9%E8%A1%8C%E3%81%AE%E3%81%BF%E3%82%92%E6%8C%87%E5%AE%9A%E3%81%97%E3%81%9F%E3%81%84 echo $SHELL : > a.txtecho "1 2 3" >> a.txtecho "4 5 6" >> a.txtecho "7 8 9" >> a…
MySQL (5.6)対応していない (8.0)※ recursiveが必要 with recursive t1(col1) as(select 1union allselect col1+1from t1where col1+1 <= 100)select col1 from t1; Oracle (12cR1) https://www.oracle.com/technetwork/jp/articles/otnj-sql-image7-1525406…
MySQL (5.6)drop table tab1;create table tab1(col1 int not null,col2 int,col3 char(100)); drop procedure proc1; delimiter //create procedure proc1()begin declare i int; declare j int; declare k int; set i = 1; set j = 1; set k = 1; while i …
MySQL (5.6) drop table tab1;create table tab1(col1 int not null,col2 int,col3 char(100)); drop procedure proc1; delimiter //create procedure proc1()begin declare i int; declare j int; declare k int; set i = 1; set j = 1; set k = 1; while i …
MySQL (5.6)ない模様 Oracle (12cR1) select /* TEST */ * from tab1; select sql_id,sql_text,child_number,plan_hash_valuefrom v$sqlwhere sql_text like '%TEST%'; PostgreSQL (9.4)ない模様 SQL Server (2014) select /* TEST */ * from tab1; select t…
MySQL (5.6) drop table tab1;create table tab1(col1 int); select table_schema,table_name,create_time,update_timefrom information_schema.tables where table_name = 'tab1'; alter table tab1 add col2 int; select table_schema,table_name,create_t…
MySQL (5.6)ない模様 Oracle (12cR1) select /* TEST */ * from tab1; select sql_id,sql_text,child_numberfrom v$sqlwhere sql_text like '%TEST%'; PostgreSQL (9.4)select /* TEST */ * from tab1;select userid,dbid,queryid,query from pg_stat_statem…
