AsCENT & MaNGOS
Would you like to react to this message? Create an account in a few clicks or log in to continue.

ÀÚÁÖ »ç¿ëÇÏ´Â MySQL Äõ¸®¹®

3 posters

Go down

ÀÚÁÖ »ç¿ëÇÏ´Â MySQL Äõ¸®¹® Empty ÀÚÁÖ »ç¿ëÇÏ´Â MySQL Äõ¸®¹®

¿Ã¸®±â by Admin 2008-09-09, 7:33 am

1. Å×À̺í A ¿Í Å×À̺í B ÀÇ Çʵå1ÀÇ °ªÀ» ºñ±³ÈÄ À¯ÀÏÇÑ Çʵå1 °ªÀ» Ãâ·Â
select * from Å×À̺í_A where not exists (select ¡®Çʵå1¡Ç from Å×À̺í_B where Å×À̺í_B.Çʵå1 = Å×À̺í_A.Çʵå1);
2. MySQL 3.22 ¹öÀü¿¡¼­ MySQL 4.1 ÀÌ»óÀ¸·Î DB º¹±¸ÇÒ¶§ ÇÑ±Û ±úÁüÀÌ ¹ß»ýÇÒ¶§
MySQL 3.22 ¹öÀü¿¡¼­ µðºñ ¹é¾÷ ¸í·É¾î
mysqldump -u root -p –default-character-set=euc_kr DB¸í > ÆÄÀÏÀ̸§.sql
MySQL 4.1 ¹öÀü À̻󿡼­ ¸ÕÀú DB¸íÀ» À§¿¡¼­ ÁöÁ¤ÇÑ ¹®ÀÚ¼ÂÀ¸·Î »ý¼ºÇÑ´ÙÀ½ ¾Æ·¡ µðºñ º¹±¸ ¸í·É¾î·Î º¹±¸ÇÑ´Ù.
mysql -u root -p DB¸í < ÆÄÀÏÀ̸§.sql

Admin
Admin

°Ô½Ã¹° °¹¼ö : 380
Age : 54
Registration date : 2008-08-09

Character sheet
test:

https://study4u.forumkorean.com

À§·Î Go down

ÀÚÁÖ »ç¿ëÇÏ´Â MySQL Äõ¸®¹® Empty Re: ÀÚÁÖ »ç¿ëÇÏ´Â MySQL Äõ¸®¹®

¿Ã¸®±â by ppchun 2008-09-09, 7:38 am

ÀÌ ±¸¹®Àº ¾îÂ¸é »ó´çÈ÷ À¯¿ëÇÑ ±¸¹®À̳׿ä ^^
ppchun
ppchun

°Ô½Ã¹° °¹¼ö : 108
Age : 56
Registration date : 2008-08-19

À§·Î Go down

ÀÚÁÖ »ç¿ëÇÏ´Â MySQL Äõ¸®¹® Empty Re: ÀÚÁÖ »ç¿ëÇÏ´Â MySQL Äõ¸®¹®

¿Ã¸®±â by Admin 2008-09-09, 7:59 am

Á¦°¡ ¿ö³« ±â¾ï·ÂÀÌ ³ª»µÁ®¼­..
¸Þ¸ðÇصµ ã±â Èûµé°í ÇѰ͵éÀ»
À¥¿¡ ¿Ã·Á¼­ ÇÊ¿äÇÒ¶§¸¶´Ù »ç¿ëÇϱâ À§ÇØ ¸ð¾Æ³õÀº Á¤º¸µéÀÔ´Ï´Ù.

¾îÂ¸é ¾ÆÁÖ ±âÃÊÀûÀΰ͵鵵 ÀÖÁö¿ä~¤»¤»

³ªÀ̸¦ ¸Ô¾î°¡¸é¼­ Á¡Á¡ ¼ýÀÚ ³îÀÌ¿¡ ¾àÇØÁö°í
½±°Ô ÀØ°í »ì°ÔµÇ´õ±º¿ä.
¿¾ ¸»Áß¿¡
³» ¸Ó¸®¸¦ ¹ÏÁö¸»°í, ±â·ÏÀ» Ç϶ó´Â ÀǹÌÀÇ ¸í¾ðÀÌ ÀÖ´øµ¥...

ÀÌ°÷ °Ô½ÃÆÇÀº ÀڷẸ°ü ¹× °øÀ¯ ³ª´®ÀÇ ¸ñÀûÀ¸·Î ¸¸µç °÷ÀÔ´Ï´Ù.

Á¦°¡ ÇÊ¿äÇÏ°í ¿äûÀÌ µÇ¸é ¾ÕÀ¸·Î °è¼Ó Ãß°¡µÉ ¼öµµ ÀÖ½À´Ï´Ù.

¤µ¤µ

Admin
Admin

°Ô½Ã¹° °¹¼ö : 380
Age : 54
Registration date : 2008-08-09

Character sheet
test:

https://study4u.forumkorean.com

À§·Î Go down

ÀÚÁÖ »ç¿ëÇÏ´Â MySQL Äõ¸®¹® Empty Re: ÀÚÁÖ »ç¿ëÇÏ´Â MySQL Äõ¸®¹®

¿Ã¸®±â by ppchun 2008-09-09, 9:35 am

¤¾¤¾ ¹«½¼ ¶æÀÎÁö Àß ¾Ë°Ú³×¿ä ¤»¤»
ppchun
ppchun

°Ô½Ã¹° °¹¼ö : 108
Age : 56
Registration date : 2008-08-19

À§·Î Go down

ÀÚÁÖ »ç¿ëÇÏ´Â MySQL Äõ¸®¹® Empty Re: ÀÚÁÖ »ç¿ëÇÏ´Â MySQL Äõ¸®¹®

¿Ã¸®±â by kyg6659 2008-11-14, 9:23 am

select ¹®À» ÀÌ¿ëÇÑ ÃßÃâ Äõ¸®¹®ÀÌ »ý°¢³ª¼­ Àû¾îº¾´Ï´Ù.
select * into 'ÆÄÀÏÀ̸§.txt' from Å×À̺í¸í where Çʵå¸í=Á¶°Ç°ª;
ÀÌ°É ÀÌ¿ëÇÏ¸é ¿øÇÏ´Â °ª¸¸ ÆÄÀÏ·Î ÃßÃâÇÒ¼öÀÖ½À´Ï´Ù.
ÃßÃâÇÑ ÆÄÀÏÀº mysqlÀÌ ¼³Ä¡µÈ Æú´õ ¾îµò°¡¿¡.. (¹«Ã¥ÀÓ) ¤»¤»
´Ù¸¸ ¾ÈÁÁÀº°Ç.. insert Äõ¸®¹®À¸·Î »Ì°í½ÍÀ»떈 Á» ¾È½À..
À§¿¡²¬ ÀÌ¿ëÇÏ¸é °Á ÇØ´ç µ¥ÀÌÅ͵鸸 ÂÓ³ª¿Í¿ë...

kyg6659

°Ô½Ã¹° °¹¼ö : 20
Age : 35
Registration date : 2008-09-13

À§·Î Go down

ÀÚÁÖ »ç¿ëÇÏ´Â MySQL Äõ¸®¹® Empty Re: ÀÚÁÖ »ç¿ëÇÏ´Â MySQL Äõ¸®¹®

¿Ã¸®±â by Sponsored content


Sponsored content


À§·Î Go down

À§·Î

- Similar topics

 
Permissions in this forum:
´ä±ÛÀ» ¿Ã¸± ¼ö ¾ø½À´Ï´Ù