MySql 문자열 합치기 MySql 문자열 합치기 SELECT a.img_url , CONCAT(CONCAT('http://www.viw.co.kr/portal/travel/' ,seq),'.jpg') murlFROM tb_restaurant a ; UPDATE tb_restaurant a SET a.img_url = CONCAT( CONCAT( 'http://www.viw.co.kr/portal/travel/', seq ) , '.jpg' ) ; 세상이야기 2016.12.19
X2CRM - Sales, Marketing, Workflow, Custom Apps, PHP, MySQL https://sourceforge.net/projects/x2engine/?source=directory X2CRM is modern, commercial grade CRM SoftwareSales, Service and Marketing PHP ApplicationHomepage Activity FeedFull Admin with Visual Form Studio BuilderContact, Account, Opportunity, Service CaseActivity Time TrackingTeam Calendar, TasksForums Knowledgeable, Discussion BoardDocuments and AttachmentsCampaign EmailsSales QuotationsX2Tou.. 세상이야기 2016.03.11
MySQL, TEXT field 크기,TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes MySql 글 저장 할 떄 아래 크기를 참조하세요. Type | Maximum length -----------+------------------------------------- TINYTEXT | 255 (2 8−1) bytes TEXT | 65,535 (216−1) bytes = 64 KiB MEDIUMTEXT | 16,777,215 (224−1) bytes = 16 MiB LONGTEXT | 4,294,967,295 (232−1) bytes = 4 GiB 세상이야기 2016.01.09