Get Started with phpMyAdmin & SQL Go into phpMyAdmin! You should have a a few new tables under your test database. Click on the States table to select it. Open that table up and look at the structure and the data. Then take a look at the SQL tab while that table is selected.  It…

The WHERE clause is used to filter data so that we can retrieve only those records which meet a certain condition. The basic syntax is as follows: SELECT column1, column2,… FROM table_name WHERE condition; Basic WHERE Clause Let’s say we want to find all the members who are taking Spanish.  We would use this: SELECT…

Before we start learning more about SQL,  let’s add some more columns and data to our member table so that we can test this out. Updating Your member Table We are going to add a language field to keep track of which language our members are currently studying. Go to myPHPAdmin and click on the…

The key element of SQL is the SELECT statement.  This is the statement we use to get data returned from the database. There are two basic parts that are required to make this statement work:  SELECT and FROM.   They have to be in that order as well. SELECT – which fields or columns to grab…

Now the fun part.  Right now you should have the following members table that we created as part of the Using phpMyAdmin to Create Tables lesson.  If you don’t – go make that!   It should look like this: You should also have the tables you created for the Homework: Creating Tables.  We are going to do…

Let’s talk about the other tools that phpMyAdmin >has for managing our database.  We’ve already talked about Browse and Insert – but let’s talk about the others for just a minute. Structure Structure:  allows you to see the fields that make up the table.  You can  view the structure and make changes including adding and…

Create the table structure from either the lesson, “The Problem Normalization Solves” or from your diagram from last year. Here’s the solution to the homework: After you have created the structure, create at least 5 rows of data per table.

Make sure you are in – go to yoursite/cpanel and log in if you are not already there. You can access phpMyAdmin two ways – either click on Database in the gray left hand menu and then click on phpMyAdmin OR Scroll down until you find the Databases box and click on phpMyAdmin Finding Your…

You guessed it.  Create a database. First, most web servers attach a prefix which matches your domain name. For this website – they all start with labcatsc. Secondly, think of a good logical name for your database – you can call it table or data if you want.  Or name it after that website you…

Enough of all this cpanel nonsense.  I want to make a database!!!  Now…. To Create a Database Go to yoursite/cpanel and log in with your username and password. You will see the cpanel displayed with all sorts of fun options. Scroll down until you find the Databases box and click on MySQL Databases. This screen…