{"id":1546,"date":"2020-03-14T10:09:52","date_gmt":"2020-03-14T10:09:52","guid":{"rendered":"https:\/\/www.magetop.com\/blog\/?p=1546"},"modified":"2021-07-22T02:57:35","modified_gmt":"2021-07-22T02:57:35","slug":"magento-2-how-to-create-database-table","status":"publish","type":"post","link":"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/","title":{"rendered":"Magento 2: How To Create Database Table"},"content":{"rendered":"\n\n\n

In the previous article, we learned How To Create A Simple Custom Module<\/strong>. Following the previous tutorial, we will learn about How To Create Database Table in Magento 2<\/strong>.<\/p>\n\n\n\n

This is a very basic tutorial but it is very important. You will apply it a lot. Let’s start!<\/p>\n\n\n\n

Module File Structure<\/h2>\n\n\n\n

We updated our module file structure looks as follows:<\/p>\n\n\n\n

\"magetop<\/figure>\n\n\n\n

Create file module.xml and registration.php<\/h2>\n\n\n\n

The job of creating these 2 files I have detailed instructions and explanations in the previous article. You can read it here<\/a>.<\/p>\n\n\n\n

Create file InstallSchema.php<\/h2>\n\n\n\n

You create this file according to the path: Magetop\/Helloworld\/Setup\/InstallSchema.php.<\/p>\n\n\n\n

We will create a table name magetop_blog with fields: id, title, description, created_at, status.<\/p>\n\n\n

\n<?php\n\nnamespace Magetop\\Helloworld\\Setup;\n\nuse Magento\\Framework\\DB\\Ddl\\Table;\nuse Magento\\Framework\\Setup\\InstallSchemaInterface;\nuse Magento\\Framework\\Setup\\SchemaSetupInterface;\nuse Magento\\Framework\\Setup\\ModuleContextInterface;\n\nclass InstallSchema implements InstallSchemaInterface\n{\n    public function install(SchemaSetupInterface $setup, ModuleContextInterface $context)\n    {\n        $installer = $setup;\n        $installer->startSetup();\n        $tableName = $installer->getTable('magetop_blog');\n        \/\/Check for the existence of the table\n        if ($installer->getConnection()->isTableExists($tableName) != true) {\n            $table = $installer->getConnection()\n                ->newTable($tableName)\n                ->addColumn(\n                    'id',\n                    Table::TYPE_INTEGER,\n                    null,\n                    [\n                        'identity' => true,\n                        'unsigned' => true,\n                        'nullable' => false,\n                        'primary' => true\n                    ],\n                    'ID'\n                )\n                ->addColumn(\n                    'title',\n                    Table::TYPE_TEXT,\n                    null,\n                    ['nullable' => false, 'default' => ''],\n                    'Title'\n                )\n                ->addColumn(\n                    'description',\n                    Table::TYPE_TEXT,\n                    null,\n                    ['nullable' => false, 'default' => ''],\n                    'Description'\n                )\n                ->addColumn(\n                    'created_at',\n                    Table::TYPE_DATETIME,\n                    null,\n                    ['nullable' => false],\n                    'Created At'\n                )\n                ->addColumn(\n                    'status',\n                    Table::TYPE_SMALLINT,\n                    null,\n                    ['nullable' => false, 'default' => '0'],\n                    'Status'\n                )\n                \/\/Set comment for magetop_blog table\n                ->setComment('Magetop Blog Table')\n                \/\/Set option for magetop_blog table\n                ->setOption('type', 'InnoDB')\n                ->setOption('charset', 'utf8');\n            $installer->getConnection()->createTable($table);\n        }\n        $installer->endSetup();\n    }\n}\n<\/pre><\/div>\n\n\n
Create file InstallData.php<\/h2>\n\n\n\n
Next, we will insert data for the magetop_blog table.<\/p>\n\n\n\n
You create this file according to the path:Magetop\/Helloworld\/Setup\/InstallData.php.<\/p>\n\n\n
\n<?php\n\nnamespace Magetop\\Helloworld\\Setup;\n\nuse Magento\\Framework\\Setup\\InstallDataInterface;\nuse Magento\\Framework\\Setup\\ModuleContextInterface;\nuse Magento\\Framework\\Setup\\ModuleDataSetupInterface;\n\nclass InstallData implements InstallDataInterface\n{\n\n    public function install(ModuleDataSetupInterface $setup, ModuleContextInterface $context)\n    {\n        $setup->startSetup();\n\n        $tableName = $setup->getTable('magetop_blog');\n        \/\/Check for the existence of the table\n        if ($setup->getConnection()->isTableExists($tableName) == true) {\n            $data = [\n                [\n                    'title' => 'How to Speed Up Magento 2 Website',\n                    'description' => 'Speeding up your Magento 2 website is very important, it affects user experience. Customers will feel satisfied when your site responds quickly',\n                    'created_at' => date('Y-m-d H:i:s'),\n                    'status' => 1,\n                ],\n                [\n                    'title' => 'Optimize SEO for Magento Website',\n                    'description' => 'One of the important reasons why many people choose Magento 2 for their website is the ability to create SEO friendly',\n                    'created_at' => date('Y-m-d H:i:s'),\n                    'status' => 1,\n                ],\n                [\n                    'title' => 'Top 10 eCommerce Websites',\n                    'description' => 'These are the websites of famous e-commerce corporations in the world. With very large revenue contributing to the world economy',\n                    'created_at' => date('Y-m-d H:i:s'),\n                    'status' => 0,\n                ],\n            ];\n            foreach ($data as $item) {\n                \/\/Insert data\n                $setup->getConnection()->insert($tableName, $item);\n            }\n        }\n        $setup->endSetup();\n    }\n}\n<\/pre><\/div>\n\n\n
Increase the version in module.xml<\/h2>\n\n\n\n
If you have just created this module and you have not declared it on the database yet, you do not need to increase the version in module.xml<\/p>\n\n\n\n
If you have already declared this module on the database, please increase the version in module.xml<\/p>\n\n\n\n
\"increase<\/figure>\n\n\n\n
Run the command<\/h2>\n\n\n\n
You need to run 2 commands:<\/p>\n\n\n\n
php bin\/magento setup:upgrade<\/code><\/pre>\n\n\n\n
\"run<\/figure>\n\n\n\n
php bin\/magento setup:db-schema:upgrade<\/code><\/pre>\n\n\n\n
\"run<\/figure>\n\n\n\n
Check in the database<\/h2>\n\n\n\n
Please check on the database and You will see your accomplishment.<\/p>\n\n\n\n
\"check<\/figure>\n\n\n\n
\"check<\/figure>\n\n\n\n
Upgrade table in the database<\/h2>\n\n\n\n
Next, I will guide you to add fields to the created table and create a new table in UpgradeSchema.php.<\/p>\n\n\n\n
You create this file according to the path: Magetop\/Helloworld\/Setup\/InstallData.php.<\/p>\n\n\n\n
In the following code, I will implement two field image, category_id and create a new table magetop_blog_categories.<\/p>\n\n\n
\n<?php\n\nnamespace Magetop\\Helloworld\\Setup;\n\nuse Magento\\Framework\\DB\\Ddl\\Table;\nuse Magento\\Framework\\Setup\\UpgradeSchemaInterface;\nuse Magento\\Framework\\Setup\\ModuleContextInterface;\nuse Magento\\Framework\\Setup\\SchemaSetupInterface;\n\nclass UpgradeSchema implements UpgradeSchemaInterface\n{\n    public function upgrade(SchemaSetupInterface $setup, ModuleContextInterface $context)\n    {\n        $setup->startSetup();\n        \/\/Add new fields to the created table\n        if (version_compare($context->getVersion(), '1.0.2') < 0) {\n            $table = $setup->getTable('magetop_blog');\n            \/\/Check for the existence of the table\n            if ($setup->getConnection()->isTableExists($table) == true) {\n                \/\/ Declare data\n                $columns = [\n                    'image' => [\n                        'type' => Table::TYPE_TEXT,\n                        ['nullable' => true],\n                        'comment' => 'Image',\n                    ],\n                    'category_id' => [\n                        'type' => Table::TYPE_INTEGER,\n                        ['nullable' => false, 'default' => 0],\n                        'comment' => 'Category ID',\n                    ],\n                ];\n                $connection = $setup->getConnection();\n                foreach ($columns as $name => $definition) {\n                    $connection->addColumn($table, $name, $definition);\n                }\n            }\n        }\n        \/\/Create a new table\n        if (version_compare($context->getVersion(), '1.0.2') < 0) {\n            $categories = $setup->getTable('magetop_blog_categories');\n            \/\/Check for the existence of the table\n            if ($setup->getConnection()->isTableExists($categories) != true) {\n                $tableCategories = $setup->getConnection()\n                    ->newTable($categories)\n                    ->addColumn(\n                        'cat_id',\n                        Table::TYPE_INTEGER,\n                        null,\n                        ['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true],\n                        'Category Id'\n                    )\n                    ->addColumn(\n                        'status',\n                        Table::TYPE_SMALLINT,\n                        null,\n                        ['nullable' => false, 'default' => 1],\n                        'Status'\n                    )\n                    ->addColumn(\n                        'cat_title',\n                        Table::TYPE_TEXT,\n                        null,\n                        ['nullable' => false, 'default' => ''],\n                        'Category Title'\n                    )\n                    ->addColumn(\n                        'created_at',\n                        Table::TYPE_TIMESTAMP,\n                        null,\n                        ['nullable' => false],\n                        'Created At'\n                    )\n                    \/\/Set comment for magetop_blog table\n                    ->setComment('Magetop Blog Categories')\n                    \/\/Set option for magetop_blog table\n                    ->setOption('type', 'InnoDB')\n                    ->setOption('charset', 'utf8');\n                $setup->getConnection()->createTable($tableCategories);\n            }\n        }\n        $setup->endSetup();\n    }\n}\n<\/pre><\/div>\n\n\n
We will insert data for the magetop_blog_categories table.<\/p>\n\n\n
\n<?php\n\nnamespace Magetop\\Helloworld\\Setup;\n\nuse Magento\\Framework\\Setup\\UpgradeDataInterface;\nuse Magento\\Framework\\Setup\\ModuleContextInterface;\nuse Magento\\Framework\\Setup\\ModuleDataSetupInterface;\n\nclass UpgradeData implements UpgradeDataInterface\n{\n\n    public function upgrade(ModuleDataSetupInterface $setup, ModuleContextInterface $context)\n    {\n        $setup->startSetup();\n\n        if (version_compare($context->getVersion(), '1.0.2') < 0) {\n            $tableName = $setup->getTable('magetop_blog_categories');\n            \/\/Check for the existence of the table\n            if ($setup->getConnection()->isTableExists($tableName) == true) {\n                $data = [\n                    [\n                        'cat_title' => 'News',\n                        'status' => 1,\n                        'created_at' => date('Y-m-d H:i:s'),\n                    ],\n                    [\n                        'cat_title' => 'Tutorials',\n                        'status' => 0,\n                        'created_at' => date('Y-m-d H:i:s'),\n                    ],\n                    [\n                        'cat_title' => 'Uncategorized',\n                        'status' => 0,\n                        'created_at' => date('Y-m-d H:i:s'),\n                    ]\n                ];\n                foreach ($data as $item) {\n                    \/\/Insert data\n                    $setup->getConnection()->insert($tableName, $item);\n                }\n            }\n        }\n        $setup->endSetup();\n    }\n}\n<\/pre><\/div>\n\n\n
Do not forget to increase the version in module.xml!.<\/p>\n\n\n\n
Finally, run the two commands above and enjoy the result.<\/p>\n\n\n\n
\"check<\/figure>\n\n\n\n
\"check<\/figure>\n\n\n\n
\"check<\/figure>\n\n\n\n
I hope through this series you can create your own complete module. Good luck!<\/p>\n\n\n\n
In addition to Magento 2: How To Create Database Table, you can read the articles How To Use Model In Magento 2<\/a>.<\/p>\n\n\n\n
Follow us for the more helpful article!<\/p>\n\n\n\n
We hope this is a useful series for you.<\/p>\n\n\n\n
Thank you for reading!<\/p>\n","protected":false},"excerpt":{"rendered":"
In the previous article, we learned How To Create A Simple Custom Module. Following the previous tutorial, we will learn about How To Create Database Table in Magento 2. This is a very basic tutorial but it is very important. You will apply it a lot. Let’s start!<\/p>\n","protected":false},"author":106,"featured_media":1558,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2],"tags":[321,320,319,315,317,318,316,107],"class_list":["post-1546","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-magento-2-tutorials","tag-create-custom-database-table-in-magento-2","tag-how-to-add-a-new-table-to-a-database","tag-how-to-create-custom-database-table","tag-how-to-create-database-table","tag-how-to-create-database-table-in-magento-2","tag-magento-2-create-custom-database-table","tag-magento-2-how-to-create-database-table","tag-magento-2-tutorials"],"yoast_head":"\nMagento 2: How To Create Database Table - Magetop Blog<\/title>\n<meta name=\"description\" content=\"Following the previous tutorial, we will learn about How To Create Database Table in Magento 2. This is a very basic tutorial but it is very important...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Magento 2: How To Create Database Table - Magetop Blog\" \/>\n<meta property=\"og:description\" content=\"Following the previous tutorial, we will learn about How To Create Database Table in Magento 2. This is a very basic tutorial but it is very important...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/\" \/>\n<meta property=\"og:site_name\" content=\"Magetop Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/MagetopStore\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-14T10:09:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-22T02:57:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i2.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/03\/How-To-Create-Database-Table-in-Magento-2.png?fit=750%2C455&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"455\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Aaron LX\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@MagetopStore\" \/>\n<meta name=\"twitter:site\" content=\"@MagetopStore\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Aaron LX\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/\"},\"author\":{\"name\":\"Aaron LX\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/b8770690a02cc53a273d6b7205229ff7\"},\"headline\":\"Magento 2: How To Create Database Table\",\"datePublished\":\"2020-03-14T10:09:52+00:00\",\"dateModified\":\"2021-07-22T02:57:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/\"},\"wordCount\":369,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/03\/How-To-Create-Database-Table-in-Magento-2.png?fit=750%2C455&ssl=1\",\"keywords\":[\"create custom database table in magento 2\",\"How to Add a New Table to a Database\",\"how to create custom database table\",\"How To Create Database Table\",\"How To Create Database Table in Magento 2\",\"magento 2 create custom database table\",\"Magento 2 How To Create Database Table\",\"magento 2 tutorials\"],\"articleSection\":[\"Magento 2 Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/\",\"url\":\"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/\",\"name\":\"Magento 2: How To Create Database Table - Magetop Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/03\/How-To-Create-Database-Table-in-Magento-2.png?fit=750%2C455&ssl=1\",\"datePublished\":\"2020-03-14T10:09:52+00:00\",\"dateModified\":\"2021-07-22T02:57:35+00:00\",\"description\":\"Following the previous tutorial, we will learn about How To Create Database Table in Magento 2. This is a very basic tutorial but it is very important...\",\"breadcrumb\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/03\/How-To-Create-Database-Table-in-Magento-2.png?fit=750%2C455&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/03\/How-To-Create-Database-Table-in-Magento-2.png?fit=750%2C455&ssl=1\",\"width\":750,\"height\":455,\"caption\":\"How To Create Database Table in Magento 2\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.magetop.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Magento 2: How To Create Database Table\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#website\",\"url\":\"https:\/\/www.magetop.com\/blog\/\",\"name\":\"Magetop Blog\",\"description\":\"Exploring Magento Tips, Tricks, and Trends\",\"publisher\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.magetop.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#organization\",\"name\":\"Magetop.com\",\"url\":\"https:\/\/www.magetop.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/11\/logo.png?fit=475%2C475&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/11\/logo.png?fit=475%2C475&ssl=1\",\"width\":475,\"height\":475,\"caption\":\"Magetop.com\"},\"image\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/MagetopStore\",\"https:\/\/x.com\/MagetopStore\",\"https:\/\/www.linkedin.com\/company\/magetop\",\"https:\/\/www.pinterest.com\/magetop\",\"https:\/\/www.youtube.com\/channel\/UCXoiJsz88OfPmwa8QpUkwOA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/b8770690a02cc53a273d6b7205229ff7\",\"name\":\"Aaron LX\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/11\/475315059_122137709240563546_260104055231757176_n.jpg?fit=96%2C96&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/11\/475315059_122137709240563546_260104055231757176_n.jpg?fit=96%2C96&ssl=1\",\"caption\":\"Aaron LX\"},\"description\":\"Aaron is a passionate writer, crazy about shopping, eCommerce and trends. Besides his outstanding research skills and a positive mind, Aaron eagerly shares his experience with the readers.\",\"url\":\"https:\/\/www.magetop.com\/blog\/author\/aaron-lx\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Magento 2: How To Create Database Table - Magetop Blog","description":"Following the previous tutorial, we will learn about How To Create Database Table in Magento 2. This is a very basic tutorial but it is very important...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/","og_locale":"en_US","og_type":"article","og_title":"Magento 2: How To Create Database Table - Magetop Blog","og_description":"Following the previous tutorial, we will learn about How To Create Database Table in Magento 2. This is a very basic tutorial but it is very important...","og_url":"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/","og_site_name":"Magetop Blog","article_publisher":"https:\/\/www.facebook.com\/MagetopStore","article_published_time":"2020-03-14T10:09:52+00:00","article_modified_time":"2021-07-22T02:57:35+00:00","og_image":[{"width":750,"height":455,"url":"https:\/\/i2.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/03\/How-To-Create-Database-Table-in-Magento-2.png?fit=750%2C455&ssl=1","type":"image\/png"}],"author":"Aaron LX","twitter_card":"summary_large_image","twitter_creator":"@MagetopStore","twitter_site":"@MagetopStore","twitter_misc":{"Written by":"Aaron LX","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/#article","isPartOf":{"@id":"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/"},"author":{"name":"Aaron LX","@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/b8770690a02cc53a273d6b7205229ff7"},"headline":"Magento 2: How To Create Database Table","datePublished":"2020-03-14T10:09:52+00:00","dateModified":"2021-07-22T02:57:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/"},"wordCount":369,"commentCount":0,"publisher":{"@id":"https:\/\/www.magetop.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/03\/How-To-Create-Database-Table-in-Magento-2.png?fit=750%2C455&ssl=1","keywords":["create custom database table in magento 2","How to Add a New Table to a Database","how to create custom database table","How To Create Database Table","How To Create Database Table in Magento 2","magento 2 create custom database table","Magento 2 How To Create Database Table","magento 2 tutorials"],"articleSection":["Magento 2 Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/","url":"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/","name":"Magento 2: How To Create Database Table - Magetop Blog","isPartOf":{"@id":"https:\/\/www.magetop.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/#primaryimage"},"image":{"@id":"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/03\/How-To-Create-Database-Table-in-Magento-2.png?fit=750%2C455&ssl=1","datePublished":"2020-03-14T10:09:52+00:00","dateModified":"2021-07-22T02:57:35+00:00","description":"Following the previous tutorial, we will learn about How To Create Database Table in Magento 2. This is a very basic tutorial but it is very important...","breadcrumb":{"@id":"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/#primaryimage","url":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/03\/How-To-Create-Database-Table-in-Magento-2.png?fit=750%2C455&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/03\/How-To-Create-Database-Table-in-Magento-2.png?fit=750%2C455&ssl=1","width":750,"height":455,"caption":"How To Create Database Table in Magento 2"},{"@type":"BreadcrumbList","@id":"https:\/\/www.magetop.com\/blog\/magento-2-how-to-create-database-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.magetop.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Magento 2: How To Create Database Table"}]},{"@type":"WebSite","@id":"https:\/\/www.magetop.com\/blog\/#website","url":"https:\/\/www.magetop.com\/blog\/","name":"Magetop Blog","description":"Exploring Magento Tips, Tricks, and Trends","publisher":{"@id":"https:\/\/www.magetop.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.magetop.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.magetop.com\/blog\/#organization","name":"Magetop.com","url":"https:\/\/www.magetop.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/11\/logo.png?fit=475%2C475&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/11\/logo.png?fit=475%2C475&ssl=1","width":475,"height":475,"caption":"Magetop.com"},"image":{"@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/MagetopStore","https:\/\/x.com\/MagetopStore","https:\/\/www.linkedin.com\/company\/magetop","https:\/\/www.pinterest.com\/magetop","https:\/\/www.youtube.com\/channel\/UCXoiJsz88OfPmwa8QpUkwOA"]},{"@type":"Person","@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/b8770690a02cc53a273d6b7205229ff7","name":"Aaron LX","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/11\/475315059_122137709240563546_260104055231757176_n.jpg?fit=96%2C96&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/11\/475315059_122137709240563546_260104055231757176_n.jpg?fit=96%2C96&ssl=1","caption":"Aaron LX"},"description":"Aaron is a passionate writer, crazy about shopping, eCommerce and trends. Besides his outstanding research skills and a positive mind, Aaron eagerly shares his experience with the readers.","url":"https:\/\/www.magetop.com\/blog\/author\/aaron-lx\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/03\/How-To-Create-Database-Table-in-Magento-2.png?fit=750%2C455&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/paOdw5-oW","jetpack-related-posts":[{"id":1640,"url":"https:\/\/www.magetop.com\/blog\/how-to-use-model-in-magento-2\/","url_meta":{"origin":1546,"position":0},"title":"How To Use Model In Magento 2","author":"Aaron LX","date":"April 1, 2020","format":false,"excerpt":"In this tutorial, we will learn about How To Use Model in Magento 2. This is a basic tutorial followed by How To Create Database Table in Magento 2. You should see the previous article to understand this lesson.","rel":"","context":"In "Magento 2 Tutorials"","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"Magento 2 How To Use Model","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/04\/Magento-2-How-To-Use-Model.png?fit=750%2C445&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/04\/Magento-2-How-To-Use-Model.png?fit=750%2C445&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/04\/Magento-2-How-To-Use-Model.png?fit=750%2C445&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/04\/Magento-2-How-To-Use-Model.png?fit=750%2C445&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":1402,"url":"https:\/\/www.magetop.com\/blog\/magento-2-extension-tutorial\/","url_meta":{"origin":1546,"position":1},"title":"Magento 2 Extension Tutorial","author":"Aaron LX","date":"February 15, 2020","format":false,"excerpt":"Magento 2 is an open-source platform that allows you can create a module for yourself. And those modules can extend functions for the Magento store. And in this article, I will introduce to Magento 2 Extension Tutorial.","rel":"","context":"In "Magento 2 Tutorials"","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"Magetop Extension Tutorial","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/02\/Extension-Tutorial.jpg?fit=750%2C455&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/02\/Extension-Tutorial.jpg?fit=750%2C455&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/02\/Extension-Tutorial.jpg?fit=750%2C455&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/02\/Extension-Tutorial.jpg?fit=750%2C455&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":1696,"url":"https:\/\/www.magetop.com\/blog\/how-to-custom-admin-grid-in-magento\/","url_meta":{"origin":1546,"position":2},"title":"How To Custom Admin Grid In Magento 2","author":"Aaron LX","date":"April 2, 2020","format":false,"excerpt":"In the previous lesson, I introduced How To Create Admin Grid In Magento 2. You should read that lesson to be able to do How To Custom Admin Grid In Magento 2 lesson.","rel":"","context":"In "Magento 2 Tutorials"","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"Magento 2 How To Custom Admin Grid","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/04\/Magento-2-How-To-Custom-Admin-Grid.png?fit=750%2C445&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/04\/Magento-2-How-To-Custom-Admin-Grid.png?fit=750%2C445&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/04\/Magento-2-How-To-Custom-Admin-Grid.png?fit=750%2C445&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/04\/Magento-2-How-To-Custom-Admin-Grid.png?fit=750%2C445&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":94,"url":"https:\/\/www.magetop.com\/blog\/how-to-create-new-custom-module-in-magento-2\/","url_meta":{"origin":1546,"position":3},"title":"How To Create New Custom Module in Magento 2","author":"Adam Roger","date":"March 23, 2019","format":false,"excerpt":"In this tutorial, we will teach you how to create new custom module in Magento 2 to add customized functionality and give you more control over the store. We\u2019re going to build a very simple module in Magento 2. When finished, the module\u2019s output will say \u201cHello world!\u201d in the\u2026","rel":"","context":"In "Magento 2 Tutorials"","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"how to create new custom module in magento 2","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2019\/03\/create-custom-magento-2-module.png?fit=679%2C360&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2019\/03\/create-custom-magento-2-module.png?fit=679%2C360&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2019\/03\/create-custom-magento-2-module.png?fit=679%2C360&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":5605,"url":"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/","url_meta":{"origin":1546,"position":4},"title":"How To Import And Export Database In MySQL Or MariaDB","author":"Aaron LX","date":"June 24, 2021","format":false,"excerpt":"In this post, I will guide you on\u00a0How To Import And Export Database In MySQL Or MariaDB. Use data dumps to back up and restore your information.","rel":"","context":"In "Magento 2 Tutorials"","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"How To Import And Export Database In MySQL Or MariaDB","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1200%2C711&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1200%2C711&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1200%2C711&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1200%2C711&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1200%2C711&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":1651,"url":"https:\/\/www.magetop.com\/blog\/how-to-use-event-in-magento-2\/","url_meta":{"origin":1546,"position":5},"title":"How To Use Event In Magento 2","author":"Aaron LX","date":"April 1, 2020","format":false,"excerpt":"In the previous article, we learned How To Use Helper And Setting In Magento 2. Following the previous tutorial, we will learn about How To Use Event in Magento 2. This is a very basic tutorial but it is very important.","rel":"","context":"In "Magento 2 Tutorials"","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"Magento 2 How To Use Event","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/04\/Magento-2-How-To-Use-Event.png?fit=750%2C445&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/04\/Magento-2-How-To-Use-Event.png?fit=750%2C445&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/04\/Magento-2-How-To-Use-Event.png?fit=750%2C445&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/04\/Magento-2-How-To-Use-Event.png?fit=750%2C445&ssl=1&resize=700%2C400 2x"},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/posts\/1546","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/users\/106"}],"replies":[{"embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/comments?post=1546"}],"version-history":[{"count":4,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/posts\/1546\/revisions"}],"predecessor-version":[{"id":1758,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/posts\/1546\/revisions\/1758"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/media\/1558"}],"wp:attachment":[{"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/media?parent=1546"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/categories?post=1546"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/tags?post=1546"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}