µ¥ÀÌÅͺ£À̽º »ý¼º »èÁ¦
µ¥ÀÌÅͺ£À̽º »ý¼º »èÁ¦
Version : Mariadb 5.5.4.2-WinX64
µ¥ÀÌÅͺ£À̽º¸¦ »ý¼º ¹× »èÁ¦¿¡ ´ëÇؼ ¾Ë¾Æº»´Ù.
[µ¥ÀÌÅͺ£À̽º »ý¼º]
±âº» ¹®¹ý
CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_specification] ...
create_specification: [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name |
CREATE DATABASE SW_TEST |
SW_TEST µ¥ÀÌÅͺ£À̽º°¡ »ý¼ºµÈ °ÍÀ» È®ÀÎ ÇÒ ¼ö ÀÖ´Ù. »ý¼ºµÈ µ¥ÀÌÅͺ£À̽ºÀÇ ¹®ÀÚ¼ÂÀ» º¸¸é latin1_swedisk_ci·Î »ý¼ºµÈ °ÍÀ» È®ÀÎ ÇÒ ¼ö ÀÖ´Ù. ÀÌ´Â ÇöÀç MariaDBÀÇ ±âº» °ªÀ¸·Î »ý¼ºµÈ´Ù.
ÇѱÛÀ» »ç¿ëÇϱâ À§Çؼ´Â ÀÎÄÚµùÀ» euc-kr À̳ª UTF8¸¦ »ç¿ëÇؾßÇÑ´Ù. ¹®ÀÚ¼ÂÀ» »ç¿ëÀÚ°¡ ÁöÁ¤ÇÏ¿© µ¥ÀÌÅͺ£À̽º¸¦ »ý¼ºÇÏ·Á¸é ´ÙÀ½°ú °°Àº Äõ¸®¸¦ »ç¿ëÇÑ´Ù.
CREATE DATABASE SW_TEST CHARACTER SET = 'UTF8' COLLATE = 'utf8_general_ci'; |
[µ¥ÀÌÅͺ£À̽º »èÁ¦]
drop database SW_TEST |
ÇöÀç µ¥ÀÌÅͺ£À̽ºÀÇ Ä³¸¯Åͼ »óŸ¦ º¸´Â ¸í··¾î´Â ¾Æ·¡ ½ºÅ©¸³Æ®¸¦ ½ÇÇà ÇÑ´Ù.
show variables like 'c%'; |
[Âü°íÀÚ·á]
CREATE DATABASE : https://mariadb.com/kb/en/mariadb/create-database/
[Ãâó] MySQL/MariaDB - µ¥ÀÌÅͺ£À̽º »ý¼º »èÁ¦|ÀÛ¼ºÀÚ SungWook Kang