Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/a26f9f83/public_html/articles/includes/config.php on line 159
MySQL for Beginners ? How to Create a MySQL Database > NetSparsh - Viral Content you Love & Share

MySQL for Beginners ? How to Create a MySQL Database

Whether you are an experienced web programmer or a complete novice attempting to provide data interactivity with your web site, MyQSL is an easy to use and free database solution that can allow you to store and configure data to be displayed on your web site.

The best way to create and manage a MySQL database is to download an open source (free) program called PhpMyAdmin. PHPMyAdmin allows you to manage all aspects of both your database structure and data from one easy to use interface. This tool is intended to handle the administration of MySQL over the Web.

This tool provides an interface that allows you to create and drop databases, create, drop, or alter tables, delete, edit, or add fields, execute any SQL statement, manage keys on fields, manage privileges, and import and export data into various formats. That sounds like a complicated set of activities, but the easy to use graphical tools make things quite simple and easy to understand. If you make a mistake, the software even provides instructions on where you made your error.

For a complete demo see: http://www.phpmyadmin.net/phpMyAdmin/
For documentation visit: http://www.phpmyadmin.net/home_page/docs.php

Most Linux based web hosting companies provide PhpMyAdmin as a standard feature with their packages. It is also available in a "Windows" IIS version. If your hosting provider does not already have this product installed they will often install it for you, or even allow you to install it yourself. Setup is quick and easy if you follow the step-by-step installation documentation.

Step One: Creating your new database

When you log in to your PhpMyAdmin welcome page, the first step is to enter a name for your new database in a text box provided. You can name your database anything that you wish, however if you are creating the database to use with a script or software package that you purchased somewhere, the script provider will often suggest a "preferred" database name. You should always create your database using the following format:

username_ databasename
Example: myusername_mydatabase

Your complete database name should always begin with your username followed by an underscore, then followed by the database name. This allows the server to know which user is in control of the new database, and it will also provide permission to access the database to only specific users. This also allows different users on the same server to use the same name for their own database, as you did, without interfering with your data ? that is helpful if more than one user on your server bought similar software for their own site. They can then also use the software providers "preferred" database name.

Step Two: Creating a table for your new database

After you have created a database, the next step is to create a table, or even multiple tables, for you to store data. A table is the part of your new database that actually stores data.

You create a table by selecting the database that you created from the drop box list of databases. Once a database is selected a new form appears and asks for you to create a new table.

You must decide what you want to name your table and enter that name into the name box. Try to choose a name that reflects the type of data that will be stored in the table, such as orders, users, or inventory.

You then must decide how many "fields" or columns of data that you want to store for each record. If you need for the table to store five (5) different items, such as username, users email address, users telephone number, users account number, and the users age, than you would need five (5) fields. Simply enter the number 5 in the appropriate box. Once you hit create, the system will create a table and will add those fields into the table for you. Don't worry about the number of fields you might need right now, as you can always add or delete fields later.

Step Three: Defining Fields

Once you have created your table you will be prompted to tell the database what features that you want each field to have. This looks complicated, but it's not if you select your data type from the information below. You basically have to decide between three common data types and select the best choice for storing your data. If you make a mistake you can go back and edit the field.

If the field is to be used to store numbers, here are some choices:

TINYINT ? A very small integer. The signed range is -128 to 127.
SMALLINT - A small integer. The signed range is -32768 to 32767.
MEDIUMINT - A medium-size integer. The signed range is -8388608 to 8388607.
INT - A normal-size integer. The signed range is -2147483648 to 2147483647.
BIGINT ? A very large integer.

Some other less common number options include:

FLOAT- A floating-point number.
DOUBLE ? A double-precision floating-point number.
DECIMAL - A packed exact fixed-point number.

If the field is to be used to store text or both text and numbers combined, here are some choices:

VARCHAR is for varying characters and can be up to 255 characters in length.
TEXT is a column with a maximum length of 65,535 characters ? easy to search.
BLOB is a column with a maximum length of 65,535 characters ? case-sensitive.

If the field is to be used to store dates, here are some choices:

DATE - A date.
DATETIME - date and time combination.
TIMESTAMP - useful for recording the date and time of an INSERT or UPDATE operation.
TIME - A time.

Once you have selected the data type for your fileds you will need to let the system know how many characters that you will need to store in the field.

Example: if you are storing a username, you might want to select VARCHAR as your data type and allow up to 100 characters for that field. If you are creating a User Identification number you might want to select INT and allow up to six characters ? that would allow you to have up to 999,999 users.

The last step to creating your data fields is to select any special attributes that you may find helpful. Some examples are:

Auto Increment: Auto-Increment fields are useful for assigning unique identification numbers for users, products, and customers, etc. By default, fields are incremented using number characters (like "1", "2").

Primary Key: The primary key is a data column that uniquely identifies a specific instance of that data. At least one of your fields must be a Primary Key. Username is an example of a good primary key. You do not want to have more than one individual having the same username.

Index Key: Allows you to speed up searches by designating a field as a preferred data source, especially when combining data from multiple tables.

Congratulations, once you have completed these steps you are ready to import data into your new database.

Don Beavers lives in Bryan/College Station, Texas and is an enterprise level PHP-MySQL programmer at both the Shopping Elf Shopping Guide and the Datavor Web Directory.

In The News:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at https://news.google.com/news

CBS News

Police say 3 injured, suspect dead in office shooting in Wisconsin
CBS News
MIDDLETON, Wis. -- A shooter opened fire inside a Wisconsin software company on Wednesday, wounding three people before responding officers fatally shot the assailant. Workers ran from the office building or hid inside, according to police and witnesses.
Four wounded in shooting at Wisconsin software company; suspect killed by policeChicago Tribune
4 injured, gunman killed in shooting at Wisconsin software companyAtlanta Journal Constitution
Active shooter reported at Middleton software company, multiple ambulances sentLa Crosse Tribune
Wisconsin Public Radio News -WABC-TV -Associated Press
all 3,525 news articles »

Bloomberg

Hackers Are Targeting Bitcoin With a Leaked NSA Software Tip, Report Says
Bloomberg
Hackers are illegally generating Monero, Bitcoin and other cryptocurrencies by exploiting a software flaw that was leaked from the U.S. government, according to new research, raising questions about the security of one of the fastest-growing corners of ...

and more »

Boing Boing (blog)

Bitcoin's software had a bug that could have wrecked the cryptocurrency
Boing Boing (blog)
Bitcoin's core developers discovered a vulnerability in its software that would have allowed a miner to insert a “poisoned block” in its blockhchain which would have crashed the nodes running the Bitcoin software around the world, reports Vice's ...
Bitcoin Core Developers Move to Fix Denial-of-Service Software BugCoinDesk
A Major Bug In Bitcoin Software Could Have Crashed the CurrencyMotherboard

all 13 news articles »

City official: 4 people shot, none fatally, during shooting at software company near Madison, ...
KIRO Seattle
MIDDLETON, Wis. - MIDDLETON, Wis. (AP) - City official: 4 people shot, none fatally, during shooting at software company near Madison, Wisconsin. Copyright 2018 The Associated Press. All rights reserved. This material may not be published, broadcast, ...


Splunk Software: Hot Narrative Vs. Iron Laws Of Investing
Seeking Alpha
The “Splunk Enterprise” software is relatively compelling for a host of reasons. It is easy to use, so a company doesn't need extensive professional support after installation. In addition, customers have the ability to “try before they buy” with a 60 ...

and more »

SailPoint: A High-Growth Software Company Generating Positive EBIT Margins
Seeking Alpha
SailPoint (SAIL) is a growing SaaS company which solves critical data security issues. It is focused on a niche market that was for long time served by legacy software vendors. SAIL brought in new solutions and is quickly gaining market share. SAIL has ...


PCWorld

Master Adobe's Most Popular Software With This 60+ Hour Training Bootcamp ($39)
PCWorld
When it comes to creative software, Adobe is king. With programs like Photoshop, Premiere Pro, and Lightroom being used by photographers, designers, and editors across the globe, you should expect to master these tools if you hope to make it as a ...

and more »

IEEE Spectrum

Carnegie Mellon is Saving Old Software from Oblivion
IEEE Spectrum
In early 2010, Harvard economists Carmen Reinhart and Kenneth Rogoff published an analysis of economic data from many countries and concluded that when debt levels exceed 90 percent of gross national product, a nation's economic growth is ...


TechCrunch

Google's parental control software Family Link expands to teens
TechCrunch
Google's parental control software for mobile devices, Family Link, will now help parents of teenagers, too. The company announced this morning the addition of new features aimed at parents of children over the age of 13. Perhaps the most controversial ...
Age requirements on Google Accounts - Google Account HelpGoogle
Helping more families set digital ground rules with Family Link - The KeywordThe Keyword

all 52 news articles »

Colorado Springs software company's expansion into new markets a huge opportunity
Colorado Springs Gazette
The new software's key feature will be linking its customers' departments so they can work together more effectively to solve “real business problems,” said Steve Rodda, the company's chief product officer. The human resources software is just the ...

Google News

Microsoft Great Plains Integration with Microsoft Access ? Overview for Developer

... Read More

Microsoft Great Plains - Typical Problems And Fixes ? Overview For IT Administrators

How to delete the user? This is the first problem... Read More

Importance of Coding Standards

Programming Help for BeginnersWe write programs to instruct computers. When... Read More

How to Choose the Right Accounting Software for Your Business

With any good luck and a good amount of hard... Read More

Causes of ERP Failures

ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More

Microsoft Great Plains Nationwide Remote Support

ERP Consulting industry is on the way to serve clients... Read More

Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation

At the end of XX century, in the late 1990th... Read More

Theres Gold in Your Websites Server Log

Many Webmasters have never bothered to view their website's server... Read More

Free Microsoft Word Online Training Tutorial Resources

Microsoft Word is one of the most popular office applications... Read More

Software Companies: Generate New Revenue Streams and Decrease Costs with Custom e-Learning Content

It's no secret that software companies operate in a very... Read More

Microsoft Great Plains Beverage Production & Distribution ? Implementation & Customization Highlight

Microsoft Business Solutions Great Plains has many years of successful... Read More

Unofficial Windows 98 SE Service Pack 2.0 RC2

Microsoft has never released a service pack for Windows98 SE,... Read More

10 Ways to Learn a Software

Following tips help you to learn a software in lesser... Read More

QuarkXpress Tips: How to Move Content Between Print and Web Layouts

Since its release in 1987, QuarkXpress had made an immediate... Read More

Crystal Reports for Microsoft Great Plains ? Overview for Developer

Microsoft Great Plains is main accounting / ERP application... Read More

Microsoft Business Solutions - Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL

Microsoft bought Navision, Denmark based software development company, along with... Read More

Put Some Pizazz in Your Software Arsenal

The software giants don't do everything and don't always produce... Read More

Microsoft Great Plains GL: General Ledger ? Overview For Consultant

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Hear It in Digits

Music downloads are off the charts! We're listening to digital... Read More

Microsoft Great Plains Customization and Development ? Overview for Programmer

When Great Plains Software was designing and developing Great Plains... Read More

A Simple Computer Software Definition

What is Software?Software is a set of instruction written to... Read More

Microsoft Great Plains: carpet, textile, fabric, felt distributor ? implementation overview

In this small article we will show you the possible... Read More

Microsoft CRM ? Consulting in the Post-Recession Time

New post-recession era has new features, which didn't exist in... Read More

The Tools and Features of Adobe Photoshop

Adobe Photoshop is one of the world's leading graphics editing... Read More

10 Things You Could be Using Photoshop For, But Probably Arent

Most people don't use Photoshop to its fullest capabilities. Here... Read More