This is the part 3 and final part of these three series of basic MySQL commands; even though, there are many other commands and this is a topic that could be covered more in depth, I decided to kind of compile of what I think are the more fundamentals and used command for database manipulation in MySQL, in this part will cover:

• How to use the UPDATE and REPLACE commands to modify existing records
• How to use the DELETE command to remove records Read the rest of this entry »

This is the continuation of “MySQL basic commands I”, in this part we’ll cover:

• How to use the SELECT command to retrieve records (continuation)
• How to use basic functions, the WHERE clause, and the GROUP BY clause
• How to select from multiple tables, using JOIN Read the rest of this entry »

In this tutorial, we will take a look at basics SQL commands needed to manipulate your database tables, this is the first part of a three part tutorial, as I would not be able to cover as much as I want in just one part. For the examples here I assume you are able to issue commands through the MySQL monitor on Windows or Linux, in my case I use MySQL Query Analyzer in Windows.

In this first part will cover:

• The basic MySQL data types
• How to use the CREATE TABLE command to create a table
• How to use the INSERT command to enter records
• How to use the SELECT command to retrieve records Read the rest of this entry »