作者查詢 / carlcarl

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

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

限定看板：Database

看板排序：

全部Mo-Musume1293GO638PokeMon413SRW311Olympics_ISG308Browsers284FinalFantasy198Linux172Soft_Job147GBF146PushDoll129DigiCurrency107PHP96Web_Design87C_and_CPP76Badminton56java55Tech_Job54Python51Google45sex40Cloud38NARUTO38Ajax34MAC34JLPT33Windows33GUNDAM32GO_FATE31Blog29Stock28EZsoft25Programming25C_Chat23Database23Gossiping23Hate23iOS23LinuxDev21PeopleSeries20home-sale16SYSOP16Editor14Golden-Award14Mancare14Free_box13LCD13ONE_PIECE11sky11Jeans10RDSS10Suckcomic10Tennis10Slayers9CFP8HSNU_10978LuniaWar8Sangokumusou8media-chaos7NSYSU_EE95-17OtsukaAi7Network6PlayStation6share6WorldCup6Android5DIGIMON5Foreign_Inv5MH5pts5StupidClown5WomenTalk5cksh79th3104MusouOnline4NCCU_SEED4PSP-PSV4Road_Running4TY_Research4Wallpaper4Yunlin4AntiVirus3Aya3book3CCU-3DVG3ck57th3213CYCUEL95A3DeathNote3Fantasy3FJU-ACCR943Fund3HSNU_10083Key_Mou_Pad3KOTDFansClub3Militarylife3NIHONGO3NTUdent943TTU-I91A3TuTsau3BuRuRadio2ck56th3242ComeHere2CPU_CID7312CSMU-MED952CTSH923012CYCU_EE_07A2feminine_sex2FJU-ACC90a2FJU-STAT95B2Flash2GAMEMUSIC2graduate2HarryPotter2HSNU_10372HSNU_10982ILSH-953082Isayama2ISUEE93A2J-PopStation2KS94-3122KS94-3202MaiKuraki2NCCU_PubLaw2NCHU-AGR022NSwitch2NTHU_IEEM-942NTULawHome2NTUSTET-TEAM2NUU-EO-97A2NUU_Talk2PCSH91_3052SCU_CIS-92A2SENIORHIGH2SpaceArt2specialman2THU-P-Softbo2THU_BA20002TigerBlue2AOE1AOSO_Lab1Apollo1ASHS-93-li1ask1Ayu1bag1Bank_Service1BBSmovie1Beauty1Bunco1C_Sharp1CCSH_91_3151CCSH_91_3201CEM941ck49th3331ck53rd1221ck55th3201ck56th3051ck56th3061ck56th3211ck56th3221ck56th3311ck58th3071ck60th3071CKPoem1cksh78th121cksh78th201cksh79th011cksh79th191cksh83rd3071cksh84th3121CLHS-52-3091CLHS-53-131CODE_GEASS1CPU_CP7311CPU_PA7511CPU_TS7311CSMU-CH1CSMU-D891CSMU-HSA931CSMU-HSA951CSMU-MED941CSMU-PH931csmumountain1CSSH_4TH_6011Detective1dlsh-7th-3031DYU1EAseries1Eclipse1Economics1Ecophilia1Excalibur1Family1fashion1FCU-INS93B1FCU-PF20061FCU_EE97A1FCU_EE97B1FCU_SB_CLUB1Feminism1FHSH-89-3161Finance1FJU-BA96A1FJU-EE-PIPO1FJU-Law20041FJU-STAT92A1FJU-Stat94B1FJU_AD-041FJU_Chiayun1flying1FSHS-92-3141FuMouDiscuss1Gash1GatoShoji1HCHS593051HCHS923161HCSH_8th_3101HCU_IMD_901Headphone1Health_Life1HLHS_10thU1HotBloodYuan1Hsinchu1HSNU_10151HSNU_10321HSNU_10751HSNU_10821HSNU_10951HSNU_8751HSNU_9791HW903201ILSH-943131Japan_Travel1japanavgirls1Japanese-Gra1JOJO1KERORO1KG96-3171KOU1KS92-3121KS92-3131KS93-3201KS94-3071KS94-3081KS94-3211KS95-3111KS95-3161KS97-3021LawPingPong1Lefty1LGS1Lifeismoney1maevsoftball1MihoNAKAYAMA1MIS1NCCU04_Arab1NCCU04_Korea1NCCU04_PHILO1NCCU04_TUR1NCCU06_PA1NCCU06FMGRAD1NCHU-AGR041NCHU-AGR061NCHU-photo1NCHU_CsHsnu1NCKU_CSIE931NCU91Chinese1NCU97ME-B1NCUCEM1NCYU_Fst_991NDHU-phy961NDMC-M1021NDMC-N561NDMC-P921NDMC-PH241NDS1Neihu1NetSecurity1NKHS-94-H3C1NKNU_OECE971NTHU-DSPMT121NTHU_IE_Mgt1ntnuch-901NTOU-EBFS921NTOU-MME-99B1NTPU-ACC901NTPU-COECO941NTPU-DCSIE1NTU-EM931NTU_CK_TFG1NTUCH-901NTUCH-991NTUE-CS981NTUE-EPC-981NTUE-PD011NTUEE50thchi1NTUEE_POWER1NTUMSE-951NTUNOTE1NTUST-EE-B911NTUST-EE-B941NTUT_EE490A1NTUTTST1NUK_AC1001Option1P2PSoftWare1PC_Shopping1PCCU-CS1PolBadminton1PoliticLaw1PSJH5-3051PSWO3rd1PT-961Ptt-Charity1PttHistory1PublicAffair1Salary1scu_transfer1SD-GundamOL1SFFamily1SFHS1SOB_TEST1SSSH-09th1141Stargate1Storage_Zone1SuperIdol1Supermission1T-STORM_TAP1TA_AN1TaitungH92-11TFSHS66th3071TFSHS66th3181TFSHS67th3241THU-CHE-Soft1THU-CHEM941TKU_EE_92C1TKU_INS1TKU_TSPCB931TNNUA_AH_941TRXradio1TTU-ME941UglyClub1Uri_Nari1Utada1VET_921Warfare1WesternMusic1WRADPE1WuLing46-3171Xiao1YMU_bioMed961YP92-3041YP94-3041YP94-3061Yup02-031YZUfinGrad951ZARD1<< 收起看板(356)

