Caller ID Software

caller id softwareYES Tele.com, Caller ID Software Experts

Creating an SQL Database and Table


Click Here to go back to Previous Page


Creating an SQL Database and Table

These instructions are for a Linux Web Server.

This example uses cPanel Version 11.24.

In the control panel database area there should be a few choices.
The two we are interested in are "MySQL Databases" and "phpMyAdmin".

First Select MySQL Databases

caller id sql step 1


You may or may not already have any databases.
We want to create a new database called Phone (can be given any name you prefer).

caller id sql step 2


Just type "Phone" in the New Database: field and
Click "Create Database" button.

caller id sql step 3


This example Web site is named patrick.
Database tables are named website_databaseName.
The new database in this example is patrick_Phone.

caller id sql step 4


Click the Home Link to go back to the Control Panel.

Select "phpMyAdmin"

caller id sql step 1


In the upper left hand corner is a list of databases.
If I click patrick_Phone(0),

caller id sql step 5


I get the Create new table form because this is a new database with no tables yet.

Click the SQL tab.

caller id sql step 6


This is where we put the Query to Create the "Calls" table.

caller id sql step 7


Now paste the SQL Query from the previous page

Click "Go"

caller id sql step 8


This shows the results "Your SQL query has been executed successfully".

caller id sql step 9

At this point the table is created and we are done.

OR

Click the database link. In this example "patrick_Phone(1)"


Click the "Structure" icon in the Calls Table row. (2nd icon)

caller id sql step 10


This shows the complete structure of the Calls table in the Phone database.

caller id sql step 11


Click Here to go back to Previous Page