Creating Databases and tables from phpmyadmin in wamp

Creating Databases and tables from phpmyadmin in wamp

 After installing wamp server run itOpen phpmyadmin
Enter database name to create new databaseClick on create


MySQL-PHPMYADMIN












MySQL-PHPMYADMIN


After clicking on create,database is created and for creating table you have to enter name and number of fields of the table















Then click on Go buttonThen for given number  of fields you have to specify the attributes
In this example I entered 2 in number of fields so I have to give details about 2 fields as follows






MySQL-PHPMYADMIN





 After  entering the details click on save to create a table then the below screen will be displayed






MySQL-PHPMYADMIN

For inserting rows in the table click on insert symbol shown below


MySQL-PHPMYADMIN








Enter values for columns then click on Go


MySQL-PHPMYADMIN








If you want to check whether  the  table is created or not then go for MySQL console.





Share on Google Plus
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment