이응기역

alter table MYTABLE add primary key ( MYID );

alter table MYTABLE add index  MYCOL ( MYCOL );

show index from MYTABLE;

참고: http://www.webmadang.net/database/database.do?action=read&boardid=4003&page=2&seq=10

출처:http://stackoverflow.com/questions/1887964/duplicate-entire-mysql-database

CREATE DATABASE duplicateddb;

 mysqldump -u admin -p originaldb | mysql -u backup -pPassword duplicateddb; 

mysqldump --no-data  -uUSERID -pPASSWORD -h HOST DB > dbschema.dump

* 출처:http://stackoverflow.com/questions/4486787/jackson-with-json-unrecognized-field-not-marked-as-ignorable

import org.codehaus.jackson.map.ObjectMapper;

public class TestObjectmapper implements SubJobRunner { 

public static void main(String[] args) {

//    String jsonStr = "{\"wrapper\"\:[{\"id\":\"13\",\"name\":\"Fred\"}]}";

   String jsonStr = "{}";

   ObjectMapper mapper = new ObjectMapper();  

   Wrapper wrapper = null;

   try {

       wrapper =         mapper.readValue(jsonStr , Wrapper.class);

   } catch (Exception e) {

       e.printStackTrace();

   }

   System.out.println("111111111111111");

   System.out.println("wrapper = " + wrapper);

   System.out.println("222222222222222222");

}

public class Student { 

   private String name;

   private String id;

   //getters & setters for name & id here

}

public class Wrapper {

   private List<Student> students;

   //getters & setters here

}

}

http://stackoverflow.com/questions/16987543/how-to-fix-org-codehaus-jackson-map-exc-unrecognizedpropertyexception

회원 가입 후 임시 사용할 수 있다.

http://www.objectaid.com/install-license

eclipse 등록 방법 : windows -> preferences -> objectaid -> add

출처:http://stackoverflow.com/questions/3613704/mysql-show-current-connection-info

mysql> status;
--------------
mysql  Ver 14.14 Distrib 5.5.8, for Win32 (x86)

Connection id:          1
Current database:       test
Current user:           ODBC@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.5.8 MySQL Community Server (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    gbk
Conn.  characterset:    gbk
TCP port:               3306
Uptime:                 7 min 16 sec

Threads: 1  Questions: 21  Slow queries: 0  Opens: 33  Flush tables: 1  Open tables: 26  Queries per second avg: 0.48
--------------

mysql>

//package com.samsung.recommendation.post.dataupload.impl; 

import java.io.File;

import java.io.FileNotFoundException;

import java.io.FileWriter;

import java.io.RandomAccessFile;

import java.sql.DriverManager;

import java.sql.ResultSet;

//import java.*;

import java.sql.SQLException;

import java.util.ArrayList;

//import com.samsung.recommendation.dc.ExampleItemReader;

public class TestPPExistsFullDirectory {

//private ExampleItemReader reader = new ExampleItemReader();

public static void main(String[] args) throws FileNotFoundException{

int result = 1;

String filePathLoop = "d:/mydir";

File fileLoop;

fileLoop = new File(filePathLoop);

System.out.println("fileLoop.isDirectory() >>>" + fileLoop.isDirectory());

if (fileLoop.isDirectory()) { // 디렉토리면 ...

File subLoop[] = fileLoop.listFiles();

for(int b = 0 ; b < subLoop.length; b++){

System.out.println("dir list >>>"+subLoop[b].getPath());

}

}

System.exit(result);

}

}

ctrl + k

ctrl + shift + o