!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¤ËËä¤á¹þ¤à¥¿¥°
!ePOS-Device API
*[ePOS-Device API¤È¤Ï|https://www.google.com/search?q=%E7%84%A1%E7%B2%BE%E3%83%BB%E7%9F%AD%E6%B0%97%E3%83%BB%E5%82%B2%E6%85%A2#q=ePOS-Device+API]¤Ê¤Ë¡©googleÀèÀ¸¤ª¤·¤¨¤Æ¡ª
*[Web¥Ö¥é¥¦¥¶¡¼¤Ç¥ì¥·¡¼¥È¥×¥ê¥ó¥¿¡¼¤òÀ©¸æ¤¹¤ëÊý|http://www.epson.jp/products/sasport/other/ole_pos.htm]
*[ePOS-Print ¤È¤Ï²¿¤«¶µ¤¨¤Æ¤¯¤À¤µ¤¤¡£|http://faq.epson.jp/faq/01/app/servlet/qadoc?031390]
**ePOS-Print ¤È¤Ï¡¢¥³¥ó¥Ô¥å¡¼¥¿¡¼¡¢¥¹¥Þ¡¼¥È¥Õ¥©¥ó¤ä¥¿¥Ö¥ì¥Ã¥ÈüËö¤Ê¤É¤Î Web ¥Ö¥é¥¦¥¶¡¼¤«¤é¡¢¥¹¥Þ¡¼¥È¥ì¥·¡¼¥È¥×¥ê¥ó¥¿¡¼¤òÀ©¸æ¤¹¤ëµ¡Ç½¤Ç¤¹¡£
HTML5 Canvas ¤ÇÉÁ²è¤·¤¿°õºþ¥¤¥á¡¼¥¸¤ò°õºþ¤¹¤ë¤³¤È¤â¤Ç¤¤Þ¤¹¡£
!¥Æ¥¥¹¥È¤ò1ʸ»ú¤Å¤Äɽ¼¨
http://zxcvbnmnbvcxz.com/demonstration/txtspan1.php¤Ç¶µ¤¨¤Æ¤â¤é¤Ã¤¿¡£
µ¡Æ°Àï»Î¥¬¥ó¥À¥àseed¤Î[µ¯Æ°²èÌÌ|http://togawa.qee.jp/gundam.html]¤ß¤¿¤¤¤Î¤òºî¤Ã¤Æ¤ß¤¿¡£
G eneral
U nilateral
N euro - link
D ispersive
A utonomic
M aneuver
_______Synthesis System
¥Õ¥©¥ó¥È¤òMagicRing¤ËÊѹ¹¤¹¤ë¤È¥¬¥ó¥À¥à¤òư¤«¤¹[ËâË¡¤Î¼öʸ|http://togawa.qee.jp/gundam_magic.html]¤Î¤è¤¦¤Ë¸«¤¨¤ë¡£
--- gundam.html ¿å 4 23 11:06:23 2014
+++ gundam_magic.html ²Ð 4 22 23:22:00 2014
@@ -9,16 +9,23 @@