!apt update error https://ameblo.jp/l-yotarou/entry-12722370981.html sudo apt update ¤ò¼Â¹Ô¤·¤¿»þ¤Ë ½ð̾¾È¹çÃæ¤Ë¥¨¥é¡¼¤¬È¯À¸¤·¤Þ¤·¤¿¡£¥ê¥Ý¥¸¥È¥ê¤Ï¹¹¿·¤µ¤ì¤º¡¢²áµî¤Î¥¤¥ó¥Ç¥Ã¥¯¥¹¥Õ¥¡¥¤¥ë¤¬»È¤ï¤ì¤Þ¤¹¡£GPG ¥¨¥é¡¼: http://repo.mysql.com/apt/ubuntu focal InRelease: ¸ø³«¸°¤òÍøÍѤǤ­¤Ê¤¤¤¿¤á¡¢°Ê²¼¤Î½ð̾¤Ï¸¡¾Ú¤Ç¤­¤Þ¤»¤ó¤Ç¤·¤¿: NO_PUBKEY 467B942D3A79BD29 ¤¬È¯À¸¤·¤Þ¤·¤¿¡£ °ì½Ö¥É¥­¥ê¤È¤·¤Þ¤¹¤¬¡¢¤³¤ó¤Ê»þ¤Ë¤Ï¹²¤Æ¤º¤Ë NO_PUBKEY 467B942D3A79BD29 !ºÇ¶áÊѹ¹¤·¤¿¥Õ¥¡¥¤¥ë¤ò¥Ç¥£¥ì¥¯¥È¥ê¤òÊÝ»ý¤·¤Æ¥³¥Ô¡¼ cp --parents `find source -mmin -360 -type f` /mnt/c/temp/. !¿ô»ú¤Î¤ßÆþÎϤµ¤»¤ë [jQuery¤Çinput¤Ë¿ô»ú¤Î¤ßÆþÎϤµ¤»¤ë¤¿¤á¤ÎËÜÅö¤ËÀµ¤·¤¤ÊýË¡|https://pisuke-code.com/jquery-input-number-only/] <- »²¾È [javascript] $(document).on('keydown', '.input_number_only', function(e){ let k = e.keyCode; let str = String.fromCharCode(k); if(!(str.match(/[0-9]/) || (37 <= k && k <= 40) || k === 8 || k === 46)){ return false; } }); // ¥Õ¥©¡¼¥«¥¹¤¬³°¤ì¤¿»þ¤Ë¿ôÃͰʳ°¤òºï½ü¤¹¤ë $(document).on('blur', '.input_number_only',function(){ this.value = this.value.replace(/[^0-9]+/i,''); }); [html] ÈÖÃÏ:
!¶Ø§½èÍý ¶Ø§½èÍý¤ò¹Ô¤¤¤Ä¤ÄÆÃÄê¤Îʸ»ú¿ô¤ÇÀÞ¤êÊÖ¤¹¡£¡ÊȾ³Ñʸ»ú¤ò¹Íθ¤·¤Æ¤Ê¤¤¤Î¤Çɽ¼¨Éý¤¬¤º¤ì¤ë¡Ë my $split = sub { my $moji = shift; my $in = shift; my @out; my $no_begin = "!%),.:;?]}¡¢¡£¡¹¡Ó¡Õ¡×¡Ù¡Û¡Í" . "¤¡¤£¤¥¤§¤©¤Ã¤ã¤å¤ç¤î¡µ¡¶¥¡¥£¥¥¥§¥©¥Ã¥ã¥å¥ç¥î¥õ¥ö" . "¡¼¡³¡´¡ª¡ó¡Ë¡¤¡¥¡§¡¨¡©¡Ï¡Ñ"; # ¹ÔƬ¶Ø§ʸ»ú my @char = $s->{dbh}->split_char($in); my $t = ''; my $i = 0; my $f = 0; for(@char){ if($_ eq "\n" or $i >= $moji){ push @out,$t; $i = 0; $t = ''; } if($i == 0 and $no_begin =~ /$_/ and $f == 0){ $out[-1] .= $_; $f = 1; next; } $f = 0; next if($_ eq "\n"); $t .= $_; $i++; } push @out,$t if($t ne ''); return @out; }; #------------------------------------------------------------------ sub split_char{ #------------------------------------------------------------------ my $s = shift; my $str = shift; my $ascii = '[\x00-\x7F]'; my $twoBytes = '[\x8E\xA1-\xFE][\xA1-\xFE]'; my $threeBytes = '\x8F[\xA1-\xFE][\xA1-\xFE]'; my @chars = $str =~ /$ascii|$twoBytes|$threeBytes/go; return @chars; } !¥Ø¥Ã¥É¥ì¥¹chrome [¥Ø¥Ã¥É¥ì¥¹ Chrome ¤³¤È¤Ï¤¸¤á|https://developers.google.com/web/updates/2017/04/headless-chrome?hl=ja] *"C:\Program Files\Google\Chrome\Application\chrome.exe" --headless --disable-gpu --no-sandbox --print-to-pdf=C:\temp\bar.pdf https://qweer.info/api/menu/menu *"C:\Program Files (x86)\Microsoft\Edge\Application\msedge.exe" --headless --disable-gpu --no-sandbox --print-to-pdf=C:\temp\bar.pdf https://qweer.info/api/menu/menu !Puppeteer ¤Î³µÍ× ¥Ñ¥Ú¥Ã¥È¥³¥¢¤ò»ÈÍѤ·¤Æ Microsoft Edge ¤òµ¯Æ°¤¹¤ë https://docs.microsoft.com/ja-jp/microsoft-edge/puppeteer/ !ÊØÍø¥ê¥ó¥¯ *[CSS¤ÎŤµ¡¢Â礭¤µ¤òɽ¤¹Ã±°Ì/ÊÑ´¹|https://web-designer.cman.jp/css_ref/function/tani/] *[JSON¤­¤ì¤¤ ¡ÁJSONÀ°·Á¥Ä¡¼¥ë¡Á|https://tools.m-bsys.com/development_tooles/json-beautifier.php] !rowspan¤Ècolspan¤Ç¶­³¦Àþ¤òÈóɽ¼¨¤Ë¤¹¤ë [Make border invisible with rowspan and colspan|https://stackoverflow.com/questions/53055413/make-border-invisible-with-rowspan-and-colspan]¤è¤ê Google Chrome¤Î¥Ð¥°¤Î¤è¤¦¤Ç¤¹¤¬¡¢µ¿»÷Í×ÁǤò»ÈÍѤ·¤ÆɬÍפʥӥ¸¥å¥¢¥ë¤òÍÑ°Õ¤¹¤ë¤È¤¤¤¦¥¢¥¤¥Ç¥¢¤Ï¼¡¤Î¤È¤ª¤ê¤Ç¤¹¡£ td { border-style: solid; } .hide-border { position:relative; } .hide-border:before { content:""; position:absolute; top:-3px; height:3px; left:0; right:0; background:#fff; }
1 2
3 WANT NO BORDER ABOVE THIS CELL
----- .leftBorderNone{ position: relative; border-left-style: hidden; } .leftBorderNone:before{ content:""; position:absolute; top:0px; bottom:0px; left:0px; width:1px; background:#fff; } !ORACLE¤Î¥Æ¡¼¥Ö¥ëÄêµÁ¤ò³Îǧ¤¹¤ë https://qiita.com/ohs30359-nobuhara/items/a04637a1f2b26ee34896 SELECT DISTINCT main.column_name AS ¥«¥é¥à̾, main.data_type AS ¥Ç¡¼¥¿·¿, main.data_length AS ¥«¥é¥àĹ, CASE main.nullable WHEN 'N' THEN '¡ß' WHEN 'Y' THEN '¡û' END AS NULLµö²Ä, sub.constraint_type AS ¼ç¥­¡¼, sub.last_change AS ºÇ½ª¹¹¿·Æü, sub.index_name AS ¥¤¥ó¥Ç¥Ã¥¯¥¹Ì¾ FROM user_tab_columns main LEFT JOIN (SELECT col.column_name AS column_name, con.constraint_type AS constraint_type, con.last_change AS last_change, con.index_name AS index_name, con.table_name AS table_name FROM user_constraints con JOIN user_cons_columns col ON con.constraint_name = col.constraint_name AND con.table_name = col.table_name WHERE con.constraint_type = 'P' ORDER BY con.table_name) sub ON sub.column_name = main.column_name AND sub.table_name = main.table_name WHERE main.table_name = :table_name; !edge ENTER to next function nextElementFocus(name){ var userAgent = window.navigator.userAgent; if (userAgent.match(/MSIE/)){ window.event.keyCode = 0x09; return; } var elements = Array.prototype.slice.call(document.getElementsByTagName('*')); elements.sort(function(a,b){ return a.tabIndex - b.tabIndex;}); var ix=1; for (var i=0;i= elements.length){ i=0; ix=0; } } //alert(elements[i+ix].name + "|" + JSON.stringify(document.activeElement)); //elements[i + ix].focus(); //elements[i + ix].select(); break; } } event.preventDefault(); } !ie->edge¤Î½¤ÀµÆâÍÆ £±¡¥scriptX¤¬»È¤¨¤Ê¤¤¤Î¤Çcss¤Ç¥Ú¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤ò¹Ô¤¦¡£ @page { size: A4 landscape; /* landscape:²£ */ margin: 0px 0px 0px 0px; //side } .pageSetting{ margin: 0px 0px 0px 0px; //up /* ¾å¡¡±¦¡¡²¼¡¡º¸ */ } *@page¤Ë¤Ætop¥Þ¡¼¥¸¥ó¤ò¾®¤µ¤¯¤·¤Ê¤¤¤ÈÆüÉÕ¡¢¥¿¥¤¥È¥ë¡¢¥Ú¡¼¥¸¤¬°õºþ¤µ¤ì¤ë¡£º¸±¦¤Î¥Þ¡¼¥¸¥ó¤Ï@page¤Ë¤Æ¹Ô¤¤¡¢¾å²¼¤Î¥Þ¡¼¥¸¥ó¤ÏpageSettinng¥¯¥é¥¹¤Ç¹Ô¤¦¡£³Æ¥Ú¡¼¥¸¤Ï
¤Ç¤¯¤¯¤ë»ö £²¡¥ENTERÆþÎÏ»þ¤Ë¼¡¹àÌܤ˰ÜÆ°¤¹¤ë°Ù¤Î¡Éwindow.event.keyCode = 0x09;¡É¤¬¸ú¤«¤Ê¤¤¡£ *JavaScript¤Ë¤ÆnextElementFocus¥Õ¥¡¥ó¥¯¥·¥ç¥ó¤òºîÀ®¤·tabIndex½ç¤Ë°ÜÆ°¤¹¤ë¤è¤¦¤Ë¤·¤¿¡£ £³¡¥table¥¿¥°¤ËÉý»ØÄ꤬¤Ê¤¤¤Èie¤È¥¤¥á¡¼¥¸¤¬°ã¤Ã¤Æ¤¯¤ë¡£¡Ê¥Ï¥ó¥³¤ÎÍó¤È¤«¡Ë *mmt.pm¤Îprintout¥µ¥Ö¥ë¡¼¥Á¥ó¤Ë¤Ætable¤Çwidth»ØÄê¤Î¤Ê¤¤¤â¤Î¤òwidth=100%¤ËÊäÀµ¤·¤¿¡£ £´¡¥¥¿¥°¤Îalign¤¬¸ú¤«¤Ê¤¤(ÇÑ»ß) *mmt.pm¤Îprintout¥µ¥Ö¥ë¡¼¥Á¥ó¤Ë¤Æ <¿·¥ê¥Ý¥¸¥È¥ê> *¥µ¡¼¥Ð¡¼¤Î¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×¡õ°ÜÆ°¤Ç¥Ð¡¼¥¸¥ç¥ó¤¬ÉÔ°ìÃ× svn: E155021: The path 'C:\aaa\bbbb\ccccc' appears to be part of a Subversion 1.7 or greater working copy. Please upgrade your Subversion client to use this working copy. ¥¢¥Ã¥×¥°¥ì¡¼¥É¤¹¤ë svn upgrade ¥í¡¼¥«¥ë¤Î¥Ð¡¼¥¸¥ç¥ó¤¬¹ç¤ï¤Ê¤¤¤È¸À¤ï¤ìsvn´Ä¶­¤òºî¤êľ¤¹»ö¤Ë¡Ä cd /var/www/cgi-bin/[localdir] find . -name .svn -exec rm -fr {} \; cd .. svn checkout svn+ssh://user@hostname/usr/local/svnroot/[systemname] cd [systemname] svn staus ¤Ç¡Ölocal unversioned, incoming add upon update¡×¤¬½Ð¤ë¤Î¤Ç²¼µ­¥³¥Þ¥ó¥É¤ò¼Â¹Ô svn resolved * status¤¬'D'¤Ë¤Ê¤ë¤Î¤ÇÊѹ¹¤ò¼è¤ê¾Ã¤¹ svn revert -R . !![Subversion¤Î¥ê¥Ý¥¸¥È¥ê¤òÊ̤Υµ¡¼¥Ð¡¼¤Ë°Ü¹Ô¤¹¤ë¼ê½ç|https://weblabo.oscasierra.net/subversion-repo-move/] Subversion¤Î¥ê¥Ý¥¸¥È¥ê¤òÊ̤Υۥ¹¥È¤Ø°Ü¹Ô¤¹¤ëºî¶È¤ò¹Ô¤Ã¤¿¤Î¤Ç¡¢ÊýË¡¤ò½ñ¤­»Ä¤·¤Þ¤¹¡£ !¼ê½ç³µÍ× Subversion¤Ë¤ª¤±¤ë¥ê¥Ý¥¸¥È¥ê¤Î°Ü¹Ô¤Ë¤Ï¡¢Subversion ¤Î´ÉÍý¥³¥Þ¥ó¥É svnadmin ¤òÍøÍѤ·¤Æ¡¢¸½¹Ô¤Î¥ê¥Ý¥¸¥È¥ê¤Î¥À¥ó¥×¥Ç¡¼¥¿¤ò½ÐÎϤ·¡¢¤½¤Î¥À¥ó¥×¥Ç¡¼¥¿¤ò´ð¤Ë¿·¤·¤¤¥µ¡¼¥Ð¡¼¤Ë¥ê¥Ý¥¸¥È¥ê¤òÉü¸µ¤µ¤»¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£ º£²ó¤Î¼ê½ç½ç½ø¤Ï°Ê²¼¤ÎÄ̤ê¤Ç¤¹¡£ +¸½¹Ô¤Î¥ê¥Ý¥¸¥È¥ê¤Î¥À¥ó¥×¥Ç¡¼¥¿¤ò½ÐÎϤµ¤»¤ë¡£(žÁ÷Éé²Ù¤ò²¼¤²¤ë°Ù¤Ë)¥À¥ó¥×¥Ç¡¼¥¿¤ò°µ½Ì¤µ¤»¤ë¡£ +°µ½Ì¤·¤¿¥À¥ó¥×¥Ç¡¼¥¿¤ò¿·¤·¤¤¥µ¡¼¥Ð¡¼¤ËžÁ÷¤¹¤ë¡£ +°µ½Ì¤µ¤ì¤¿¥À¥ó¥×¥Ç¡¼¥¿¤ò²òÅह¤ë¡£ +¿·¤·¤¤¥ê¥Ý¥¸¥È¥ê¤Ë¥À¥ó¥×¥Ç¡¼¥¿¤òÉü¸µ¤¹¤ë¡£ ¢¨µì¥µ¡¼¥Ð¡¼ # svnadmin dump /usr/local/svnroot/systemName >/tmp/svn.dump # cd /tmp # gzip svn.dump # scp svn.dump.gz newHostName:/tmp/. ¢¨¿·¥µ¡¼¥Ð¡¼ # mkdir /usr/local/svnroot/ # svnadmin create /usr/local/svnroot # cd /tmp # gzip -d svn.dump.gz # svnadmin load /usr/local/svnroot < svn.dump|tee /tmp/svnadmin.load.log ¢¨¥¯¥é¥¤¥¢¥ó¥È¤Î¥µ¥Ð¡¼ÀÚ¤êÂؤ¨ $ svn switch --relocate svn+ssh://user@oldHostName/usr/local/svnroot/systemName svn+ssh://user@newHostName/usr/local/svnroot !!¡¡ !°ÌÃÖ¾ðÊó http://www21051ue.sakura.ne.jp/geolocation.html !Ê£¿ô¥Õ¥¡¥¤¥ë¤ò¥¢¥Ã¥×¥É¡¼¥É http://www21051ue.sakura.ne.jp/album/album/album.cgi *¥¢¥ë¥Ð¥à - $cgi->filefield(-name=>'upload_file') + $cgi->filefield(-name=>'upload_file',-multiple=>'multiple') - my $filename = $cgi->param('upload_file'); + my @filename = $cgi->param('upload_file'); !LINE ART¤òÇØ·Ê¤Ë http://www21051ue.sakura.ne.jp/lineArt/lineArt.html !MeCab [2018/6/16] mecab¤Î¥Ð¡¼¥¸¥ç¥ó¤¬ÊѤï¤Ã¤¿¡Ê¡©¡Ë¤»¤¤¤«Text::MeCab¤¬Ê¸»ú²½¤±¤¹¤ë¤è¤¦¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤Ã¤¿¤Î¤ÇText::MeCab¤òMeCab¤ËÊѹ¹¤·¤¿¡£ https://github.com/john-smith-7701/mmt/commit/2e378c47731d991d4f54f4f75f277f71a78441d2#diff-c3bd1bdc903d833ff1fbe687f1ab4a68 $ perl -MMeCab -e 'print MeCab::Tagger->new()->parse("º£Æü¤ÏÎɤ¤Å·µ¤¤Ç¤Ï¤Ê¤¤")' º£Æü ̾»ì,Éû»ì²Äǽ,*,*,*,*,º£Æü,¥­¥ç¥¦,¥­¥ç¡¼ ¤Ï ½õ»ì,·¸½õ»ì,*,*,*,*,¤Ï,¥Ï,¥ï Îɤ¤ ·ÁÍÆ»ì,¼«Î©,*,*,·ÁÍƻ졦¥¢¥¦¥ªÃÊ,´ðËÜ·Á,Îɤ¤,¥è¥¤,¥è¥¤ Å·µ¤ ̾»ì,°ìÈÌ,*,*,*,*,Å·µ¤,¥Æ¥ó¥­,¥Æ¥ó¥­ ¤Ç ½õ»ì,³Ê½õ»ì,°ìÈÌ,*,*,*,¤Ç,¥Ç,¥Ç ¤Ï ½õ»ì,·¸½õ»ì,*,*,*,*,¤Ï,¥Ï,¥ï ¤Ê¤¤ ·ÁÍÆ»ì,¼«Î©,*,*,·ÁÍƻ졦¥¢¥¦¥ªÃÊ,´ðËÜ·Á,¤Ê¤¤,¥Ê¥¤,¥Ê¥¤ EOS $ $ perl -MText::MeCab -E 'my $m = Text::MeCab->new();my $n = $m->parse(pop); do{say $n->surface;} while ($n = $n->next);' '¤ï¤¿¤·¤Ï¤¿¤ï¤·¤ò¤ï¤¿¤¹' ¤ï¤¿¤· ¤Ï ¤¿¤ï¤· ¤ò ¤ï¤¿¤¹ $ !Perl¤ÈMXNet¤Çʸ¾ÏÀ¸À® http://film.rlss.okayama-u.ac.jp/~kgk/perl/mxnet-lstm/index.html ¸å¤Ç»î¤¹¡£ !2Ëç¤Î²èÁü¤Îdiff¡Êº¹Ê¬¡Ë¤òĶ´Êñ¤ËÄ´¤Ù¤ëÊýË¡ http://blog.mirakui.com/entry/20110326/1301111196 $ composite -compose difference A.jpg B.jpg diff.jpg !Debian(Ubuntu) apt-get upgrade ¤Î¡ÖE: ̤²ò·è¤Î°Í¸´Ø·¸¤Ç¤¹¡£¡×¤Ç¤Ï¤Þ¤Ã¤¿¤é https://server-setting.info/debian/apt-get-upgrade-error-loop.html ¤è¤ê apt-get upgrade ¤Î¡ÖE: ̤²ò·è¤Î°Í¸´Ø·¸¤Ç¤¹¡£¡×¤Ç¤Ï¤Þ¤Ã¤¿¤é aptitude ¤ò»È¤Ã¤Æ¤ß¤ë¤³¤È¤Ç¤¹¡£ £¶¡¥¤¤¤è¤¤¤è aptitude ¤ò»È¤Ã¤Æ¥Ñ¥Ã¥±¡¼¥¸¤Î¥¢¥Ã¥×¥°¥ì¡¼¥É¤ò¹Ô¤Ã¤Æ¤ß¤ë $ aptitude updatereturn ȯ¸« http://ftp.jp.debian.org squeeze Release.gpg ̵»ë http://ftp.jp.debian.org/debian/ squeeze/main Translation-en .... $ aptitude safe-upgradereturn °Ê²¼¤Î¥Ñ¥Ã¥±¡¼¥¸¤¬¹¹¿·¤µ¤ì¤Þ¤¹: libmysqlclient-dev libmysqlclient18 mysql-server-5.5 .... °Ê²¼¤Î¡¢¥¤¥ó¥¹¥È¡¼¥ë¤¬´°Î»¤·¤Æ¤¤¤Ê¤¤¥Ñ¥Ã¥±¡¼¥¸¤¬ÀßÄꤵ¤ì¤Þ¤¹: initscripts linux-base linux-image-2.6.32-5-amd64 mysql-client-5.5 mysql-server-core-5.5 ¹¹¿·: 24 ¸Ä¡¢¿·µ¬¥¤¥ó¥¹¥È¡¼¥ë: 0 ¸Ä¡¢ºï½ü: 0 ¸Ä¡¢ÊÝα: 1 ¸Ä¡£ 21.2 MB ¤Î¥¢¡¼¥«¥¤¥Ö¤ò¼èÆÀ¤¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£Å¸³«¸å¤Ë 2,619 kB ¤Î¥Ç¥£¥¹¥¯Îΰ褬¿·¤¿¤Ë¾ÃÈñ¤µ¤ì¤Þ¤¹¡£ Àè¤Ë¿Ê¤ß¤Þ¤¹¤«? [Y/n/?] y .... mysql-server-5.5 ¤òŸ³«¤·¡¢ÃÖ´¹¤·¤Æ¤¤¤Þ¤¹... dpkg: /var/cache/apt/archives/mysql-server-5.5_5.5.25-1~dotdeb.0_amd64.deb ¤Î½è ÍýÃæ¤Ë¥¨¥é¡¼¤¬È¯À¸¤·¤Þ¤·¤¿ (--unpack): '/usr/lib/mysql/plugin/ha_example.so' ¤ò¾å½ñ¤­¤·¤è¤¦¤È¤·¤Æ¤¤¤Þ¤¹¡£¤³¤ì¤Ï¥Ñ¥Ã¥± ¡¼¥¸ libmysqlclient-dev 5.5.24-1~dotdeb.1 ¤Ë¤â¸ºß¤·¤Þ¤¹ .... done ¸½ºß¤Î¾õÂÖ: ¹¹¿·¤¬ 24 ¸Ä [-1]¡£ ¤È¥¨¥é¡¼¤¬È¯À¸¤·¤Þ¤¹¤¬¡¢apt-get¤È°Û¤Ê¤ë¤Î¤Ï¡¢¥¤¥ó¥¹¥È¡¼¥ë¡Ê¥¢¥Ã¥×¥°¥ì¡¼¥É¡Ë¤Ç¤­¤ë¤â¤Î¤Ï¡¢Á´¤Æ¥¤¥ó¥¹¥È¡¼¥ë¡Ê¥¢¥Ã¥×¥°¥ì¡¼¥É¡Ë¤·¤Æ¤·¤Þ¤¦ÅÀ¤Ç¤¹¡£ apt-get¤Ç¤Ï¡¢¥¨¥é¡¼¤¬È¯À¸¤·¤¿»þÅÀ¤Ç¡¢½èÍý¤òÄä»ß¤·¤Æ¤·¤Þ¤¤¤Þ¤¹¤«¤é¡¢¤½¤³¤«¤éÈ´¤±½Ð¤»¤Ê¤¯¤Ê¤ë¤³¤È¤¬¡¢¤è¤¯¤¢¤ê¤Þ¤¹¡£ ³¤±¤Æ¡¢ºÆÅÙ¡¢aptitude safe-upgrade ¤òÅêÆþ¤·¤Þ¤¹¡£ £·¡¥aptitude safe-upgrade¤òºÆÅêÆþ¤·¤Æ¤ß¤ë $ aptitude safe-upgradereturn °Ê²¼¤Î¥Ñ¥Ã¥±¡¼¥¸¤¬¹¹¿·¤µ¤ì¤Þ¤¹: libmysqlclient-dev libmysqlclient18 mysql-server-5.5 .... ¹¹¿·: 23 ¸Ä¡¢¿·µ¬¥¤¥ó¥¹¥È¡¼¥ë: 0 ¸Ä¡¢ºï½ü: 0 ¸Ä¡¢ÊÝα: 1 ¸Ä¡£ ¥¢¡¼¥«¥¤¥Ö 20.4 MB Ãæ 0 B ¤ò¼èÆÀ¤¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£Å¸³«¸å¤Ë 2,296 kB ¤Î¥Ç¥£¥¹¥¯Îΰ褬¿·¤¿¤Ë¾ÃÈñ¤µ¤ì¤Þ¤¹¡£ Àè¤Ë¿Ê¤ß¤Þ¤¹¤«? [Y/n/?] y .... mysql-server-5.5 ¤òŸ³«¤·¡¢ÃÖ´¹¤·¤Æ¤¤¤Þ¤¹... dpkg: /var/cache/apt/archives/mysql-server-5.5_5.5.25-1~dotdeb.0_amd64.deb ¤Î½è ÍýÃæ¤Ë¥¨¥é¡¼¤¬È¯À¸¤·¤Þ¤·¤¿ (--unpack): '/usr/lib/mysql/plugin/ha_example.so' ¤ò¾å½ñ¤­¤·¤è¤¦¤È¤·¤Æ¤¤¤Þ¤¹¡£¤³¤ì¤Ï¥Ñ¥Ã¥± ¡¼¥¸ libmysqlclient-dev 5.5.24-1~dotdeb.1 ¤Ë¤â¸ºß¤·¤Þ¤¹ .... ¸½ºß¤Î¾õÂÖ: ¹¹¿·¤¬ 2 ¸Ä [-22]¡£ £¸¡¥aptitude safe-upgrade¤òºÆºÆÅêÆþ¤·¤Æ¤ß¤ë $ aptitude safe-upgradereturn °Ê²¼¤Î¥Ñ¥Ã¥±¡¼¥¸¤¬¹¹¿·¤µ¤ì¤Þ¤¹: mysql-server-5.5 ¹¹¿·: 1 ¸Ä¡¢¿·µ¬¥¤¥ó¥¹¥È¡¼¥ë: 0 ¸Ä¡¢ºï½ü: 0 ¸Ä¡¢ÊÝα: 1 ¸Ä¡£ ¥¢¡¼¥«¥¤¥Ö 8,860 kB Ãæ 0 B ¤ò¼èÆÀ¤¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£Å¸³«¸å¤Ë 841 kB ¤Î¥Ç¥£¥¹¥¯ Îΰ褬¿·¤¿¤Ë¾ÃÈñ¤µ¤ì¤Þ¤¹¡£ Àè¤Ë¿Ê¤ß¤Þ¤¹¤«? [Y/n/?] y changelog ¤òÆɤó¤Ç¤¤¤Þ¤¹... ´°Î» ¥Ñ¥Ã¥±¡¼¥¸¤ò»öÁ°ÀßÄꤷ¤Æ¤¤¤Þ¤¹ ... (¥Ç¡¼¥¿¥Ù¡¼¥¹¤òÆɤ߹þ¤ó¤Ç¤¤¤Þ¤¹ ... ¸½ºß 41075 ¸Ä¤Î¥Õ¥¡¥¤¥ë¤È¥Ç¥£¥ì¥¯¥È¥ê¤¬¥¤¥ó ¥¹¥È¡¼¥ë¤µ¤ì¤Æ¤¤¤Þ¤¹¡£) mysql-server-5.5 5.5.24-1~dotdeb.1 ¤ò (.../mysql-server-5.5_5.5.25-1~dotdeb.0_amd64.deb ¤Ç) ÃÖ´¹¤¹¤ë¤¿¤á¤Î½àÈ÷¤ò¤·¤Æ¤¤¤Þ¤¹ ... Stopping MySQL database server: mysqld. Stopping MySQL database server: mysqld. mysql-server-5.5 ¤òŸ³«¤·¡¢ÃÖ´¹¤·¤Æ¤¤¤Þ¤¹... man-db ¤Î¥È¥ê¥¬¤ò½èÍý¤·¤Æ¤¤¤Þ¤¹ ... mysql-server-5.5 (5.5.25-1~dotdeb.0) ¤òÀßÄꤷ¤Æ¤¤¤Þ¤¹ ... Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld .. Checking for tables which need an upgrade, are corrupt or were not closed cleanly.. ¸½ºß¤Î¾õÂÖ: °Í¸´Ø·¸ÇË»¤¬ 0 ¸Ä [-1], ¹¹¿·¤¬ 1 ¸Ä [-1]¡£ ¤È¥¨¥é¡¼¤¬¤Ê¤¯¤Ê¤ê¤Þ¤·¤¿¡£ °ì±þ¡¢³Îǧ¤Î¤¿¤á¡¢ºÆÅÙ¡¢aptitude safe-upgrade ¤òÅêÆþ¤·¤Þ¤¹¡£ $ aptitude safe-upgradereturn ¥¤¥ó¥¹¥È¡¼¥ë¡¦ºï½ü¡¦¹¹¿·¤µ¤ì¤ë¥Ñ¥Ã¥±¡¼¥¸¤¬¤¢¤ê¤Þ¤»¤ó¡£ ¹¹¿·: 0 ¸Ä¡¢¿·µ¬¥¤¥ó¥¹¥È¡¼¥ë: 0 ¸Ä¡¢ºï½ü: 0 ¸Ä¡¢ÊÝα: 1 ¸Ä¡£ 0 B ¤Î¥¢¡¼¥«¥¤¥Ö¤ò¼èÆÀ¤¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£Å¸³«¸å¤Ë 0 B ¤Î¥Ç¥£¥¹¥¯Îΰ褬¿·¤¿¤Ë¾Ã Èñ¤µ¤ì¤Þ¤¹¡£ *[UbuntuÆüËܸì¥Õ¥©¡¼¥é¥à / apt-get¤«¤éaptitude¤Ø¤Î¾è¤ê´¹¤¨|https://forums.ubuntulinux.jp/viewtopic.php?id=7318] !¥ì¥¹¥Ý¥ó¥¹¤Îheader¤Èbody¤ò³Îǧ¤¹¤ë¡£ $ curl -i -s http://localhost:3000/api/json/json_test01 HTTP/1.1 200 OK Content-Type: application/json;charset=UTF-8 Content-Length: 125 Server: Mojolicious (Perl) Date: Fri, 01 Jul 2016 01:48:07 GMT {"array":[1,2,3,4],"head":"Json Test Data","lang":["perl","ruby","php"],"ÆüËܸì":["´Á»ú","¤Ò¤é¤¬¤Ê","Ž¶ŽÀŽ¶ŽÅ"]} $ !UFT-16¤Ê¤ó¤À¡¦¡¦¡¦ ÆüËܸì¤Çºî¤Ã¤¿MySQL¤Î¥Æ¡¼¥Ö¥ë¤òDBI¤ÇÆɤ߹þ¤à¤È¥Õ¥£¡¼¥ë¥É̾¤¬UTF-16¤Ç ¼èÆÀ¤µ¤ì¤Æ¤·¤Þ¤¦¡£¤³¤ì¤Ï¤Ê¤«¤Ê¤«Ìñ²ð¤À¡ª¡ª $VAR1 = [ { 'Extra' => '', 'Type' => 'decimal(16,0)', 'Field' => "\x{5546}\x{54c1}\x{30b3}\x{30fc}\x{30c9}", 'Default' => '0', 'Null' => 'NO', 'Key' => 'PRI' }, { 'Extra' => '', 'Type' => 'char(30)', 'Field' => "\x{54c1}\x{540d}", 'Default' => undef, 'Null' => 'YES', 'Key' => '' }, { 'Extra' => 'on update CURRENT_TIMESTAMP', 'Type' => 'timestamp', 'Field' => 'UPD_TIME', 'Default' => 'CURRENT_TIMESTAMP', 'Null' => 'NO', 'Key' => '' }, { 'Extra' => '', 'Type' => 'decimal(9,0)', 'Field' => "\x{4e0a}\x{4ee3}", 'Default' => undef, 'Null' => 'NO', 'Key' => '' }, { 'Extra' => '', 'Type' => 'decimal(9,0)', 'Field' => "\x{539f}\x{4fa1}", 'Default' => undef, 'Null' => 'NO', 'Key' => '' }, { 'Extra' => '', 'Type' => 'char(2)', 'Field' => "\x{5546}\x{54c1}\x{533a}\x{5206}", 'Default' => undef, 'Null' => 'NO', 'Key' => '' }, { 'Extra' => '', 'Type' => 'char(4)', 'Field' => "\x{5927}\x{5206}\x{985e}", 'Default' => undef, 'Null' => 'NO', 'Key' => '' }, { 'Extra' => '', 'Type' => 'char(4)', 'Field' => "\x{4e2d}\x{5206}\x{985e}", 'Default' => undef, 'Null' => 'NO', 'Key' => '' }, { 'Extra' => '', 'Type' => 'char(4)', 'Field' => "\x{5c0f}\x{5206}\x{985e}", 'Default' => undef, 'Null' => 'NO', 'Key' => '' } ]; !ubuntu 16.04 ¥¢¥Ã¥×¥°¥ì¡¼¥É¤Ë¤Æmysql¤Ç¥¨¥é¡¼ my.cnf¤òbackup&remove¤·¤Æ¥¯¥ê¡¼¥ó¥¤¥ó¥¹¥È¡¼¥ë¤¹¤ì¤ÐÎɤ¤¡£ http://askubuntu.com/questions/760724/16-04-upgrade-broke-mysql-server ¤è¤ê The instructions @andrew-beerman posted are on the right track, though they aren't quite clear to me and seem to recommend more than is necessary. I pieced together the answer from the above and a helpful post in the bug thread. These are the steps I took to correct this: *Back up your my.cnf file in /etc/mysql and remove it *Remove the folder /etc/mysql/mysql.conf.d/ *Verify you don't have a my.cnf file stashed somewhere else (I did in my home dir!) or in /etc/alternatives/my.cnf. *Backup and remove /etc/mysql/debian.cnf files (not sure if needed, but just in case) sudo apt purge mysql-server mysql-server-5.7 mysql-server-core-5.7 sudo apt install mysql-server *In case your syslog shows an error like "mysqld: Can't read dir of '/etc/mysql/conf.d/'" create a symbolic link ln -s /etc/mysql/mysql.conf.d /etc/mysql/conf.d Then the service should be able to start with service mysql start. !memo http://d.hatena.ne.jp/sugyan/touch/20100901/1283267925 http://www.wysiwyg.jp/imr/GDvsIM.htm http://imager.perl.org/docs/Imager/Install.html http://cpanmag.koneta.org/012-imager/ !Á´¥Æ¡¼¥Ö¥ë¤Î¥ì¥³¡¼¥É¿ô¤ò¼èÆÀ *oracle [¤Í¤â¤×¤é¤¹|http://nemoplus.hateblo.jp/entry/20090202/1233579652]¤è¤ê SELECT table_name, TO_NUMBER( EXTRACTVALUE( xmltype( dbms_xmlgen.getxml('SELECT COUNT(*) AS C FROM '||table_name) ), '/ROWSET/ROW/C' ) ) AS count FROM user_tables; !²èÁü¤ò¥Õ¥ê¥Ã¥¯¤·¤Æ²èÁü¤òÀÚ¤êÂؤ¨¤ë [¥µ¥ó¥×¥ë|http://www21051ue.sakura.ne.jp/album/album/album.cgi?_name=hayabusareturn_01.jpg]¤ò¥¢¥ë¥Ð¥à¤Çºî¤Ã¤Æ¤ß¤¿ !EXCEL¤ÇF2,[ENTER]¤ÎÏ¢ÂǤ¬¤á¤ó¤É¤¯¤µ¤¤ EXCEL¤Ç¥»¥ë¤Ë·×»»¼°¤¬Æþ¤Ã¤Æ¤¤¤ë¤Î¤ËºÆ·×»»¤·¤Æ¤¯¤ì¤Ê¤¤»þ¤¬¤¢¤ê¤Þ¤¹¡£ ¤½¤ó¤Ê»þ¤ÏF2¤ÇÊÔ½¸¥â¡¼¥É¤Ë¤·¤Æ[ENTER]¤òÆþÎϤ¹¤ì¤ÐºÆ·×»»¤·¤Æ¤¯¤ì¤Þ¤¹¡£ ¤¬¡¢¤½¤ì¤¬²¿½½¹Ô¡¢²¿É´¹Ô¤âÏ¢ÂǤ·¤Ê¤±¤ì¤Ê¤é¤Ê¤¤¤È»þ¤â¤¢¤ê¡¢µ¤ÎϤ¬ ³¤­¤Þ¤»¤ó¡£¡ÊÌÛ¡¹¤ÈÏ¢ÂǤǤ­¤ëƱν¤â¤¤¤ë¤¬¡Ä¡Ë¤½¤ó¤Ê»þ¤Ï¡¢ÃÖ¤­´¹¤¨¤Ç=¤ò=¤Ë Á´¤ÆÃÖ¤­´¹¤¨¤ì¤ÐºÆ·×»»¤·¤Æ¤¯¤ì¤Þ¤¹¡£ *¼ê½ç **ctrl+H¤ÇÃÖ¤­´¹¤¨¤Î¥¦¥¤¥ó¥É¤ò³«¤¯ **ÃÖ¤­´¹¤¨Á°¤Îʸ»ú¤Ë'='¤òÆþÎÏ **ÃÖ¤­´¹¤¨¸å¤Îʸ»ú¤Ë'='¤òÆþÎÏ **Á´¤ÆÃÖ¤­´¹¤¨¥Ü¥¿¥ó¤ò¥¯¥ê¥Ã¥¯ **°Ê¾å ¢¨¶èÀÚ¤ê°ÌÃ֤Ǥâ¤Ç¤­¤ë¤é¤·¤¤ !keyCode¤ò¼è¤ê¹þ¤à [¥µ¥ó¥×¥ë|http://togawa.qee.jp/keyCode.html]¤òºî¤Ã¤Æ¤ß¤¿
!JQuery 1ÈÖ²¼¤Ë¥¹¥¯¥í¡¼¥ë¤¹¤ë [2014/4/14] JQuery¤Çtextarea¤Î1ÈÖ²¼¤Ë¥¹¥¯¥í¡¼¥ë¤¹¤ë // £±ÈÖ²¼¤Ë¥¹¥¯¥í¡¼¥ë¤¹¤ë -- START var go_bottom = function(targetId){ var $obj = $("#" + targetId); if ($obj.length == 0) return; $obj.scrollTop($obj[0].scrollHeight); }; // £±ÈÖ²¼¤Ë¥¹¥¯¥í¡¼¥ë¤¹¤ë -- END !html5 mp4 mp4¤òweb¤ËËä¤á¹þ¤à