Well over a decade ago, a book came out simply titled MySQL by Paul DuBois. Everyone I know learned about MySQL from this book.
I guess I mentioned in the past that I liked this book and ever since I get requests for the code from the book. I guess it isn’t available online anymore?
So, here I gather together all of the code in one place. So, I can just point people to it from now on 🙂
I normally spend so much time cranking out tutorials that I never stop to organize things. So, here I will layout a complete Web Design Tutorial.
When I say complete I really mean complete. I’ve created over 76 videos on HTML, CSS, XML, xHTML, PHP, MySQL, JavaScript, JQuery, and AJAX among other subjects.
All of the code I use in the tutorials is also free to use under the GNU license. That basically means you can do anything you like with it as long as you don’t sue me 🙂
I show you how to create a PHP / MySQL message board in this video tutorial. I start by showing you how to properly set up the database. this can be looked at as a review on how to write SQL as well.
I specifically will review how to:
In this video tutorial I cover how to do numerous things with MySQL. I show you how to:
And a bunch more…
All of the MySQL statements follow the video. If you have any questions or comments leave them below.
In the next tutorial I’ll be getting into how to use MySQL with PHP.
SQL Statements from the Video
select prod_type,pt_id from product_id;
describe manufacturer_id;describe model_numbers;
SELECT DISTINCT Manufacturer_ID.Manufacturer,Manufacturer_ID.Man_ID FROM Manufacturer_ID, Model_Numbers
WHERE ((Manufacturer_ID.Man_ID = Model_Numbers.Man_ID) AND (Model_Numbers.PT_ID = 45)) order by Manufacturer;
use customer;
show tables;
describe customer;
alter table customer add index state_id (state_id);
describe customer;
alter table customer add index phone_id(phone_id);
drop index state_id on customer;
alter table customer add UNIQUE state_id(state_id);
drop index state_id on customer;
alter table customer add index state_id (state_id);
describe customer;
alter table customer add index order_id(order_id);
create index index_name on tbl_name(columnsToIndex);
alter table customer add column comments varchar(40);
describe customer;
alter table customer change column comments comments text;
describe customer;
alter table customer rename as newTableName;
alter table customer add fulltext index (comments);
show create table customer \G
select * from customer;
describe phone;
insert into phone values (NULL, ‘412-876-7878′,’Work’);
insert into customer values(‘Sally’,’Smith’,’234 Main St’,’Happy Town’,3,15234,SHA(‘Monkey2′),2,NULL,NULL,’Really nice lady who loves cats’);
update customer set comments=’Crazy man who has 2 cats named Peekaboo and Sophie’ where cust_id=1;
insert into customer values(‘Paul’,’Smith’,’234 Main St’,’Happy Town’,3,15234,SHA(‘pw1234′),2,NULL,NULL,’Sally Smiths husband he wants a dog’);
select first_name, comments from customer where match (comments) against (‘crazy’);
insert into customer values(‘Mark’,’Marks’,’194 South St’,’Happy Town’,3,15234,SHA(‘abc1234′),3,NULL,NULL,’Craziest man I ever met. Loves dogs’);
select first_name, last_name, comments from customer where match(comments) against(‘craz*’ in boolean mode);
select first_name, last_name, comments from customer where match(comments) against(‘+craz* -cat*’ in boolean mode);
In this video tutorial I show you the many ways to insert information into MySQL. I specifically show you how to enter the information:
I then go into some other basic queries you need to understand to use MySQL. All of the code used follows the video.
In this video tutorial I explain how to create efficient tables using SQL. Specifically I’ll show you how to create Atomic Databases. A table is considered Atomic when it focuses on describing just one thing. Here is an article that goes more into this subject MySQL Atomic Tables.
Once you make all of your tables you should make sure they are Normalized. A Normalized Table is a table that follows the 3 Normalized table rules.
A while back I did a series of tutorials on MySQL. However, because you guys requested a more example heavy MySQL tutorial I’m now going to provide that.
If you want to check out the previous tutorial I have it in both text and video format here:
I especially am happy with the articles!
In this video, I go over the basics of using MySQL. For example: Creating Tables, Data Types, Entering Information, Deleting Tables and Basic MySQL commands.
If you have any questions or comments leave them below.
Here I have combined all of my website tutorial’s in to one place. If you want, you can learn how to design website’s, using this tutorial. There are 71 Free Video’s in all. This video provides link’s to all of the video’s through YouTube, or you can select the video you want to watch from the list below.
These tutorial’s and the code that belongs with them, is here on New Think Tank.
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.
[youtube]http://www.youtube.com/watch?v=WV04VAaQVRA[/youtube]
MySQL SQL Statements Tutorial 1
Here I explain what SQL is & show many statements in SQL. I explain:
Thinking About your Tables
Here is the final installment for my SQL Tutorial, and today we are going to talk about:
Welcome back to my SQL tutorial. In this article I will cover the following topics:
There are many misconceptions when it comes to databases:
In the next series of articles I will show you how to use mySQL. A completely free database server that many consider to also be the best. Heck, NASA uses MySQL.
So do you need one?
If you answer any of these questions affirmative, the answer is yes: