In this web design and programming video tutorial I will review a lot of what you have been taught previously. I’ll review many topics by showing you how to make drop down boxes that are populated from data stored in a database. If you don’t completely understand everything don’t worry...
In this video tutorial I cover how to do numerous things with MySQL. I show you how to:
Join Data in Tables
Create Indexes
Delete Indexes
Change Column Data Types
Change Table Names
Create Full Text Indexes
Change Data in Columns
Perform Full Text Searches
And a bunch more…
All of the MySQL...
In this video tutorial I show you how to do many things with MySQL. I cover the following MySQL Statements in depth:
SELECT
WHERE
ORDER BY
BETWEEN
IN
LIKE
REGEXP
AS
I also explain how to perform conditional searches and use Regular Expressions. If you have any questions or comments leave them...
In this video tutorial I show you the many ways to insert information into MySQL. I specifically show you how to enter the information:
Directly through the MySQL shell
Through PHP code
From a CSV file
I then go into some other basic queries you need to understand to use MySQL. All of the code used follows...
Posted by
admin on Apr 21, 2010 in
Statements SQL |
2 comments
Today I present the whole SQL Statements Tutorial Video Series. I did my best to make sure, after you watch this series of videos, you will be an expert at programming with SQL. Please leave any comments and questions below.
MySQL SQL Statements Tutorial 1
Here I explain what SQL is & show many...
Posted by
admin on Apr 16, 2010 in
Statements SQL |
2 comments
Thinking About your Tables
Here is the final installment for my SQL Tutorial, and today we are going to talk about:
Atomic Data
Normalized Tables
Keys
Working with Multiple Tables
JOIN Statements
UNION Statements
With a few tips thrown in…
Atomic Data & Table Templating
As your database increases...
Posted by
admin on Apr 15, 2010 in
Statements SQL |
0 comments
Welcome back to my SQL tutorial. In this article I will cover the following topics:
The LIKE Statement : How to Search your Data
The REGEXP Statement : Super Search Tool
The IN Statement : Clean up your Code
The NOT Statement : Learn to Act Negatively
The DELETE Statement : How to Delete Rows of Data
The...
There are many misconceptions when it comes to databases:
Some people think they are hard to develop (Not True)
Many people think they are expensive (There are Free Versions Available)
Most people don’t know how to start using them (Your in the right place)
In the next series of articles I will show you...
