Tag Archives | mysql tutorial

Import sample database using MySQL workbench – MySQL Tutorial Part 6

This tutorial is about how to import sample database in MySQL Workbench. And how to make new connection on Toad for MySQL after creating database on MySQL. If you are new here then you need to read the tutorials from the links below.

MySQL Tutorial for beginners

MySQL Tutorial for beginners

********************************************************
We started MySQL Beginers Tutorial

MySQL Beginners Tutorial Introduction Part 1

MySQL Command Types MySql Tutorial for Beginners Part 2

Some Tools and Utilities for MySQL Tutorial for Beginners Part 3

MySql Tutorial for Beginners Part 4 – CREATE Statement

MySQL Naming Guidelines -MySQL Tutorial Part 5

*********************************************************

To create / Import sample database, You will need to download Sample Employee Database For MySQL.
Continue Reading →

Tags for the article:

    www bytetips com import-sample-database-using-mysql-workbench
Continue Reading >>

MySQL Naming Guidelines -MySQL Tutorial Part 5

In this Tutorial will learn  about MySQL table and column Naming Guidelines for database Objects. This is also known as MySQL naming convention or MySQL naming standards. In my last post MySql Tutorial for Beginners Part 4 – CREATE Statement i wrote a little about Create statement and Naming standards for MySQL. One of the reader asked me if i can write little more about MySQL Naming Guidelines. So here we go…

MySQL Tutorial for beginners

MySQL Naming Guidelines -MySQL Tutorial Part 5

Here are some rules and guidelines to follow while coding MySQL for Standards and Naming Conventions:
Continue Reading →

Continue Reading >>

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 >>