作者查詢 / kattte

總覽項目：發文 | 留言 | 暱稱

作者 kattte 在 PTT [ Database ] 看板的留言(推文), 共16則

限定看板：Database

看板排序：

全部Gossiping11933NBA5960Hate2052WomenTalk1809NBA_Film1744WOW1374Celtics1157ask1056ONE_PIECE945Hunter809humanity804Chan_Mou700movie667STREET_BALL651basketball629WarCraft599Suckcomic531NARUTO527Boy-Girl523FAIRYTAIL452Soft_Job390joke370Old-Games326RayAllen313Yunlin288TW_Entertain224JinYong223PttLifeLaw213BLEACH190BASKET-RULES170NHU_Talk163NBAEasyChat154basketballTW138Leo131Chiayi119kekkai111Taoyuan109Web_Design106FuMouDiscuss101Aries95SlamDunk93PHP87Koei85dog80Militarylife77C_and_CPP76CATCH74PlayStation70Mind68sex68StupidClown66Stock62criminology53Hearthstone53KenAkamatsu51LeBronJames50Little-Games50LoL49car46OgreBattle46Beauty44Math42ArakawaCow40Examination39OverWatch39FITNESS38Gantz38Programming37handsomechef35H-GAME29NHU_CSIE29Salary29Doctor-Info28C_Sharp25Garena25marriage25Hawks24Ajax23Pisces22Diary21MIS21Teacher21MiamiHeat20Tech_Job20Dreamland19WarCraftChat17Database16Mavericks15Kings13Steam13Bucks12puzzle12C_Chat11CrossGate11Grizzlies11kotaro11Spurs11UTAH-JAZZ11Emulator10IVERSON10java10MH10AndroidDev9BLAZERS9MenTalk9KS98-3028Orl-Magic8Thunder8Azumanga7Facebook7Hornets7Nets7L_TalkandCha6Military6Network6Wizards6ChicagoBulls5CSSE5HatePolitics5Inference5KevinGarnett5Nuggets5PACERS5riddle5Wallpaper5Android4BabyMother4Baseball4CareerLady4feminine_sex4home-sale4InitialD4Jeremy_Lin4Knicks4KOF4LaClippers4Linux4Minecraft4MuscleBeach4pay_home4PingTung4rent-exp4specialman4T-mac4unemployed4VideoCard4DIABLO3Lakers3pet3worldbasket3YAO3BigBanciao2Cavaliers2China-Drama2ComeHere2comm_and_RF2CYCU_Talk2Eclipse2FJU-Laws992Haruhi2L_LifePlan2LAW2lineageW2NSwitch2NTNU-HISBK2NTU2Oversea_Job2Pistons2Ptt-Charity2RTS2Sagittarius2SENIORHIGH2StarCraft2StudyGroup2SuckcomicBM2Timberwolves2adulation1AfterPhD1ANIMAX1Army-Sir1biker1BlizzHeroes1Broken-heart1CareerPlan1Catholic1cksh80th3071CMU_BST011cosplay1CourtBasketB1CS_Basket1CSMU_MIR_BSK1CSonline1Dart1Design1Doraemon1eSports1Finance1FreeStyle1G-S-WARRIORS1GameDesign1GO1Golden-Award1HandMade1Hayate1HBL1HK_Comics1HoneyClover1HsinYi1HSNU_10081HWSH1job1junji-ITO1KanColle1Kaohsiung1kochikame1kodomo1L_LifeInfo1LawBasketbal1LTK1Marginalman1MobileComm1NANLIN3011NBA_Fantasy1NCAA1NDMC-M1061NFU1Nirvana1NoFear1Notebook1NTHUTL971NTPU-ACC-BA1NYUST1Odoko-juku1ONLINE1Oracles1PC_Shopping1Pelicans1Pet_Get1PHX-Suns1Railway1Raptors1RSSH94_3031SakuraWars1SchoolRumble1Sewing1SFFamily1Sixers1SP2_Basket1SportLottery1SteveNash131Sub_GConsole1Supernatural1SuperStarAve1swim1TaichungBun1Taipei1Taitung1TigerBlue1TKU_EW94B1TPC_Police1TTU-talk1UniversityTV1VinceCarter1Wade1wisdom1YLclub1YUGIOH1<< 收起看板(267)

首頁

尾頁

[SQL ] 設計資料表的欄位

[ Database ]3 留言, 推噓總分: +1

作者: kattte - 發表於 2015/11/28 12:23(10年前)

2^F→kattte: 我原本也是打算這樣11/28 16:17

[SQL ] 想問一下有關primary key設計的問題

[ Database ]6 留言, 推噓總分: +1

作者: sankight - 發表於 2015/10/02 23:16(10年前)

2^F→kattte: 2較好, 如果幣別跟對應帳號要一直擴增你的1就麻煩了10/04 17:20

3^F→kattte: 好像不太對你的公司id跟幣別還有對應的銀行與帳號全都塞10/04 17:24

4^F→kattte: 在同一個table裡喔?10/04 17:24

5^F→kattte: 我沒搞清楚就回答請無視我 @@10/04 17:32

[SQL ] 如何判斷員工的年資

[ Database ]24 留言, 推噓總分: 0

作者: HankJiang - 發表於 2015/08/04 20:05(10年前)

5^F→kattte: 年資>3 and 年資<10 這樣可以嗎08/04 22:09

6^F→kattte: 阿不好意思沒注意到是oracle08/04 22:09

7^F→kattte: oracle我不太清楚但你可以計算出他年資幾年之後指定年資08/04 22:13

8^F→kattte: 要在你設的範圍內這是可以的08/04 22:14

12^F→kattte: 我是用mysql, oracle的語法怎麼下我不清楚08/06 22:31

13^F→kattte: SELECT * FROM student WHERE (TO_DAYS(NOW()) -08/06 22:33

14^F→kattte: - TO_DAYS(`Birth_Date`)) >(40*365)08/06 22:33

15^F→kattte: 今天 - 生日 > 40*365(天)08/06 22:34

16^F→kattte: 我的資料裡面有 1982年 1950年這樣就能篩選出 1950的08/06 22:34

18^F→kattte: 不差那一天吧08/08 00:07

22^F→kattte: 不就 10 > 年資 and 年資 > 308/13 00:53

首頁

尾頁