How To Add A Database To A Website

Download Commodity

Download Article

SQL Server databases are some of the most common databases in use, cheers in part to how easy it is to create and maintain them. With a free graphical user interface (GUI) program such every bit SQL Server Management, you don't demand to worry about fumbling around with the control line. See Step 1 beneath to create a database and start entering your information in just a few minutes.

Steps

1
Install the SQL Server Direction Studio software. This software is bachelor for free from Microsoft, and allows you to connect to and manage your SQL server from a graphical interface instead of having to apply the command line.
- In order to connect to a remote instance of an SQL server, you lot will need this or similar software.
- Mac users tin can use open-source programs such every bit DbVisualizer or SQuirreL SQL. The interfaces will be different only the same full general principles utilize.^[1]
- To learn how to create databases using command-line tools, see this guide.
2
Start up SQL Server Management Studio. When you first starting time the program, you will be asked what server you would like to connect to. If you lot already have a server upwards and running, and have the permissions necessary to connect to it, yous can enter the server address and authentication information. If y'all want to create a local database, ready the Database Proper noun to . and the authentication blazon to "Windows Authentication".
- Click Connect to go along.
Advertisement
3

Locate the Database folder. Afterwards the connection to the server, either local or remote, is made, the Object Explorer window will open on the left side of the screen. At the top of the Object Explorer tree will be the server you are connected to. if information technology is not expanded, click the "+" icon next to information technology. Located the Databases folder.^[two]
iv
Create a new database. Right-click on the Databases folder and select "New Database...". A window will appear, allowing yous to configure the database before creating information technology. Give the database a name that volition aid yous identify it. Most users tin can leave the remainder of the settings at their default.^[iii]
- Y'all will note that as you type the database name, 2 additional files will be created automatically: the Data and the Log file. The data file houses all of the data in your database, while the log file tracks changes to the database.
- Click OK to create the database. You will come across your new database announced in the expanded Database folder. Information technology will have a cylinder icon.
5
Create a table. A database tin but shop information if yous create a construction for that data. A table holds the information that you lot enter into your database, and you will need to create information technology before you tin continue. Expand the new database in your Database folder, and right-click on the Tables folder and select "New Table...".
- Windows volition open on the rest of the screen which will let yous to manipulate your new table.
six
Create the Primary Key. It is highly recommended that y'all create a Primary Central equally the first column on your table. This acts as an ID number, or record number, that will allow you to easily think these entries later. To create this, enter "ID" in the Column Proper name field, type int into the Data Type field, and uncheck the "Let Nulls." Click the Key icon in the toolbar to ready this column equally the Primary Key.
- You don't want to allow null values because you always desire the entry to be at least "one". If you allow nulls, your first entry will be "0".
- In the Column Backdrop window, scroll downward until you lot notice the Identity Specification option. Expand it and fix "(ls Identity)" to "Yes". This will automatically increase the value of the ID column for each entry, finer automatically numbering each new entry.
seven

Understand how tables are structured. Tables are composed of fields or columns. Each column represents one aspect of a database entry. For example, if you were creating a database of employees, you might accept a "FirstName" column, a "LastName" column, an "Address" column, and a "PhoneNumber" cavalcade.
8
Create the rest of your columns. When yous finish filling out the fields for the Primary Key, you will observe that new fields appear underneath it. These allow you to enter in your next column. Fill out the fields equally you encounter fit, and ensure that you option the right information blazon for the data that volition be entered in that column:
- nchar(#) - This is the data type you should use for text, such as names, addresses, etc. The number in parentheses is the maximum number of characters immune for this field. Setting a limit ensures that your database size stays manageable. Telephone numbers should exist stored with this format, every bit you don't perform mathematical functions on them.
- int - This is for whole numbers, and is typically used in the ID field.
- decimal(ten,y) - This will store numbers in decimal course, and the numbers within the parentheses denote the total number of digits and the number digits following the decimal, respectively. For example decimal(6,2) would store numbers as 0000.00.
9

Save your table. When yous are finished creating your columns, you will need to save the table earlier entering information. Click the Save icon in the toolbar, and then enter in a name for the tabular array. Naming your table in a style that helps you recognize the contents is advisable, especially for larger databases with multiple tables.
10
Add data to your table. In one case yous've saved your table, you tin can begin calculation data to information technology. Expand the Tables folder in the Object Explorer window. If your new table is not listed, right-click on the Tables folder and select Refresh. Right-click on the tabular array and select "Edit Top 200 Rows".^[4]
- The center window will brandish fields for y'all to begin entering information. Your ID field will be filled automatically, so you tin ignore it right now. Fill out the data for the rest of the fields. When you click on the next row, you will meet the ID field in the first row fill automatically.
- Continue this procedure until you've entered all the data you need.
11
Execute the tabular array to save the data. Click the Execute SQL button on the toolbar when yous are finished entering the information to save information technology to the table. The SQL server will run in the background, parsing all of the data into the columns you created. The button looks like a cherry-red exclamation point. You tin can too press Ctrl+R to execute as well.
- If there are any errors, you will be shown which entries are filled out incorrectly before the table can be executed.
12

Query your information. At this indicate, your database has been created. You can create as many tables as you need within each database (in that location is a limit, but virtually users will not need to worry about that unless they are working on enterprise-level databases). Y'all tin can now query your data for reports or whatsoever other administrative purposes. See this guide for detailed data on running queries.

Advert

Add together New Question

Question

Under the terms of hardware, how do you build a server?

A server is just like any other computer. Its hardware is only more suited for the rigours of a server environment and server tasks. Thus, server hardware may take lots of drives, defended network cards, redundant power supplies, and lots of RAM.
Question

Do laptops have the SQL software?

Usually not preinstalled, practice a search for "Microsoft SSMS" and download, it's about a 700 mb file for the newest version.
Question

How exercise I access a new SQL database remotely from a newly built desktop?

Information technology will works exactly the aforementioned. Unless you program to buff it upwardly after, yous should do these verbal tasks.
Question

Can I just do this in code with the create table selection?

Yes, all the same you will cease upwardly with some very big dictionaries/dataframes that will quickly go challenging to update and edit.
Question

How can i connect my database to php file?

For this y'all need: Your favourite IDE (mine is PHPStorm). Some (pocket-size) knowledge of PHP. Some knowledge of XAMPP. A (localhost) database. Before you do the post-obit steps, enable your local server with XAMPP (if you don't know how, look for a tutorial. 1. make a new file, called connection.php. 2. make, inside the tags, a variable, $link. 3. declare the $link like this: $link = mysqli_connect("DB_HOST", "DB_USERNAME", "DB_PASSWORD", "DB_NAME"); (e.chiliad. $link = mysqli_connect("localhost", "root", "", "logindb"); 4. Your database is connected. if you want to cheque it, go to [localhost:/connection.php].

Ask a Question

200 characters left

Include your electronic mail accost to get a bulletin when this question is answered.

Submit

Video

Thank you for submitting a tip for review!

About This Article

Article Summary X

1. Install SQL Server Management Studio.
ii. Select a server and click Connect.
iii. Click + on the database server.
4. Click New Database.
five. Enter a database name and click OK.
6. Right-click the database and select New Table.
7. Create the Principal (int) primal in the beginning row.

Did this summary help you?

Thanks to all authors for creating a folio that has been read 902,006 times.

Is this commodity up to date?