{"id":447,"date":"2017-02-19T14:33:46","date_gmt":"2017-02-19T14:33:46","guid":{"rendered":"https:\/\/chemicloud.com\/kb\/?post_type=article&p=447"},"modified":"2020-03-25T14:42:27","modified_gmt":"2020-03-25T14:42:27","slug":"creating-database-tables-phpmyadmin","status":"publish","type":"ht_kb","link":"https:\/\/chemicloud.com\/kb\/article\/creating-database-tables-phpmyadmin\/","title":{"rendered":"How to Create a Database Table With phpMyAdmin"},"content":{"rendered":"

In this tutorial, we’ll show you how to create a database table with phpMyAdmin. We’ll assume that you are already logged into phpMyAdmin. If you are not logged in just follow the steps in\u00a0this tutorial<\/a>\u00a0to login.<\/p>\n

1)<\/strong> First, we’ll need to select the database, in this example, we’ll use the chemiclo_demo<\/strong>\u00a0database.<\/p>\n

2)<\/strong> You’ll notice that we have a couple of test tables already created, to create a new database table just enter the name of the table in the “Name<\/strong>” field and\u00a0the number of fields you want for this table and click “Go”<\/strong>.<\/p>\n

3)<\/strong> We’ve created the table “demo” and added two columns (name and phone),\u00a0now we need to set the details of each field within this\u00a0new table and select Type<\/strong> of data the column will hold. \u00a0Some of the most \u00a0common types are:<\/p>\n

INT = <\/strong>INTEGER – used to store a number that can be written without a fractional component. (e.g. 2, 10, -44). An integer can be zero, positive, and negative.
\nCHAR<\/strong> = Characters – used to store character string value of fixed length, the maximum number is of characters is 255.
\nVARCHAR<\/strong> = Variable Length Characters – used to store variable length alphanumeric data and can store up to\u00a065,535 characters.
\nTEXT<\/strong> = used for holding large amounts of text.
\nDATE<\/strong> = Will only hold dates.
\nDATETIME<\/strong> = Will hold both a date and a time.<\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

4) We can also define the Length\/Values<\/strong> if necessary, the CHAR type will require you to specify the maximum number of characters allowed. All the other fields are\u00a0optional, however, if you need more detailed information about all the options available you can check the MySQL\u00a0Reference Manual<\/a>.<\/p>\n

 <\/p>\n

5)<\/strong> When finished, click “Save”.<\/strong>\u00a0 A message will appear indicating that your table has been created.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

In this tutorial, we’ll show you how to create a database table with phpMyAdmin. We’ll assume that you are already logged into phpMyAdmin. If you are not logged in just follow the steps in\u00a0this tutorial\u00a0to login. 1) First, we’ll need to select the database, in this example, we’ll use the…<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"ht-kb-category":[38],"ht-kb-tag":[122,124,126],"class_list":["post-447","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-mysql","ht_kb_tag-database","ht_kb_tag-phpmyadmin","ht_kb_tag-table"],"_links":{"self":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/447","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/comments?post=447"}],"version-history":[{"count":3,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/447\/revisions"}],"predecessor-version":[{"id":2131,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/447\/revisions\/2131"}],"wp:attachment":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/media?parent=447"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=447"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}