MySQL for beginners – How to create a MySQL Database

Written by Don Beavers

Continued from page 1

Step Three: Defining Fields

Once you have created your table you will be prompted to tellrepparttar database what features that you want each field to have. This looks complicated, but it’s not if you select your data type fromrepparttar 141627 information below. You basically have to decide between three common data types and selectrepparttar 141628 best choice for storing your data. If you make a mistake you can go back and editrepparttar 141629 field.

Ifrepparttar 141630 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.

Ifrepparttar 141631 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.

Ifrepparttar 141632 field is to be used to store dates, here are some choices:

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

Once you have selectedrepparttar 141634 data type for your fileds you will need to letrepparttar 141635 system know how many characters that you will need to store inrepparttar 141636 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 havingrepparttar 141637 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, Texas and is an enterprise level PHP-MySQL programmer at Datavor Web Directory and at the Shopping Elf Directory .

Broadband Tools To Measure System Performance And More

Written by Michael Lemm

Continued from page 1

Note: Some firewalls might log a potential attack from their server if you choose to testrepparttar security of your system since they are testing for vulnerabilities.

* SG Speed Test

A quick download speed test to estimate your connection speed atrepparttar 141365 time.

* SG Network Tools

The SG Network tools section includes many common network tools such as PING, TRACEROUTE, WHOIS, etc.

* SG Bits/Bytes Conversion Calculator

The Bits/Bytes calculator is a useful tool for quickly converting bits/bytes, etc. It takes into considerationrepparttar 141366 different conventons while calculating data communication rates and storage space.

* SG RWIN/BDP Calculator

The RWIN/BDP calculator can be used to estimate TCP Window values, based onrepparttar 141367 Bandwidth*Delay Product (BDP for short). It can also calculate maximum bandwidth based on RWIN and latency values, and perform a number of different conversions as well.

Drop in and test them out (no pun intended). Atrepparttar 141368 very least you may learn something about your current system needs or performance.

Michael is the owner of FreedomFire Communications and ....delivering choices to both residential and business consumers worldwide for voice and data broadband services. Michael also authors BroadBand Nation where you're always welcome to to drop in and catch up on the latest BroadBand news, tips, and ramblings for the masses.

    <Back to Page 1 © 2005
Terms of Use