{"id":6327,"date":"2019-08-16T08:38:10","date_gmt":"2019-08-16T08:38:10","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=6327"},"modified":"2019-08-16T08:38:10","modified_gmt":"2019-08-16T08:38:10","slug":"how-to-create-mysql-tables-in-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-mysql-tables-in-phpmyadmin\/","title":{"rendered":"How To Create MySQL Tables In phpMyAdmin?"},"content":{"rendered":"<p>Here are the steps for creating MySQL tables for a database in phpMyAdmin:<!--more--><\/p>\n<ol>\n<li>Login to the \u2018Manage MySQL Tool\u2019.<\/li>\n<li>In the section \u2013 \u2018Current MySQL Databases\u2019, click on a login name for the database in order to log into phpMyAdmin.<\/li>\n<li>Click on the link of the database on which you want to create the table. The database page will open in a new window.<\/li>\n<li>Under the section \u2018Create new table or database\u2019, enter the information mentioned below:\n<ul>\n<li><strong>Name : <\/strong>This is the name of the field<\/li>\n<li><strong>Field :<\/strong> This is the number of fields for the table<\/li>\n<\/ul>\n<\/li>\n<li>Click on \u2018Go\u2019 and the page for table management will be displayed.<\/li>\n<li>Enter the following information for each and every field in the table:\n<ul>\n<li><strong>Field : <\/strong>Enter the name of the field.<\/li>\n<li><strong>Type :<\/strong> Select the data type of the field.<\/li>\n<li><strong>Length \/ Values :<\/strong> Depending upon the type of field that you have, you might have to enter a variable here.<\/li>\n<li><strong>Collation :<\/strong> You can optionally select a column collation. A collation is basically a set of rules that compares characters in a character set.<\/li>\n<li><strong>Attributes :<\/strong> Select an attribute.<\/li>\n<li><strong>Null :<\/strong> Select the option \u2018not null\u2019 for the fields that need a value to be entered and select \u2018null\u2019 for the fields that can be left empty.<\/li>\n<li><strong>Default : <\/strong>Enter a value if you want that this field should have a default value.<\/li>\n<li><strong>Extra :<\/strong> Select if you want this field to go in increments automatically. For instance, you might want to auto-increment a particular field so that every record has a different number associated with it.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<ul>\n<li>Select if you want the field to be Primary, Index or Unique. You can view the MySQL website\u2019s documentation section for more information on this.<\/li>\n<li>If you wish to have full-text indexing and searching on the column, select the full-text checkbox. It is important to note here that the full-text index can only be utilized with My|SAM tables and they can only be created for CHAR, VARCHAR or TEXT columns.<\/li>\n<li>You can optionally enter any table comments that you want.<\/li>\n<li>Select the type of the table.<\/li>\n<li>Select a table collation optionally.<\/li>\n<li>If you wish to add additional fields, enter the number of fields to be added and then click on \u2018Go\u2019.<\/li>\n<li>When you have completed all your table settings, click on \u2018Save\u2019 for creating the tables and displaying the code for it.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here are the steps for creating MySQL tables for a database in phpMyAdmin:<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41,925],"tags":[941,942,685,616],"class_list":["post-6327","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-howtos","category-phpmyadmin","tag-create-mysql-tables","tag-create-mysql-tables-in-phpmyadmin","tag-mysql-tables","tag-phpmyadmin"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Create MySQL Tables In phpMyAdmin?<\/title>\n<meta name=\"description\" content=\"This article provides the necessay steps for creating MySQL tables for a database in phpMyAdmin.\" \/>\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.milesweb.co.uk\/hosting-faqs\/how-to-create-mysql-tables-in-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Create MySQL Tables In phpMyAdmin?\" \/>\n<meta property=\"og:description\" content=\"This article provides the necessay steps for creating MySQL tables for a database in phpMyAdmin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-mysql-tables-in-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-16T08:38:10+00:00\" \/>\n<meta name=\"author\" content=\"Ujwala\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ujwala\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-mysql-tables-in-phpmyadmin\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-mysql-tables-in-phpmyadmin\/\",\"name\":\"How To Create MySQL Tables In phpMyAdmin?\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"datePublished\":\"2019-08-16T08:38:10+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8\"},\"description\":\"This article provides the necessay steps for creating MySQL tables for a database in phpMyAdmin.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-mysql-tables-in-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-mysql-tables-in-phpmyadmin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-mysql-tables-in-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Create MySQL Tables In phpMyAdmin?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8\",\"name\":\"Ujwala\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d26ea4b9b2d83ae90b67f6bf5eefbca?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d26ea4b9b2d83ae90b67f6bf5eefbca?s=96&d=blank&r=g\",\"caption\":\"Ujwala\"},\"description\":\"My aim is to create enriching content on topics related to SEO, web hosting and social media. The idea is to elevate the readers to new levels of usability, accessibility and understanding.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/ujwala\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Create MySQL Tables In phpMyAdmin?","description":"This article provides the necessay steps for creating MySQL tables for a database in phpMyAdmin.","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.milesweb.co.uk\/hosting-faqs\/how-to-create-mysql-tables-in-phpmyadmin\/","og_locale":"en_GB","og_type":"article","og_title":"How To Create MySQL Tables In phpMyAdmin?","og_description":"This article provides the necessay steps for creating MySQL tables for a database in phpMyAdmin.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-mysql-tables-in-phpmyadmin\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2019-08-16T08:38:10+00:00","author":"Ujwala","twitter_misc":{"Written by":"Ujwala","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-mysql-tables-in-phpmyadmin\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-mysql-tables-in-phpmyadmin\/","name":"How To Create MySQL Tables In phpMyAdmin?","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"datePublished":"2019-08-16T08:38:10+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8"},"description":"This article provides the necessay steps for creating MySQL tables for a database in phpMyAdmin.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-mysql-tables-in-phpmyadmin\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-mysql-tables-in-phpmyadmin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-mysql-tables-in-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How To Create MySQL Tables In phpMyAdmin?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8","name":"Ujwala","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d26ea4b9b2d83ae90b67f6bf5eefbca?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d26ea4b9b2d83ae90b67f6bf5eefbca?s=96&d=blank&r=g","caption":"Ujwala"},"description":"My aim is to create enriching content on topics related to SEO, web hosting and social media. The idea is to elevate the readers to new levels of usability, accessibility and understanding.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/ujwala\/"}]}},"views":663,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=6327"}],"version-history":[{"count":1,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6327\/revisions"}],"predecessor-version":[{"id":6328,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6327\/revisions\/6328"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=6327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=6327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=6327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}