White Life Story

[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>

SELECT datname FROM pg_database;

SELECT table_name FROM information_schema.tables WHERE table_schema = 'schema name';

SELECT column_name FROM information_schema.columns WHERE table_name = 'table name';

coalesce(value1, value2)

% sudo vi /etc/sysctl.conf

On a MacBook Pro with 2GB of RAM, the author's sysctl.conf contains:

kern.sysv.shmmax=1610612736

kern.sysv.shmall=393216

kern.sysv.shmmin=1

kern.sysv.shmmni=32

kern.sysv.shmseg=8

kern.maxprocperuid=512

kern.maxproc=2048

psql -U user -d db < dump.sql

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');