B / Y / U / S
HOME
À¥ È£½ºÆÃ
µµ¸ÞÀÎ
¸Å´º¾ó
°í°´Áö¿ø
¼³Á¤Á¤º¸
°èÁ¤½Åû
2024-12-28 Saturday
À¥ È£½ºÆÃ
#
°øÁö »çÇ×
#
ÀÚÁÖ ¹¯´Â Áú¹®
#
Áú¹®°ú ´äº¯
#
°¡ÀÔ ¹®ÀÇ
Ä¿¹Â´ÏƼ
#
ÀÚÀ¯°Ô½ÃÆÇ
#
¸®´ª½ºÆÁ
#
¾ÆÀÌÅ¥ Å×½ºÆ®
#
³»È¨ ¼Ò°³
#
°Ö·¯¸®
#
ÀÚ·á½Ç
ÀÚÀ¯°Ô½ÃÆÇ
Modify Article
NickName
_
_
_
Pass
_
Homepage
_
_
TITLE
_
_
_
HTML
BR
__
TextAreaSize
mysql ¿¡ Á¢¼ÓÇϽǶ§ mysql -u [id] -p [id] ÇÏ¼Å¾ß Çϴµ¥ ³¡¿¡ [id] °¡ ºüÁ³±º¿ä ¾ÕÂÊ¿¡ id ´Â µðºñ À¯Àú¸¦ ¶æÇÏ°í µÚÂÊ¿¡ id ´Â µðºñ³×ÀÓÀ» ¶æÇÕ´Ï´Ù. mysql -u dbid -p dbname Àε¥ ÇöÀç ÀÌ°÷¿¡¼± dbid ¿Í dbname ÀÌ °°±â ¶§¹®¿¡ Àú·¸°Ô Ç¥ÇöÇÑ °ÍÀÔ´Ï´Ù. mysql> <- ¿ä»óÅ¿¡¼ µðºñ¸íÀ» Á¤ÇÏ°í ½ÍÀ»¶© use dbname; ÇÏ½Ã¸é µË´Ï´Ù Áï use [id]; °¡ µÇ°Ú³×¿ä. s.h wrote.. : À½.. Á¦°¡ Ãʺ¸¶ó ÀÌ·¸°Ô ¿©·¯¹ø Áú¹®ÇÏ°Ô µÇ³×¿ä.. : ´Ù½Ã Çѹø Á˼Û.. ±×·³ ÀÚ¼¼ÇÏ°Ô ½á º¸°Ú½À´Ï´Ù. : : ¿ì¼±, °¡¸£ÃÄ ÁֽŴë·Î : : [lujah@Tina htmlroot]$ mysql -u lujah -p lujah < mydb.sql : Enter password: (Æнº¿öµåÀÔ·Â) : : ÀÌ·¸°Ô Çß´õ´Ï : : [lujah@Tina htmlroot]$ : : ÀÌ·¸°Ô ¾Æ¹«¸»µµ ¶ßÁö ¾Ê¾Æ¼ Á¦´ë·Î µÆ³ª ½Í¾î : : [lujah@Tina htmlroot]$ mysql -ulujah -p(Æнº¿öµåÀÔ·Â) : : ÀÌ·¸°Ô Çß½À´Ï´Ù. : : Welcome to the MySQL monitor. Commands end with ; or \g. : Your MySQL connection id is 8135 to server version: 3.23.38 : : Type 'help;' or '\h' for help. Type '\c' to clear the buffer : : mysql> : : ÀÌ·¸°Ô mysql Á¢¼ÓÇÏ´Â°Í ±îÁö´Â Á¦´ë·Î ÇÑ°Í °°Àºµ¥.. : ±× ´ÙÀ½, show tables; À» ÀÔ·ÂÇß´õ´Ï : : ERROR 1046: No Database Selected : : ÀÌ·± ¿¡·¯ ¹®±¸°¡ ¶å´Ï´Ù. : º¹±¸°¡ ¾ÈµÈ°Í °°Àºµ¥.. : Á¦°¡ ¹» À߸øÇß´ÂÁö.. ¾Æ, ±×¸®°í Ȥ½Ã º¹±¸ ½Ãų¶§ : Á¦·Îº¸µå ¾È¿¡¼ ±×·ìÀ̳ª °Ô½ÃÆǵîÀ» ¹Ì¸® °°Àº À̸§ : À¸·Î »ý¼º ½ÃÄÑ µÎ¾î¾ß Çϴ°ÇÁö.. ¾Æ´Ï¸é DB¸¸ Á¦´ë·Î : º¹±¸°¡ µÇ¸é ±×·ì °°Àº°Íµµ ÀüºÎ »ý¼ºÀÌ µÇ´Â°ÍÀÎÁö.. : ±×°Íµµ ±Ã±Ý.. ¿¡°í.. Á˼ÛÇÕ´Ï´Ù.
Copyleft
1999-2024 by
JSBoard Open Project
Theme Designed by
IDOO
And follow
GPL2
°³ÀÎÁ¤º¸ Ãë±Þ¹æħ
ÀÌ¿ë ¾à°ü
»çÀÌÆ® ¸Ê
¾îµå¹Î °ü¸®