White Life Story

select

  @row_number:=@row_number+1, data.*

from

  (select @row_number:=0) as rownum, data

[client]

port    = 3306

socket  = /var/lib/mysql/mysql.sock

[mysqld]

port    = 3306

socket  = /var/lib/mysql/mysql.sock

sudo service mysqld restart

Shutting down MySQL.. SUCCESS! 

Starting MySQL. SUCCESS! 

mysql -u[username] -p[password] [database]

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.6.12 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%
   
    // STEP1: mysql 드라이버 로드
    Class.forName("com.mysql.jdbc.Driver");

    // STEP2: Connection 생성
    Connection connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/whitelife", "whitelife", "whitelife");

    // STEP3: Query 작성
    PreparedStatement preparedStatement = connection.prepareStatement("select * from tb_test where test_no = ?");
   
    // STEP4: 조건 처리
    preparedStatement.setInt(1, 2);

    // STEP5: 실행 -> 결과 값 받기
    ResultSet resultSet = preparedStatement.executeQuery();
   
    // STEP6: 결과 값 보기
    while (resultSet.next()) {
        out.println(resultSet.getInt("test_no"));
        out.println(resultSet.getString("title"));
        out.println(resultSet.getString("content"));
        out.println(resultSet.getString("create_date"));
    };
   
    resultSet.close();
   preparedStatement.close();
   connection.close();

%>

show procedure status where db = 'db_test'

delimiter $$

drop procedure if exists test_procedure $$

create procedure test_procedure(p_test varchar(100), p_test_a varchar(10))
begin

-- 선언 부

declare v_test1 int default 0;

declare v_test2 int default 0;

-- 조회

select

test1,

test2

into v_test1, v_test2

from

tb_test;

-- 등록

insert tb_proc_test (test) values (v_test1);

insert tb_proc_test (test) values (v_test2);

end $$

delimiter;

delimiter $$

drop procedure if exists test_procedure $$

create procedure test_procedure(p_test varchar(100), p_test_a varchar(10))
begin

// process

end $$

delimiter;

call test_procedure('a', 'b');

set @number = 2;

select @number;