首頁

尾頁

Re: [SQL ] 問投票系統資料庫規劃設計[MySQL]

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

作者: carlcarl - 發表於 2013/03/18 02:19(13年前)

4^F→carlcarl:哦哦也是啦XD03/19 01:04

[SQL ] timestamp

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

作者: jerrywings - 發表於 2012/11/25 03:21(13年前)

1^F推carlcarl:把欄位的type改成date11/25 03:54

Re: [SQL ] select 後 insert

[ Database ]8 留言, 推噓總分: +2

作者: carlcarl - 發表於 2012/10/16 00:39(13年前)

2^F→carlcarl:糟糕我發現後面那個解法會有data miss的情形10/16 05:46

3^F→carlcarl:我用壓力測試去測應該是沒有race condition的情況10/16 05:47

4^F→carlcarl:可是資料會莫名的不見不知道為啥所以還是用第一種解法10/16 05:47

7^F→carlcarl:我的想法是這樣不過我發現講這種query的資料有點少10/16 19:31

8^F→carlcarl:所以沒辦法取得啥可信的資料來作驗證> <10/16 19:31

[問題] 請問有關insert語法的performance問題

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

作者: iversonjimmy - 發表於 2012/07/12 10:13(13年前)

2^F推carlcarl:同樓上可以google "bulk insert"可以看到一些資料07/14 00:52

[SQL ] 想不出來該怎麼做...

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

作者: dividi - 發表於 2012/06/15 03:28(13年前)

1^F推carlcarl:最後查出來的結果如果有兩筆就是和局吧一筆就正常06/15 04:06

[資源] Load management Techniques for MySQL

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

作者: carlcarl - 發表於 2012/05/26 18:24(13年前)

1^F→carlcarl:是說我不知道他說的concurrency是指哪個設定= =a05/26 18:28

Re: [SQL ] MYSQL 如何從遠端得到資料並覆蓋原TABLE?

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

作者: carlcarl - 發表於 2012/05/18 14:55(13年前)

2^F→carlcarl:http://ithelp.ithome.com.tw/question/1003742505/21 17:36

[SQL ] 為何同樣條件查詢時間不一樣？

[ Database ]8 留言, 推噓總分: +5

作者: newvalentine - 發表於 2012/05/02 23:44(13年前)

4^F推carlcarl:拿欄位資料的多寡對速度也是很傷的05/03 03:52

Re: [SQL ] 如何產生不重覆的准考證號碼?

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

作者: Clessin - 發表於 2012/04/29 17:25(13年前)

3^F推carlcarl:推!!04/30 04:43

[SQL ] 如何產生不重覆的准考證號碼?

[ Database ]13 留言, 推噓總分: +5

作者: Clessin - 發表於 2012/04/28 04:24(13年前)

5^F推carlcarl:乾脆多個table紀錄各科總人數? 原本table再加上上面的04/28 17:47

6^F→carlcarl:unique04/28 17:47

首頁

尾頁