Tag Archives | sql statements

MySql Tutorial for Beginners Part 4 – CREATE Statement MySql

Welcome to MySQL Tutorial for Beginners part 4. Today we will create a database. And Create some Data.We are going to start using MySQL commands. Before we start we need to have some sort of Data.We are going to create some sample data. By now you should have required Software and Utilities for MySQL Installed on your PC. If not check earlier MySQL Tutorial for Beginners part 3.

MySQL Tutorial for beginners

MySQL Tutorial for beginners

Start MySQL Community Server,Toad or Sequel Pro on you computer. Then we are going to create a new connection to database server. Follow the steps below:

Connecting Toad to MySQL community server:
For Toad go to File > New > Connection. Then you will see a new connection window like the picture below.
Toad New Connection

From the Connection Type select TCP. You can select connection type such as TCP, SSL, SSH, HTTP Tunnel . We will use TCP connection.

Here are the information to make new connection using Toad for MySQL.
Connection Type: TCP
Host :  localhost
User :  root
Password: Type in your Password
Database: test

If you want to save the connection fill out the details at the bottom of the window.
Continue Reading →

Continue Reading >>

MySQL Command Types MySql Tutorial for Beginners Part 2

Few Days ago we started MySQL for beginners tutorial. That was a quick intro about What is a database, What is Database table , What is SQL and Why do we use SQL? Today we will cover What are the types of MySQL database commands. Some readers asked why we are writing on MySQL Basics? We have readers learning MySQL for school or Job, We are Starting from Scratch on MySQL tutorial for beginners.You can Follow us on twitter to get latest updates on MySQL tutorial for beginners. Here is our Twitter

MySQL

Types Of SQL Commands / Statements

SQL commands / statements are divided into few categories. Such as Data definition language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), Transaction Control Commands.

1. Data Definition Language (DDL):  This SQL statements are used to define database schema such as the creation or deletion of a table. Here are some examples:

  • CREATE : This statement is used for creating objects in Database.
  • DROP: This statement is used for deleting objects from Database.
  • RENAME : This statement is used for renaming objects from Database.
  • ALTER : This statement is used for altering structure of the Database.
  • TRUNCATE : This statement removes all record from a table.TRUNCATE removes all rows from a table immediately after execution .


2. Data Manipulation Language (DML): This statement are used for manipulating data from objects in a Relational Database system. Here are some Examples bellow:

  • SELECT : SELECT is one of the most Used Command in SQL. To Retrieve from Data from Database we use SELECT statement.
  • INSERT : INSERT statement is used for inserting data into Database.
  • DELETE : This statement is used to remove rows from a table. You need to be extra with this command.After using a DELETE operation you need to COMMIT the transaction to make the change permanent.
  • UPDATE : This statement updates existing data within a table.


Continue Reading →

Continue Reading >>