How To Create A New Mysql Database?

Mysql is a comprehensive database that makes it much easier to store any data that is meant to be displayed on your website

. Here's a rough guideline for setting up a new database.

Step 1- Log onto PhpMyAdmin and input the name for the database. Name it as your username followed by an underscore ( _ ) and then the name of the database. For example: username_databasename. This tells the server who owns the database.

Step 2- Make a new table for the database. Tables are where you store the data. To create the first table, select your new database from a drop down list. Name the table based on what will be stored in that particular table, like inventory or users for example. It will ask you how many columns or fields should be in the table, so choose the appropriate number. It is always possible to add new fields or delete extras, so don't worry too much about how many to make right now.

Step 3- Now you need to define the fields. It seems more complicated than it actually is. Generally, you decide one of three most common types of data that will be most relevant for the data you are storing in the table. You can always go back to edit a field if you make any mistakes. You can set up the fields to store text, numbers, dates, timestamps, and basically anything else you can think of.

These are the three basic steps for creating a new Mysql database. Beginners may have some difficulty at first but it is very easy to learn, and soon you will be a master at it. Once you complete all the steps you will have a brand new database that you can use to display data on your website.

by: padmini

POST COMMENT

110kv And Above Voltage Network Should Be Three-phase Four-wire Electric Energy Meter Active Adults Communities Offer New Plans And Prices For 2011 One24 compensation plan review – The New IRP vs. MLM The New Job Search Mindset: Every Job is Temporary Solar Cells Could Turn Freeways Into Power Plants Brand New Designer Diamond Wedding Bands Launched By Royaldesignonline Emerson Bearing Promotes Bob Piracini to Marketing Specialist to Lead New Machine Tools Division A New You With Hypnosis Downloads Improve Your Home With Solar Panels Enjoy Your New Home More with a High Definition Entertainment System Why the Hottest NFL Tickets Are New Orlean Saints Tickets Online Business Getting A New Appreciable Look From Seo Point Of View How Email Marketing Can Assist Your Business Achieve New Heights