記録 の変更点 - PukiWiki

#contents
* 溝口研究室の備忘録 [#e47f9590]
** 2010年度メンバー [#e09df884]
// #query("select 'DC' as `学年`, meibo.`氏名` as `氏名`, docter.`内容` as `内容` from docter, meibo where docter.`名簿ID`=meibo.ID and docter.`年度`=2008 union select 'M2' as `学年`, meibo.`氏名` as `氏名`, master2.`論文名` as `内容` from master2, meibo where master2.`名簿ID`=meibo.ID and master2.`年度`=2008 union select 'M1' as `学年`, meibo.`氏名` as `氏名`, master1.`内容` as `内容` from master1, meibo where master1.`名簿ID`=meibo.ID and master1.`年度`=2008 union select 'B4' as `学年`, meibo.`氏名` as `氏名`, zemi4.`内容` as `内容` from zemi4, meibo where zemi4.`名簿ID`=meibo.ID and zemi4.`年度`=2008 union select 'B3' as `学年`, meibo.`氏名` as `氏名`, zemi3.`内容` as `内容` from zemi3, meibo where zemi3.`名簿ID`=meibo.ID and zemi3.`年度`=2008");

#query("select 'DC' as `学年`, meibo.`イニシャル` as `YM`, docter.`内容` as `内容` from docter, meibo where docter.`名簿ID`=meibo.ID and docter.`年度`>=2009 union select 'M2' as `学年`, meibo.`イニシャル` as `YM`, master2.`論文名` as `内容` from master2, meibo where master2.`名簿ID`=meibo.ID and master2.`年度`=2010 union select 'M1' as `学年`, meibo.`イニシャル` as `YM`, master1.`内容` as `内容` from master1, meibo where master1.`名簿ID`=meibo.ID and master1.`年度`=2010 union select 'B4' as `学年`, meibo.`イニシャル` as `YM`, zemi4.`内容` as `内容` from zemi4, meibo where zemi4.`名簿ID`=meibo.ID and zemi4.`年度`=2010 union select 'B3' as `学年`, meibo.`イニシャル` as `YM`, zemi3.`内容` as `内容` from zemi3, meibo where zemi3.`名簿ID`=meibo.ID and zemi3.`年度`=2010");
#query("select 'DC' as `学年`, meibo.`イニシャル` as `YM`, docter.`内容` as `内容` from docter, meibo where docter.`名簿ID`=meibo.ID and docter.`年度`>=2009 union select 'M2' as `学年`, meibo.`イニシャル` as `YM`, master2.`論文名` as `内容` from master2, meibo where master2.`名簿ID`=meibo.ID and master2.`年度`=2011 union select 'M1' as `学年`, meibo.`イニシャル` as `YM`, master1.`内容` as `内容` from master1, meibo where master1.`名簿ID`=meibo.ID and master1.`年度`=2011 union select 'B4' as `学年`, meibo.`イニシャル` as `YM`, zemi4.`内容` as `内容` from zemi4, meibo where zemi4.`名簿ID`=meibo.ID and zemi4.`年度`=2011 union select 'B3' as `学年`, meibo.`イニシャル` as `YM`, zemi3.`内容` as `内容` from zemi3, meibo where zemi3.`名簿ID`=meibo.ID and zemi3.`年度`=2011");

** 九州大学・大学院数理学府・理学部数学科(2003年度~) [#w48cd87f]
*** ゼミで使用した参考書 [#ledc9141]
#query("select `書名`,`著者名`,`発行年` from textbook")
*** 3年ゼミ [#z33233c8]
// #query("select zemi3.`年度`, meibo.`氏名`, zemi3.`内容` from zemi3, meibo where zemi3.`名簿ID`=meibo.ID order by zemi3.`年度` desc, meibo.`よみ`")
#query("select zemi3.`年度`, meibo.`イニシャル` as `YM`, zemi3.`内容` from zemi3, meibo where zemi3.`名簿ID`=meibo.ID order by zemi3.`年度` desc, meibo.`よみ`")
*** 4年ゼミ [#b1db1d3c]
// #query("select zemi4.`年度`, meibo.`氏名`, zemi4.`内容` from zemi4, meibo where zemi4.`名簿ID`=meibo.ID order by zemi4.`年度` desc, meibo.`よみ`")
#query("select zemi4.`年度`, meibo.`イニシャル` as `YM`, zemi4.`内容` from zemi4, meibo where zemi4.`名簿ID`=meibo.ID order by zemi4.`年度` desc, meibo.`よみ`")
*** M1ゼミ [#y4bafefb]
// #query("select master1.`年度`, meibo.`氏名`, master1.`内容` from master1, meibo where master1.`名簿ID`=meibo.ID order by master1.`年度` desc, meibo.`よみ`")
#query("select master1.`年度`, meibo.`イニシャル` as `YM`, master1.`内容` from master1, meibo where master1.`名簿ID`=meibo.ID order by master1.`年度` desc, meibo.`よみ`")
*** 修士論文 [#b3b4cad9]
// #query("select master2.`年度`, meibo.`氏名`, master2.`論文名` from master2, meibo where master2.`名簿ID`=meibo.ID order by master2.`年度` desc, meibo.`よみ`")
#query("select master2.`年度`, meibo.`イニシャル` as `YM`, master2.`論文名` from master2, meibo where master2.`名簿ID`=meibo.ID order by master2.`年度` desc, meibo.`よみ`")
*** 博士課程 [#l3404018]
// #query("select docter.`年度`, meibo.`氏名`, docter.`内容` from docter, meibo where docter.`名簿ID`=meibo.ID order by docter.`年度` desc, meibo.`よみ`")
#query("select docter.`年度`, meibo.`イニシャル` as `YM`, docter.`内容` from docter, meibo where docter.`名簿ID`=meibo.ID order by docter.`年度` desc, meibo.`よみ`")

*** [[思い出]] (←ミニ写真集) [#e224ec07]
** 九州工業大学・情報工学部・制御システム工学科(1991年度~2000年度) [#jafa550d]
*** 修士論文 [#rc7dbd33]
// #query("select `年度`,`氏名`,`論文名` from kyutech where BM='M' order by `年度` desc")
#query("select `年度`,`論文名` from kyutech where BM='M' order by `年度` desc")
*** 卒業論文 [#u81224fd]
// #query("select `年度`,`氏名`,`論文名` from kyutech where BM='B' order by `年度` desc")
#query("select `年度`,`論文名` from kyutech where BM='B' order by `年度` desc")


#counter

トップ   編集 差分 バックアップ 添付 複製 名前変更 リロード   新規 一覧 単語検索 最終更新   ヘルプ   最終更新のRSSPDF