{"id":3971,"date":"2025-06-07T08:34:28","date_gmt":"2025-06-07T08:34:28","guid":{"rendered":"https:\/\/w3buddy.com\/?post_type=cposts&p=3971"},"modified":"2025-06-07T08:34:29","modified_gmt":"2025-06-07T08:34:29","slug":"sql-create-database","status":"publish","type":"cposts","link":"https:\/\/w3buddy.com\/blog\/notes\/sql\/sql-create-database\/","title":{"rendered":"SQL CREATE DATABASE"},"content":{"rendered":"\n

Creating a database is the first step to start storing your data. The CREATE DATABASE<\/code> command creates a new, empty database in your SQL server.<\/p>\n\n\n\n

\ud83d\udd39 Basic Syntax<\/h2>\n\n\n\n
CREATE DATABASE database_name;<\/code><\/code><\/pre>\n\n\n\n
    \n
  • Replace database_name<\/code> with your desired database name.<\/li>\n\n\n\n
  • The database name must be unique on your server.<\/li>\n<\/ul>\n\n\n\n
    \ud83d\udd39 Examples<\/h2>\n\n\n\n
    CREATE DATABASE sales_db;<\/code><\/code><\/pre>\n\n\n\n
    Creates a database named sales_db<\/code>.<\/p>\n\n\n\n
    \ud83d\udd39 Notes by DBMS<\/h2>\n\n\n\n
      \n
    • In MySQL<\/strong>, you can specify charset and collation:<\/li>\n<\/ul>\n\n\n\n
      CREATE DATABASE sales_db\nCHARACTER SET utf8mb4\nCOLLATE utf8mb4_unicode_ci;<\/code><\/code><\/pre>\n\n\n\n
        \n
      • In SQL Server<\/strong>, optional options include specifying file locations:<\/li>\n<\/ul>\n\n\n\n
        CREATE DATABASE sales_db\nON PRIMARY (\n  NAME = sales_db_data,\n  FILENAME = 'C:\\\\data\\\\sales_db_data.mdf',\n  SIZE = 10MB,\n  MAXSIZE = 100MB,\n  FILEGROWTH = 5MB\n)\nLOG ON (\n  NAME = sales_db_log,\n  FILENAME = 'C:\\\\data\\\\sales_db_log.ldf',\n  SIZE = 5MB,\n  MAXSIZE = 50MB,\n  FILEGROWTH = 5MB\n);<\/code><\/code><\/pre>\n\n\n\n
          \n
        • In Oracle<\/strong>, creating a database is a more complex process usually handled by DBAs, involving creating a database instance and data files.<\/li>\n<\/ul>\n\n\n\n
          \ud83e\udde0 Quick Recap<\/h2>\n\n\n\n
          Key Point<\/th>Explanation<\/th><\/tr><\/thead>
          Command<\/td>CREATE DATABASE database_name;<\/code><\/td><\/tr>
          Purpose<\/td>Creates a new empty database<\/td><\/tr>
          DBMS Variations<\/td>Charset, collation, file options<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
          \ud83d\udca1 Once created, you connect to this database to create tables and store data.<\/p>\n\n\n\n
          \ud83d\udd1c Next: SQL DROP DATABASE<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"
          Creating a database is the first step to start storing your data. The CREATE DATABASE command creates a new, empty database in your SQL server. \ud83d\udd39 Basic Syntax \ud83d\udd39 Examples Creates a database named sales_db. \ud83d\udd39 Notes by DBMS \ud83e\udde0 Quick Recap Key Point Explanation Command CREATE DATABASE database_name; Purpose Creates a new empty database […]<\/p>\n","protected":false},"template":"","meta":{"googlesitekit_rrm_CAowu461DA:productID":""},"categories":[952,979],"class_list":["post-3971","cposts","type-cposts","status-publish","hentry","category-notes","category-sql"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts\/3971","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/cposts"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=3971"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=3971"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}