본문 바로가기

카테고리 없음

2020-10-28 08시 개발자 글 모음 | "EXPERIENTIAL FUTURIS" 외 2개 이야기

[DB2] 레지스트리 및 환경 변수 by 이정해

  • DB2® 데이터베이스 제품은 시작 및 실행을 위해 알아야 하는 여러 가지 레지스트리 변수 및 환경 변수를 제공합니다
  • 지원되는 모든 레지스트리 변수 목록을 보려면 다음 명령을 실행하십시오
  • db2start 명령을 실행하기 전에 갱신할 레지스트리 변수에 대한 값을 설정해야 합니다


[MySQL] Table Column 정보확인 by 이정해 about MySQL,SQL

  • mysql> show columns from tb1; +--------------+--------------+------+-----+-------------------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+-------------------+-------+ | col1 | varchar(128) | NO | PRI | NULL | | | col2 | datetime | YES | | CURRENT_TIMESTAMP | | | col3 | varchar(32) | NO | | NULL | | | col4 | varchar(16) | NO | | NULL | | | col5 | varchar(45) | YES | | | | | col6 | varchar(128) | YES | | NULL | | | col7 | varchar(128) | YES | | NULL | | | col8 | varchar(128) | YES | | NULL | | | col9 | varchar(45) | YES | | NULL | | | col10 | varchar(45) | YES | | NULL | | | col11 | tinyint(2) | NO | | 0 | | +--------------+--------------+------+-----+-------------------+-------+ 11 rows in set (0
  • mysql> show columns from tb1 like '%c1%'; +------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+-------+ | c1 | varchar(128) | NO | PRI | NULL | | | c10 | varchar(16) | NO | | NULL | | | c11 | varchar(16) | NO | | NULL | | +------------+--------------+------+-----+---------+-------+ 2 rows in set (0
  • mysql> use mysql; mysql> show table status; +-------------------------------+--------+---------+------------+--------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+--------------------+---------------------------------------------------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +-------------------------------+--------+---------+------------+--------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+--------------------+---------------------------------------------------+ | columns_priv | MyISAM | 10 | Fixed | 0 | 0 | 0 | 227994731135631359 | 4096 | 0 | NULL | 2020-07-08 00:22:19 | 2020-07-08 00:22:19 | NULL | utf8_bin | NULL | | Column privileges | | db | MyISAM | 10 | Fixed | 1 | 440 | 440 | 123848989752688639 | 5120 | 0 | NULL | 2020-07-08 00:22:19 | 2020-07-09 04:58:15 | 2020-07-08 00:22:19 | utf8_bin | NULL | | Database privileges | | event | MyISAM | 10 | Dynamic | 2 | 234 | 468 | 281474976710655 | 4096 | 0 | NULL | 2020-07-08 00:22:19 | 2020-07-08 00:22:19 | NULL | utf8_general_ci | NULL | | Events | | func | MyISAM | 10 | Fixed | 0 | 0 | 0 | 162974011515469823 | 1024 | 0 | NULL | 2020-07-08 00:22:19 | 2020-07-08 00:22:19 | NULL | utf8_bin | NULL | | User defined functions | | general_log | CSV | 10 | Dynamic | 2 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | General log | | general_log_template | CSV | 10 | Dynamic | 2 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | General log | | help_category | MyISAM | 10 | Dynamic | 38 | 28 | 1072 | 281474976710655 | 3072 | 0 | NULL | 2013-06-11 02:30:32 | 2018-04-20 19:19:45 | NULL | utf8_general_ci | NULL | | help categories | | help_keyword | MyISAM | 10 | Fixed | 453 | 197 | 89241 | 55450570411999231 | 16384 | 0 | NULL | 2009-03-16 03:54:49 | 2018-04-20 19:19:45 | NULL | utf8_general_ci | NULL | | help keywords | | help_relation | MyISAM | 10 | Fixed | 992 | 9 | 8928 | 2533274790395903 | 18432 | 0 | NULL | 2009-03-16 03:54:49 | 2018-04-20 19:19:45 | NULL | utf8_general_ci | NULL | | keyword-topic relation | | help_topic | MyISAM | 10 | Dynamic | 505 | 832 | 420260 | 281474976710655 | 20480 | 0 | NULL | 2013-06-11 02:30:32 | 2018-04-20 19:19:45 | NULL | utf8_general_ci | NULL | | help topics | | host | MyISAM | 10 | Fixed | 0 | 0 | 0 | 110056715893866495 | 2048 | 0 | NULL | 2012-05-19 05:19:19 | 2018-04-20 19:19:45 | NULL | utf8_bin | NULL | | Host privileges; Merged with database privileges | | innodb_index_stats | InnoDB | 10 | Compact | 26 | 630 | 16384 | 0 | 0 | 0 | NULL | 2020-07-08 00:22:19 | NULL | NULL | utf8_bin | NULL | stats_persistent=0 | | | innodb_table_stats | InnoDB | 10 | Compact | 8 | 2048 | 16384 | 0 | 0 | 0 | NULL | 2020-07-08 00:22:19 | NULL | NULL | utf8_bin | NULL | stats_persistent=0 | | | ndb_binlog_index | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2012-09-30 18:40:18 | 2018-04-20 19:19:45 | NULL | latin1_swedish_ci | NULL | | | | plugin | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2020-07-08 00:22:19 | 2020-07-08 00:22:19 | NULL | utf8_general_ci | NULL | | MySQL plugins | | proc | MyISAM | 10 | Dynamic | 75 | 5856 | 439232 | 281474976710655 | 8192 | 0 | NULL | 2020-07-08 00:22:19 | 2020-07-08 00:23:21 | NULL | utf8_general_ci | NULL | | Stored Procedures | | procs_priv | MyISAM | 10 | Fixed | 0 | 0 | 0 | 239253730204057599 | 4096 | 0 | NULL | 2020-07-08 00:22:19 | 2020-07-08 00:22:19 | 2020-07-08 00:22:19 | utf8_bin | NULL | | Procedure privileges | | proxies_priv | MyISAM | 10 | Fixed | 1 | 693 | 693 | 195062158860484607 | 5120 | 0 | NULL | 2011-01-07 00:48:59 | 2018-04-20 19:19:45 | 2011-01-07 00:48:59 | utf8_bin | NULL | | User proxy privileges | | rds_configuration | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 0 | 0 | NULL | 2020-07-08 00:22:19 | NULL | NULL | latin1_swedish_ci | NULL | | | | rds_global_status_history | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-07-08 00:22:15 | NULL | NULL | latin1_swedish_ci | NULL | | | | rds_global_status_history_old | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-07-08 00:22:15 | NULL | NULL | latin1_swedish_ci | NULL | | | | rds_heartbeat2 | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-07-08 00:22:21 | NULL | NULL | utf8_bin | NULL | | | | rds_history | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-07-08 00:22:19 | NULL | NULL | latin1_swedish_ci | NULL | | | | rds_replication_status | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-07-08 00:22:19 | NULL | NULL | latin1_swedish_ci | NULL | | | | rds_sysinfo | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-07-08 00:26:36 | NULL | NULL | utf8_general_ci | NULL | | | | servers | MyISAM | 10 | Fixed | 0 | 0 | 0 | 433752939111120895 | 1024 | 0 | NULL | 2009-03-16 03:54:49 | 2018-04-20 19:19:45 | NULL | utf8_general_ci | NULL | | MySQL Foreign Servers table | | slave_master_info | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-07-08 00:22:19 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | Master Information | | slave_relay_log_info | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-07-08 00:22:19 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | Relay Log Information | | slave_worker_info | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-07-08 00:22:19 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | Worker Information | | slow_log | CSV | 10 | Dynamic | 2 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | Slow log | | slow_log_template | CSV | 10 | Dynamic | 2 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | Slow log | | tables_priv | MyISAM | 10 | Fixed | 0 | 0 | 0 | 239535205180768255 | 4096 | 0 | NULL | 2020-07-08 00:22:19 | 2020-07-08 00:22:19 | 2020-07-08 00:22:19 | utf8_bin | NULL | | Table privileges | | time_zone | MyISAM | 10 | Fixed | 1777 | 7 | 12439 | 1970324836974591 | 20480 | 0 | 1778 | 2020-07-08 00:22:20 | 2020-07-08 00:22:21 | NULL | utf8_general_ci | NULL | | Time zones | | time_zone_leap_second | MyISAM | 10 | Fixed | 0 | 0 | 0 | 3659174697238527 | 1024 | 0 | NULL | 2009-03-16 03:54:49 | 2018-04-20 19:19:45 | NULL | utf8_general_ci | NULL | | Leap seconds information for time zones | | time_zone_name | MyISAM | 10 | Fixed | 1777 | 197 | 350069 | 55450570411999231 | 51200 | 0 | NULL | 2020-07-08 00:22:20 | 2020-07-08 00:22:21 | NULL | utf8_general_ci | NULL | | Time zone names | | time_zone_transition | MyISAM | 10 | Fixed | 118390 | 17 | 2012630 | 4785074604081151 | 2239488 | 0 | NULL | 2020-07-08 00:22:21 | 2020-07-08 00:22:21 | NULL | utf8_general_ci | NULL | | Time zone transitions | | time_zone_transition_type | MyISAM | 10 | Fixed | 8500 | 38 | 323000 | 10696049115004927 | 124928 | 0 | NULL | 2020-07-08 00:22:21 | 2020-07-08 00:22:21 | NULL | utf8_general_ci | NULL | | Time zone transition types | | user | MyISAM | 10 | Dynamic | 4 | 119 | 476 | 281474976710655 | 2048 | 0 | NULL | 2020-07-08 00:22:19 | 2020-07-09 04:58:14 | NULL | utf8_bin | NULL | | Users and global privileges | +-------------------------------+--------+---------+------------+--------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+--------------------+---------------------------------------------------+ 38 rows in set (0


EXPERIENTIAL FUTURIST,실험적미래주의 - AI, 블랙미러와 소셜딜레마로 보는 미래 디자인 by 장익환

  • 나도 무언가 미래지향적인 새로운 것을 만들고자 하였는데 난 몇 가지 내 머릿속에 특히 엔지니어로써의 그 ‘툴’은 알고있지만 다른것은 몰랐으니 이건 너무나도 당연하게 결과물은 이게 뭔지 도통 알 수없는 상황이 된 것이다
  • 중고등학교때 내가 홈페이지 만드는 것을 좋아했던 이유는 개인홈페이지를 통해서 나만의 그 디자인을 만들면서 꾸미는 것이 좋았었고 각각의 홈페이지마다 디자인에 대한 의미도 있었다
  • 그간 나는 데이터와 시각화를 통해 다른 시각을 낼 수 있는 방법에 대해서 생각했었는데 이를 유라임을 엔지니어링 적 이외에 어떻게 더 만들고 나아가야 할지에 대해 감을 잡을 수 없었다