約 182,066 件
https://w.atwiki.jp/nobotaka/pages/20.html
http //www.doppo1.net/oracle/tuning/explain-plan.html sqlplus noboru01/noboru01 select * from tbl01 where id1 00001322 ; column sql_text format a50 SELECT ADDRESS,HASH_VALUE,SQL_TEXT FROM V$SQL WHERE SQL_TEXT LIKE select% from tbl% ; column operation format a30 column object_name format a20 SELECT A.ID, LPAD( ,2*(DEPTH-1)) || A.OPERATION || nvl2(OPTIMIZER, ( || OPTIMIZER || ) ,NULL) || nvl2(A.OPTIONS, || A.OPTIONS ,NULL) OPERATION, A.OBJECT_NAME,A.BYTES,A.COST,A.CPU_COST,A.IO_COST,A.CARDINALITY FROM V$SQL_PLAN A WHERE A.ADDRESS= 25ECB24C AND A.HASH_VALUE= 2518582849 AND A.CHILD_NUMBER=0 ORDER BY ID;
https://w.atwiki.jp/kenichiro/pages/38.html
MySQLはフリーのデータベースソフト。 インストールは yum install mysql-server MySQL起動と停止の仕方、管理者になって 起動 /etc/rc.d/init.d/mysqld start 停止 /etc/rc.d/init.d/mysqld stop
https://w.atwiki.jp/ce00582/pages/2245.html
?php require("calldata.php"); $sql = "SELECT * FROM eli06"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $matrix[$n][4] =$row[3]; $matrix[$n][5] =$row[4]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $year =$matrix[$n][1]; $age =$matrix[$n][2]; $mrou[$year][$age] = $matrix[$n][3]; $wrou[$year][$age] = $matrix[$n][4]; $drou[$year][$age] = $matrix[$n][5]; } $sql = "SELECT * FROM eli69"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $matrix[$n][4] =$row[3]; $matrix[$n][5] =$row[4]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $year =$matrix[$n][1]; $age =$matrix[$n][2]; $mr[$year][$age] = $matrix[$n][3]; $wr[$year][$age] = $matrix[$n][4]; $dr[$year][$age] = $matrix[$n][5]; } for ($year=8;$year 100;$year++){ for ($age=15;$age 70;$age++){ $ms[$year][$age]=$mr[$year][$age]*$mrou[$year][$age]; $ws[$year][$age]=$wr[$year][$age]*$wrou[$year][$age]; $ds[$year][$age]=$dr[$year][$age]*$drou[$year][$age]; } } $sql = "truncate eli71"; $exe= mysql_query($sql,$link); for ($year=8;$year 100;$year++){ for ($age=15;$age 70;$age++){ $x=$ms[$year][$age]; $y=$ws[$year][$age]; $z=$ds[$year][$age]; $sql = "insert into eli71 values($year,$age,$x,$y,$z)"; $exe= mysql_query($sql,$link); } } $close_flag = mysql_close($link); print("71 就業者 計算終了"); ?
https://w.atwiki.jp/eroscape_bibouroku/pages/83.html
SQLで使うJSとかの置き場 ファイル一覧編集 SQL用テーブルソートJS tablesort.js 編集 文字列URLエスケープ用JS ecl.js 編集 Sleipnir用ユーザーあぼーんスクリプト ESあぼーん 編集 jsをsql埋込み用に加工するVBS js2es_sql.vbs 編集
https://w.atwiki.jp/ce00582/pages/3023.html
?php require("calldata.php"); $sql = "SELECT * FROM ben71"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $matrix[$n][4] =$row[3]; $matrix[$n][5] =$row[4]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $year =$matrix[$n][1]; $age =$matrix[$n][2]; $ms[$year][$age] = $matrix[$n][3]; $ws[$year][$age] = $matrix[$n][4]; $ds[$year][$age] = $matrix[$n][5]; } $sql = "SELECT * FROM data70"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $x70[$n] = $matrix[$n][1]; } for ($age=15;$age 70;$age++){ $n=3*(floor($age/5)-3)+1; $mr[$age]=$x70[$n]; $wr[$age]=$x70[$n+1]; $dr[$age]=$x70[$n+2]; } For ($year=5;$year 30;$year++){ $a1 =20 + 10 *($year - 5)/ 25; $rate[$year] = 0.01 * $a1 / 20; } For ($year=30;$year 100;$year++){ $a1 = 30; $rate[$year] = 0.01 * $a1 / 20; } for ($year=8;$year 100;$year++){ for ($age=15;$age 70;$age++){ $mal[$year][$age]=$rate[$year]*$mr[$age]*$ms[$year][$age]; $wal[$year][$age]=$rate[$year]*$wr[$age]*$ws[$year][$age]; $dal[$year][$age]=$rate[$year]*$dr[$age]*$ds[$year][$age]; } } $sql = "truncate ben70"; $exe= mysql_query($sql,$link); for ($year=8;$year 100;$year++){ for ($age=15;$age 70;$age++){ $x=$mal[$year][$age]; $y=$wal[$year][$age]+$dal[$year][$age]; $sql = "insert into ben70 values($year,$age,$x,$y)"; $exe= mysql_query($sql,$link); } } $close_flag = mysql_close($link); print("70 アルバイト 計算終了"); ?
https://w.atwiki.jp/ce00582/pages/439.html
?php require("calldata.php"); $sql = "SELECT * FROM pgdata05"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $matrix[$n][4] =$row[3]; $n=$n+1; } for ($n=1; $n 5501; $n++) { $year =$matrix[$n][1]; $age =$matrix[$n][2]; $m2[$year][$age] = $matrix[$n][3]; $f2[$year][$age] = $matrix[$n][4]; } $sql = "SELECT * FROM pdata12"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $matrix[$n][4] =$row[3]; $n=$n+1; } for ($n=1; $n 56; $n++) { $age =$matrix[$n][1]; $gamma[$age] = $matrix[$n][2]; $alpha[$age] = $matrix[$n][3]; $beta[$age] = $matrix[$n][4]; } $sql = "SELECT * FROM pdata11"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $n=$n+1; } for ($n=1; $n 46; $n++) { $age =$matrix[$n][1]; $theta[$age] = $matrix[$n][3]; } $sql = "SELECT * FROM pdata15"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $n=$n+1; } for ($n=1; $n 2201; $n++) { $age =$matrix[$n][1]; $car = $matrix[$n][2]; $startmis[$age][$car]= $matrix[$n][3]; } $sql = "SELECT * FROM pdata16"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $n=$n+1; } for ($n=1; $n 2201; $n++) { $age =$matrix[$n][1]; $car = $matrix[$n][2]; $startmos[$age][$car]= $matrix[$n][3]; } For ($year = 5;$year 100;$year++){ For ($age = 15;$age 69;$age++){ $byear=$year-$age+2000; $m2by[$byear][$age]=$f2[$year][$age]; } } For ($byear = 1941;$byear 1990;$byear++){ $startage =2005-$byear; For ($car=1;$car 50;$car++){ $mis[$byear][$startage][$car] = $startmis[$startage][$car]; $mos[$byear][$startage][$car] = $startmos[$startage][$car]; } For ($age = $startage+1;$age 65;$age++){ $z1 = (1-$gamma[$age-1]) * $m2by[$byear][$age-1]; $z2 = $m2by[$byear] [$age] - $z1; If ($z2 0) { $z2 = 0; } $z3=(1-$theta[$age])*$z2; $z4 = $theta[$age]*$z2; $mis[$byear][$age][1]=$z3; $z5 = 0; For ($car=1;$car 50;$car++){ $z5 = $z5 + $mos[$byear][$age-1][$car]; } If ($z5 == 0){ $z5 = 1; } $v = $z4 / $z5; If ($v 1){ $v = 1; } For ($car=2;$car 50;$car++){ $mis[$byear][$age][$car] = (1-$gamma[$age-1]) * $mis[$byear][$age-1][$car-1] + $v * $mos[$byear][$age-1][$car-1]; } For ($car=1;$car 50;$car++){ $mos[$byear][$age][$car] = ($gamma[$age-1] - $alpha[$age-1] - $beta[$age-1]) * $mis[$byear][$age-1][$car] + (1- $v) * $mos[$byear][$age-1][$car]; } } $z1 = 0; For ($car=25;$car 50;$car++){ $z1 = $z1 + $mis[$byear][64][$car]+$mos[$byear][64][$car]; } $mnew[$byear] = $z1; } $sql = "truncate pgdata13"; $exe= mysql_query($sql,$link); for ($byear=1941;$byear 1990;$byear++){ $x=$mnew[$byear]; $sql = "insert into pgdata13 values($byear,$x)"; $exe= mysql_query($sql,$link); } $close_flag = mysql_close($link); ?
https://w.atwiki.jp/ce00582/pages/2246.html
?php require("calldata.php"); $sql = "SELECT * FROM eli71"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $matrix[$n][4] =$row[3]; $matrix[$n][5] =$row[4]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $year =$matrix[$n][1]; $age =$matrix[$n][2]; $ms[$year][$age] = $matrix[$n][3]; $ws[$year][$age] = $matrix[$n][4]; $ds[$year][$age] = $matrix[$n][5]; } $sql = "SELECT * FROM eli70"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $matrix[$n][4] =$row[3]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $year =$matrix[$n][1]; $age =$matrix[$n][2]; $mal[$year][$age] = $matrix[$n][3]; $fal[$year][$age] = $matrix[$n][4]; } for ($year=8;$year 100;$year++){ for ($age=15;$age 70;$age++){ $mh[$year][$age]=0.95*($ms[$year][$age]-$mal[$year][$age])+0.2*$mal[$year][$age]; $fh[$year][$age]=0.95*($ws[$year][$age]+$ds[$year][$age]-$fal[$year][$age])+0.2*$fal[$year][$age]; } } $sql = "truncate eli08"; $exe= mysql_query($sql,$link); for ($year=8;$year 100;$year++){ for ($age=15;$age 70;$age++){ $x=$mh[$year][$age]; $y=$fh[$year][$age]; $sql = "insert into eli08 values($year,$age,$x,$y)"; $exe= mysql_query($sql,$link); } } $close_flag = mysql_close($link); ?
https://w.atwiki.jp/ce00582/pages/2239.html
?php require("calldata.php"); $sql = "SELECT * FROM eli16"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $matrix[$n][4] =$row[3]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $byear =$matrix[$n][1]; $age =$matrix[$n][2]; $m2by[$byear][$age] = $matrix[$n][3]; $f2by[$byear][$age] = $matrix[$n][4]; } $sql = "SELECT * FROM data18"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $matrix[$n][4] =$row[3]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $age =$matrix[$n][1]; $gamma[$age] = $matrix[$n][2]; $alpha[$age] = $matrix[$n][3]; $beta[$age] = $matrix[$n][4]; } $sql = "SELECT * FROM data152"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $age =$matrix[$n][1]; $theta[$age] = $matrix[$n][3]; } $sql = "SELECT * FROM eli20"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $age =$matrix[$n][1]; $car = $matrix[$n][2]; $fint[$age][$car]= $matrix[$n][3]; } $sql = "SELECT * FROM eli22"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $age =$matrix[$n][1]; $car = $matrix[$n][2]; $fout[$age][$car]= $matrix[$n][3]; } For ($byear = 1950;$byear 1990;$byear++){ $stage =2008-$byear; For ($car=1;$car 50;$car++){ $fis[$stage][$car] = $fint[$stage][$car]; $fos[$stage][$car] = $fout[$stage][$car]; } For ($age = $stage+1;$age 65;$age++){ $z1=(1-$gamma[$age-1]) * $f2by[$byear][$age-1]; $z2=$f2by[$byear][$age] - $z1; If($z2 0)$z2 = 0; $z3=(1-$theta[$age])*$z2; $z4=$theta[$age]*$z2; $fis[$age][1]=$z3; $z5=0; For ($car=1;$car 50;$car++){ $z5=$z5+$fos[$age-1][$car]; } If($z5==0)$z5=100; $v[$age]=$z4/$z5; If($v[$age] 1)$v[$age] = 1; For ($car=2;$car 50;$car++){ $fis[$age][$car]=(1-$gamma[$age-1])*$fis[$age-1][$car-1]+$v[$age]*$fos[$age-1][$car-1]; } For ($car=1;$car 50;$car++){ $fos[$age][$car] = ($gamma[$age-1] - $alpha[$age-1] - $beta[$age-1]) * $fis[$age-1][$car] + (1- $v[$age]) * $fos[$age-1][$car]; } } $z6=0; For ($car=25;$car 50;$car++){ $z6=$z6+$fis[64][$car]+$fos[64][$car]; } $fnew[$byear] = $z6; } $sql = "truncate eli24"; $exe= mysql_query($sql,$link); for ($byear=1950;$byear 1990;$byear++){ $x=$fnew[$byear]; $sql = "insert into eli24 values($byear,$x)"; $exe= mysql_query($sql,$link); } $close_flag = mysql_close($link); print("24 女子新規裁定者2 計算終了"); ?
https://w.atwiki.jp/centos-home/pages/35.html
postgresqlインストール postgres(OS)アカウント作成 # /usr/sbin/useradd postgres # /usr/bin/passwd postgres コンパイルに必要なツール gzip/bzip2 GNU make 3.76.1〜 gcc 2.72〜 Flex 2.54〜 Bison 1.875〜 GNU Readlineライブラリ(# yum install readline-devel) GNU zlibライブラリ(# yum install zlib-devel) ソースの展開とインストール(1) 圧縮されたPostgreSQLのソースをpostgresユーザで/usr/local/srcに解凍 /usr/local/src/postgresql-8.4 インストールするディレクトリ /usr/local/pgsql 上のディレクトリの所有権限をpostgresに変更 ソースの展開とインストール(2) postgresユーザになってconfigure $ ./configure 無事makefileができたら $ make all makeのチェックをするために(リグレッションテスト) $ make check 「All 120 tests passed.」と表示されれば完了 ソースの展開とインストール(3) $ make install このページを編集
https://w.atwiki.jp/ce00582/pages/2247.html
?php require("calldata.php"); $sql = "SELECT * FROM eli04"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $matrix[$n][4] =$row[3]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $year =$matrix[$n][1]; $age =$matrix[$n][2]; $m[$year][$age] = $matrix[$n][3]; $f[$year][$age] = $matrix[$n][4]; } for ($year=10;$year 100;$year++){ $ch=1; if ($year 50)$ch = 1.05 - 0.05 * ($year - 10) / 40; for ($age=65;$age 100;$age++){ $kiso[$year][$age]=($m[$year][$age]+$f[$year][$age])/$ch; } } $sql = "truncate eli47"; $exe= mysql_query($sql,$link); for ($year=10;$year 100;$year++){ for ($age=65;$age 100;$age++){ $x=$kiso[$year][$age]; $sql = "insert into eli47 values($year,$age,$x)"; $exe= mysql_query($sql,$link); } } $close_flag = mysql_close($link); print("47 基礎年金受給者 計算終了") ?