faqts : Computers : Databases : MySQL : Utility : PHPMyAdmin

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

2 of 8 people (25%) answered Yes
Recently 2 of 8 people (25%) answered Yes

Entry

Database: MySql: GUI: PHPMyAdmin: Table: Create: How to: How to create a table in PHPMyAdmin?

May 6th, 2005 04:39
Knud van Eeden,


----------------------------------------------------------------------
--- Knud van Eeden --- 06 May 2005 - 06:40 pm ------------------------

Database: MySql: GUI: PHPMyAdmin: Table: Create: How to: How to create 
a table in PHPMyAdmin?

---

Steps: Overview:

 1. -Start MySql

 2. -Start PHPMyAdmin

 3. -Select from list your database
     and click on that databasename

      e.g.

       mydatabase

 4. -Give the data of that table

     1. -Fill in the name of your table
         in the field
         'Create a new table on database <your database name>'

     2. -Choose the total amount of fields

          e.g.

           2

          (as usually 1 field for the primary key,
           and 1 field for the description, thus 2 fields
           totally minimally)

     3. -Click button 'Go'

 5. -Insert some data

     1. -Select tab 'Insert'

     2. -Fill in the data for that fields

     3. -Continue to input more rows

         1. -Possibly enable radio button
             'Insert another new row'

     4. -Click button 'Go'

 6. -To export that table

     -Select tab 'Export'

     -Click button 'Go'

     -Copy/paste the result

---
---

Internet: see also:

---

Database: MySql: GUI: PHPMyAdmin: Link: Overview: Can you give an 
overview of links?
http://www.faqts.com/knowledge_base/view.phtml/aid/35971/fid/1806

----------------------------------------------------------------------