ÇÁ·Î±×·¡¹Ö
ù ÆäÀÌÁö ·£´ý ±Û ȸ¿ø°¡ÀÔ ·Î±×ÀÎ
ºñ°ø°³ ¼Õ´Ô ¡¦ 2018-07-11 15:23:21
URL https://te31.com/rgr/view.php?id=study&no=2634 ¸ð¹ÙÀÏ È­¸é
msyql Äõ¸® Áú¹®ÀÌ ÀÖ½À´Ï´Ù.


A Å×ÀÌºí¿¡´Â ID °íÀ¯°ªÀ¸·Î µ¥ÀÌÅÍ°¡ ½×ÀÌ°í ÀÖ½À´Ï´Ù.
ex)
ID | title | date
1 , °íÆã, 2018-07-11
2 , Æã°í, 2018-07-11

B Å×ÀÌºí¿¡´Â A.ID °ªÀ» ÂüÁ¶ÇÏ¿© ½×ÀÌ´Â µ¥ÀÌÅÍ°¡ ÀÖ½À´Ï´Ù.
ex)
ID | post_id | meta_key | meta_value
1 , 1, status, wait
2 , 1, email, mail@te31.com
3 , 2, status, ok
4 , 2, email, supportl@te31.com

ÀÌ·±±¸Á¶·Î µ¥ÀÌÅÍ°¡ ½×ÀÔ´Ï´Ù.

À̸¦ Çѹø¿¡ °¡Á®¿À°í ½Í½À´Ï´Ù.

A.ID,
A.title,
B.meta_value as status ( B.meta_key °¡ status À̸鼭 B.meta_value °¡ wait ÀÎ °æ¿ì),
B.meta_value as email ( B.meta_key °¡ email ÀÎ °æ¿ì)

°£´ÜÇÑ Äõ¸®¸¸ ½è´õ´Ï.. ¸Ó¸®°¡ ¾Èµ¹¾Æ°¡³×¿ë ¤Ð¤Ð¤Ð¤Ð¤Ð¤Ð¤Ð

Áú¹® | 1655¸íÀÌ Àоú¾î¿ä. 52.54.103.76

0
1 ºñ°ø°³ ¼Õ´Ô ¡¦ 2018-07-11 17:59:42
±×³É º¸ÀÚ¸¶ÀÚ ¶°¿À¸¥°Ç
a.id, a.title, b.meta_value as status, c.meta_value as email ¸¦
a, b, b as c ¿¡¼­ °¡Á®¿À´Âµ¥
select meta_value from b where b.meta_key = 'status', ÀΰŶû
select meta_value from c where c.meta_key = 'email' ÀΰŠÇÕÃļ­ °¡Á®¿À¸é µÉµí
2 ºñ°ø°³ ¼Õ´Ô ¡¦ 2018-07-11 18:35:03
join À» ¸»¾¸ÇϽô°ǰ¡
3 ºñ°ø°³ ¼Õ´Ô ¡¦ 2018-07-12 00:32:37
¾Æ...¹º¸»ÀÎÁö ¾Ë¾Ò´Ù. Çǹþ ¸»¾¸ÇϽôµí
group by ÇÏ½Ã¸é µÉ°Å°°À½.

with a as (
select 1 as id,'°íÆã' as title from dual union all
select 2,'Æã°í' from dual
),
b as (

select 1 as id , 1 as post_id, 'status' as meta_key , 'wait' as meta_value from dual union all
select 2 as id, 1, 'email', 'mail@te31.com' as meta_value from dual union all
select 3 as id, 2, 'status', 'ok' as meta_value from dual union all
select 4 as id, 2, 'email', 'supportl@te31.com' as meta_value from dual
)
select a.id
,a.title
,max(case when b.meta_key ='status' then b.meta_value end) as status
,max(case when b.meta_key ='email' then b.meta_value end) as email
from a
join b
on a.id = b.post_id
group by a.id,a.title
;
4 ºñ°ø°³ ¼Õ´Ô ¡¦ 2018-07-12 09:46:56
SELECT
p.ID AS ID,
p.post_title AS domain,
m.meta_value AS status,
( SELECT meta_value FROM postmeta WHERE post_id = p.ID AND meta_key = 'cell_email' ) AS email,
( SELECT meta_value FROM postmeta WHERE post_id = p.ID AND meta_key = 'cell_type' ) AS type

FROM posts AS p , postmeta AS m

WHERE p.ID = m.post_id AND m.meta_key = 'cell_status' AND m.meta_value = 'wait'

ORDER BY p.ID ASC

¾îÁ¦ ÀÌ·±½ÄÀ¸·Î Ç®¾ú´Âµ¥.. ÀÌ·¸°Ô Çصµ µÇ´Â°Ç°¡¿ä
5 ºñ°ø°³ ¼Õ´Ô ¡¦ 2018-07-12 11:58:57
if(meta_key='cell_email', meta_value, null) as email,

ÀÌ·±½ÄÀ¸·Î ¾ÈµÇ³ª¿ä
6 ºñ°ø°³ ¼Õ´Ô ¡¦ 2018-07-12 14:18:48
4¹ø ½ÄÀ¸·Î Ç®¸é ÇàÀÌ ¸¹Àº Äõ¸®¿¡¼±...
Äõ¸®°¡ ´À·ÁÁ®¿ë
Çà °¹¼ö ¸¸Å­ ¾È¿¡ ¼¿·ºÆ®¸¦ ¶Ç ³¯¸®´Â°Å¶ó
7 ºñ°ø°³ ¼Õ´Ô ¡¦ 2018-07-16 09:54:49
Á¦°¡ 5¹øµµ ½Ãµµ¸¦ ÇÏ·Á°í Çß¾ú½À´Ï´Ù.

±×·³ ·°Å°´ÔÀÇ Á¶¾ðÀ» µè°í ¼öÁ¤Çغ¼°Ô¿ä °¨»çÇÕ´Ï´Ù!
´ñ±ÛÀ» ÀÛ¼ºÇÏ½Ç ¼ö ¾ø½À´Ï´Ù.
(±ÇÇÑÀÌ ¾ø´Â ȸ¿ø·¹º§)
¸ñ·ÏÀ¸·Î
ÀÌ¿ë¾à°ü | ±¤°í/Á¦ÈÞ | °³ÀÎÁ¤º¸Ãë±Þ¹æħ | ¹®ÀÇ/½Å°í | ¸ð¹ÙÀÏ TE31 | ¼­¹ö ºÎÇÏ : 4%
½Ç½Ã°£ Issue Ä¿¹Â´ÏƼ TE31 [¾ËÁö·Õ] ¨Ï 2002-2024
TOP arrow_upward