| ¸¶¸® Pipe ChainingÀÌÀÖ´Â È®Àå °¡´ÉÇÑ MySQL ¸í·É Á٠Ŭ¶óÀ̾ðÆ® |
Áö±Ý ´Ù¿î·Îµå |
¸¶¸® ¼øÀ§ ¹× ¿ä¾à
- °Ô½ÃÀÚ À̸§:
- Bjorn Melinder
- °Ô½ÃÀÚ À¥»çÀÌÆ®:
- https://launchpad.net/~myterm-team
¸¶¸® ű×
¸¶¸® ¼³¸í
Pipe ChainingÀÌÀÖ´Â È®Àå °¡´ÉÇÑ MySQL ¸í·É Á٠Ŭ¶óÀ̾ðÆ® MyTermÀº Äõ¸®¸¦ ½ÇÇàÇÏ´Â µ¥ »ç¿ëÇÒ ¼ö ÀÖÀ¸¸ç ÆÄÀÌÇÁ üÀÎÀ» »ç¿ëÇÏ¿© ´Ù¾çÇÑ ¹æ¹ýÀ¸·Î »ý¼º µÈ °á°ú¸¦ ¿©·¯ °¡Áö ¹æ¹ýÀ¸·Î ÇÊÅ͸µ ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¡ÇÈ Â÷Æ®¸¦ »ý¼ºÇÏ°í ºê¶ó¿ìÀú ÅëÇÕÀÌ ÀÖ½À´Ï´Ù. ±×·¯³ª ÄܼÖ, ½ÅÈ£ ó¸® ¹× ¸ÖƼ ½º·¹µùÀ»º¸´Ù Àß Áö¿øÇϱâ À§ÇØ ÆÄÀ̽㿡¼ ´Ù½Ã ÀÛ¼ºÇؾßÇÕ´Ï´Ù. ÇöÀç ±¸¹® ºÐ¼® ¹× ¿É¼Ç 󸮰¡ Á¦ÇѵÇÁö¸¸, ´ëºÎºÐÀÇ ±âº»ÀûÀÎ ¹°°ÇÀº ±×°Í¿¡ ´ëÇÑ ´À³¦À» ¾òÀ» ¼ö ÀÖµµ·Ï ÀÛ¿ëÇÕ´Ï´Ù. Some example : Connecting : MyTerm -UROOTProducing ºê¶ó¿ìÀú¿¡¼ HTML Ãâ·Â : MyTerm> µ¥ÀÌÅͺ£À̽º Ç¥½Ã | htmlcolumn ÇÊÅ͸µ : myterm> show ÇÁ·Î¼¼½º¸®½ºÆ® | cols 2-3pie Â÷Æ® : myterm> information_schema.tables ±×·ì¿¡¼ count count count select information_schema.tables ±×·ì¿¡¼ 2 DESC±îÁö count (*) ¼±Åà | °á°ú ¼¼Æ® °¨¼Ò (±âŸ)°¡ÀÖ´Â Â÷Æ® ÆÄÀÌ ¹Ù Â÷Æ® : myterm> concat (table_schema, ')À» ¼±ÅÃÇϽʽÿÀ. , table_name) AS`table`, data_length + index_length information_schema.tables ¿À´õ 2 desc | ±âŸ 7 | °á°ú ÁýÇÕÀÇ HbarReverse-Engineering : MyTerm> processlist Ç¥½Ã | »ðÀÔ | TSV -N -ESHOW·Îµå µÈ Ç÷¯±×ÀÎ : myterm> plugins -lbto °ü·Ã, û»çÁøÀ» »ìÆ캸½Ê½Ã¿À. MyTerm-Team ¹× ¸ÞÀÏ ¸µ¸®½ºÆ®¿¡ °¡ÀÔÇϽʽÿÀ. Äڵ带 °¡Á® ¿Í¼ ÄÚµùÀ» ½ÃÀÛÇϽʽÿÀ! ¿ä±¸ »çÇ× : ¡¤ MySQL. ¡¤ PHP.
¸¶¸® °ü·Ã ¼ÒÇÁÆ®¿þ¾î