約 182,027 件
https://w.atwiki.jp/chacha/pages/62.html
sql文以外は一行ずついれたほうがいいかも エラーとかがあったらサブリーダーまで cd c \mysql\bin mysql -u root select host,user,password from mysql.user; ←やってもやらんでも、どっちでも可 set password for root@localhost=PASSWORD( root ); set password for root@build=PASSWORD( root ); exit; mysql -u root -p次回からrootで入るにはここと次の行の2つを入力する必要がある root create database noblog; use noblog; CREATE TABLE user ( userID VARCHAR(20) primary key, passwd VARCHAR(16) not null, mail VARCHAR(100)not null, himitu int(1), answer varchar(30), ninsyouKey VARCHAR(8), kariDay date ); create table profile ( userID varchar(20), name varchar(40), year varchar(4), month varchar(2), day varchar(2), job varchar(2), sex int(1), hobby varchar(200), hitokoto varchar(200), pic varchar(2), nameSecret int(1), barthSecret int(1), primary key(userID) ); create table job ( jobNo integer(2) auto_increment, jobName varchar(20), primary key (jobNo) ); create table categori ( categoriNo int(5) primary key, categoriName varchar(40) ); create table theme ( userID varchar(20), themeNo int(2), themeName varchar(40) ); create table kiji ( userID varchar(20), kijiNo int(5), themeNo int(2), kijiTitle varchar(100), text text, commentFlg int(1), trackflg int(1), writeDay date, writeTime time ); create table comment ( userid varchar(20), kijiNo int(5), commentNo int(3), commWriter varchar(100), commDate datetime ); create table blog ( userID varchar(20) primary key, bTitle varchar(100) not null, bSetumei varchar(200), cssNo int(3), categoriNo int(5), categoriRunk int(6), allRank int(7), commentFlg int(1), trackFlg int(1) ); create table trackback ( kijiNo int(5), trackNo int(3), trackTitle varchar(100), bTitle varchar(100), bUul varchar(100), trackText varchar(200), trackDate datetime ); create table ranking ( userID varchar(20) primary key, one int(5), two int(5), three int(5), four int(5), five int(5), six int(5), seven int(5), weekTotal int(7), allTotal int(8) ); create table design ( desNo int(2) primary key auto_increment, css text ); create table picture ( userID varchar(20) primary key, picNo int(2), pic longblob, thumbnail varchar(50) ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 1001 , ダイエット ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 1002, 健康法 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 1003, 美容・コスメ ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 1004, 出産・育児 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 1005, 仕事 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 1006, 恋愛 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 1007, 就職活動 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 1008, その他 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 2001, 社会 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 2002, 政治 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 2003, 芸能 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 2004, その他 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 3001, 野球 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 3002, サッカー ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 3003, その他 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 4001, パチンコ・スロット ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 4002, 競馬 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 4003, その他 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 5001, 本・雑誌 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 5002, 音楽 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 5003, 料理 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 5004, グルメ ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 5005, 旅行 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 5006, 小説・詩 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 5007, 車・バイク ) ; INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 5008, ショッピング ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 5009, ゲーム ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 5010, ペット ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 5011, コレクション ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 5012, ファッション ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 5013, おもちゃ ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 5014, その他 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 6001, 俳優・タレント・アイドル ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 6002, 漫画・アニメ ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 6003, お笑い ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 6004, バラエティ ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 6005, 映画 ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 6006, ドラマ ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 6007, テレビ ); INSERT INTO categori ( categoriNo , categoriName ) VALUES ( 6008, その他 );
https://w.atwiki.jp/javadsge/pages/7883.html
function f(){ n2="猫はp"; c2=74398; ch=check("1PUZaaZerSKucbSxSK-KFImnLKlUmsgvEHrU5kJaH",n2); Logger.log(ch); if(ch 1){ finsert("1PUZaaZerSKucbSxSK-KFImnLKlUmsgvEHrU5kJaH",n2,c2); } } function check(id,n1) { var sql = SELECT * FROM +id; sql =sql+ " WHERE artist= "+n1+" "; var result = FusionTables.Query.sqlGet(sql, {hdrs false}); var r=result.rows; sx=0; for(var i in r){ sx=sx+1; } return sx; } function finsert(id,n1,c1) { var sql = "INSERT INTO "+id+ "(artist,code) VALUES ( "+n1+" ,"+c1+")"; var res = FusionTables.Query.sql(sql); }
https://w.atwiki.jp/ce00582/pages/2343.html
?php require("calldata.php"); $sql = "SELECT * FROM data384"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][4] =$row[3]; $matrix[$n][5] =$row[4]; $matrix[$n][8] =$row[7]; $matrix[$n][9] =$row[8]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $age =$matrix[$n][1]; $c1[$age] =$matrix[$n][4]; $c2[$age] =$matrix[$n][5]; $c3[$age] =$matrix[$n][8]; $c4[$age] =$matrix[$n][9]; } $sql = "SELECT * FROM data79"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][4] =$row[3]; $matrix[$n][5] =$row[4]; $matrix[$n][8] =$row[7]; $matrix[$n][9] =$row[8]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $age =$matrix[$n][1]; $b1[$age] =$matrix[$n][4]; $b2[$age] =$matrix[$n][5]; $b3[$age] =$matrix[$n][8]; $b4[$age] =$matrix[$n][9]; } $z1=0.0001; $z2= 0; for ($byear=1910;$byear 1950;$byear++){ $age = 2008 - $byear; $z1 = $z1+$c1[$age] + $c2[$age] + $c3[$age] + $c4[$age]; $z2 = $z2+$b1[$age] + $b2[$age] + $b3[$age] + $b4[$age]; $ftime[$byear] = $z2 /$z1; } $sql = "truncate eli81"; $exe= mysql_query($sql,$link); for ($byear=1910;$byear 1950;$byear++){ $x=$ftime[$byear]; $sql = "insert into eli81 values($byear,$x)"; $exe= mysql_query($sql,$link); } $close_flag = mysql_close($link); print("81 女子通算加入年数3 計算終了"); ?
https://w.atwiki.jp/ce00582/pages/2344.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]; } $sql = "SELECT * FROM data386"; $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 116; $n++) { $age =$matrix[$n][1]; $f2rate[$age]=$matrix[$n][2]; } For ($byear = 1950;$byear 1990;$byear++){ For ($car=1;$car 50;$car++){ $fis[$stage][$car] = $fint[$stage][$car]; $fos[$stage][$car] = $fout[$stage][$car]; } $stage =2008-$byear; For ($car=1;$car 50;$car++){ $fis[$stage][$car] = $mint[$stage][$car]; $fos[$stage][$car] = $mout[$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]; } } for ($age=15;$age 65;$age++){ $z6 = 0; for ($car=1;$car 25;$car++){ $z6 =$z6+$f2rate[$age]*$alpha[$age]*$fis[$age][$car]; } for ($car=25;$car 50;$car++){ $z6 =$z6+$f2rate[$age]*$alpha[$age]*($fis[$age][$car]+$fos[$age][$car]); } $fnew[$byear][$age] = $z6; } } $sql = "truncate eli96"; $exe= mysql_query($sql,$link); for ($byear=1950;$byear 1990;$byear++){ for ($age=15;$age 65;$age++){ $x=$fnew[$byear][$age]; $sql = "insert into eli96 values($byear,$age,$x)"; $exe= mysql_query($sql,$link); } } $close_flag = mysql_close($link); print("96 女子現役遺族新規裁定者2 計算終了"); ?
https://w.atwiki.jp/ohden/pages/788.html
セッションが勝手に切れる時間の設定 Oracle Database 11gR2 11.2.0.1 Windows Server 2008R2 SQLPlusを起動して... SQL SET LINESIZE 9999 SQL SET PAGESIZE 100 SQL SELECT * FROM DBA_PROFILES WHERE RESOURCE_NAME= IDLE_TIME ; DBA_PROFILES SQL SELECT PROFILE FROM DBA_USERS WHERE USERNAME= 【ユーザ名】 ; で、そのユーザのプロファイルが分かる。 デフォだと『DEFAULT』になるハズ。 DBA_USERS 更新日: 2016年03月17日 (木) 15時56分23秒 名前 コメント すべてのコメントを見る
https://w.atwiki.jp/yoshiumi41/pages/83.html
package ppp.dao; import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException; import ppp.exception.AppSQLException;import ppp.vo.CustomerVO; public class CustomerSelectDAO extends SelectNoTxDAOBase CustomerVO { private static final String SQL_BASE = "SELECT customer_id, company_name, address, telno, dept, customer_name, customer_kana, email, password FROM customer WHERE 1 = 1";private static final String SQL_ORDER_BY = " ORDER BY customer_id"; private static final String[] WHERE_PHRASE = {" AND customer_id = ?", " AND password = ?"}; public CustomerSelectDAO(Connection conn) {super(conn);} @Overrideprotected String makeSql(Object[] params) throws AppSQLException { if (params == null || params.length 2) {throw new AppSQLException("パラメータ数が不正です");} StringBuilder sb = new StringBuilder(SQL_BASE);System.out.println(sb.toString());for (int i = 0; i params.length; i++) {if (params[i] != null) {sb.append(WHERE_PHRASE[i]);System.out.println(sb.toString());}}sb.append(SQL_ORDER_BY); System.out.println(sb.toString());return sb.toString();} @Overrideprotected CustomerVO makeRowObject(ResultSet rs) throws SQLException {CustomerVO customer = new CustomerVO();customer.setCustomerId(rs.getString("customer_id"));customer.setCompanyName(rs.getString("company_name"));customer.setAddress(rs.getString("address"));customer.setTelno(rs.getString("telno"));customer.setDept(rs.getString("dept"));customer.setCustomerName(rs.getString("customer_name"));customer.setCustomerKana(rs.getString("customer_kana"));customer.setEmail(rs.getString("email"));customer.setPassword(rs.getString("password"));return customer;} public int getMaxId() throws AppSQLException {PreparedStatement stmt = null;ResultSet rs = null;int maxId = 0;try {String sql = "SELECT max(customer_id) FROM customer";stmt = conn.prepareStatement(sql);rs = stmt.executeQuery();while (rs.next()) {maxId = rs.getInt("max");}} catch (SQLException e) {throw new AppSQLException("データベースからの抽出依頼で障害が発生しました", e);} finally {try {if (rs != null) rs.close();} catch (SQLException e) {throw new AppSQLException("結果セットの解放に失敗しました", e);}try {if (stmt != null) stmt.close();} catch (SQLException e) {throw new AppSQLException("ステートメントの解放に失敗しました", e);}}return maxId;} }
https://w.atwiki.jp/ce00582/pages/2295.html
?php require("calldata.php"); $sql = "SELECT * FROM data383"; $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][6] =$row[5]; $matrix[$n][7] =$row[6]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $age =$matrix[$n][1]; $c1[$age] =$matrix[$n][2]; $c2[$age] =$matrix[$n][3]; $c3[$age] =$matrix[$n][6]; $c4[$age] =$matrix[$n][7]; } $sql = "SELECT * FROM data78"; $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][6] =$row[5]; $matrix[$n][7] =$row[6]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $age =$matrix[$n][1]; $b1[$age] =$matrix[$n][2]; $b2[$age] =$matrix[$n][3]; $b3[$age] =$matrix[$n][6]; $b4[$age] =$matrix[$n][7]; } $z1= 0; $z2= 0; for ($byear=1910;$byear 1948;$byear++){ $age = 2008 - $byear; $z1 = $c1[$age] + $c2[$age] + $c3[$age] + $c4[$age]; $z2 = $b1[$age] + $b2[$age] + $b3[$age] + $b4[$age]; $mtime[$byear] = $z2 /$z1; } $sql = "truncate eli78"; $exe= mysql_query($sql,$link); for ($byear=1910;$byear 1948;$byear++){ $x=$mtime[$byear]; $sql = "insert into eli78 values($byear,$x)"; $exe= mysql_query($sql,$link); } $close_flag = mysql_close($link); print("78 男子平均3 計算終了"); ?
https://w.atwiki.jp/ce00582/pages/2313.html
?php require("calldata.php"); $sql = "SELECT * FROM data383"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][4] =$row[3]; $matrix[$n][5] =$row[4]; $matrix[$n][8] =$row[7]; $matrix[$n][9] =$row[8]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $age =$matrix[$n][1]; $c1[$age] =$matrix[$n][4]; $c2[$age] =$matrix[$n][5]; $c3[$age] =$matrix[$n][8]; $c4[$age] =$matrix[$n][9]; } $sql = "SELECT * FROM data78"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][4] =$row[3]; $matrix[$n][5] =$row[4]; $matrix[$n][8] =$row[7]; $matrix[$n][9] =$row[8]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $age =$matrix[$n][1]; $b1[$age] =$matrix[$n][4]; $b2[$age] =$matrix[$n][5]; $b3[$age] =$matrix[$n][8]; $b4[$age] =$matrix[$n][9]; } $z1= 0; $z2= 0; for ($byear=1910;$byear 1950;$byear++){ $age = 2008 - $byear; $z1 = $c1[$age] + $c2[$age] + $c3[$age] + $c4[$age]; $z2 = $b1[$age] + $b2[$age] + $b3[$age] + $b4[$age]; $mtime[$byear] = $z2 /$z1; } $sql = "truncate eli80"; $exe= mysql_query($sql,$link); for ($byear=1910;$byear 1950;$byear++){ $x=$mtime[$byear]; $sql = "insert into eli80 values($byear,$x)"; $exe= mysql_query($sql,$link); } $close_flag = mysql_close($link); print("80 男子通算加入年数3 計算終了"); ?
https://w.atwiki.jp/ce00582/pages/2312.html
?php require("calldata.php"); $sql = "SELECT * FROM data384"; $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][6] =$row[5]; $matrix[$n][7] =$row[6]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $age =$matrix[$n][1]; $c1[$age] =$matrix[$n][2]; $c2[$age] =$matrix[$n][3]; $c3[$age] =$matrix[$n][6]; $c4[$age] =$matrix[$n][7]; } $sql = "SELECT * FROM data79"; $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][6] =$row[5]; $matrix[$n][7] =$row[6]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $age =$matrix[$n][1]; $b1[$age] =$matrix[$n][2]; $b2[$age] =$matrix[$n][3]; $b3[$age] =$matrix[$n][6]; $b4[$age] =$matrix[$n][7]; } $z1= 0; $z2= 0; for ($byear=1910;$byear 1950;$byear++){ $age = 2008 - $byear; $z1 = $c1[$age] + $c2[$age] + $c3[$age] + $c4[$age]; $z2 = $b1[$age] + $b2[$age] + $b3[$age] + $b4[$age]; $ftime[$byear] = $z2 /$z1; } $sql = "truncate eli79"; $exe= mysql_query($sql,$link); for ($byear=1910;$byear 1950;$byear++){ $x=$ftime[$byear]; $sql = "insert into eli79 values($byear,$x)"; $exe= mysql_query($sql,$link); } $close_flag = mysql_close($link); print("79 女子平均加入年数3 計算終了"); ?
https://w.atwiki.jp/worknote3656/pages/15.html
■AWRスナップショットの手動取得 BEGIN EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); END; / ■AWRレポート作成 @?/rdbms/admin/awrrpt ■local_listenerのお話 初期パラ[local_listener]はinstance起動の度に設定されます。 - 但し、手動設定してしまった場合(alter system set ----)は自動設定されない ■稼動しているsessionの確認方法 select sid,serial#,username, to_char(logon_time, MM/DD HH24 MI SS ) from v$session order by to_char(logon_time, MM/DD HH24 MI SS ); ■特定sessionのSQLトレース取得 - trace取得開始 SQL EXECUTE dbms_system.set_sql_trace_in_session( sid , serial# , TRUE); - trace取得終了 SQL EXECUTE dbms_system.set_sql_trace_in_session( sid , serial# , FALSE); ★「USER_DUMP_DEST」下にtrcが吐かれる