Wednesday, April 24, 2024
Useful Resources for Brilliant Manufacturing, Operational & Industrial Intelligence Technology Enthusiasts!

Automation, Control & Plant Intelligence - Articles, Analysis, Reviews, Interviews & Views

MySQL made Easy for Engineers / Technologists

Administion of MySQL
MySQL for Engineers / Technologists

MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing and managing content in a database. It is most noted for its quick processing, proven reliability, ease and flexibility of use.

MySQL is an open-source relational database management system. Its name is a combination of "My", the name of co-founder Michael Widenius's daughter, and "SQL", the abbreviation for Structured Query Language.

Administion of MySQL
Here are different options you have available for administering your MySQL service after it is successfully installed.

MySQL - Command Line
If you are an old programmer that has no need for a MySQL GUI (graphical user interface) then you can simply use any command line interface to execute MySQL queries.

If you installed MySQL on Microsoft Windows operating system you can reach the command line by going to the Start Menu and choose "Run...". Type the keyword "cmd" into the text field and press Enter to launch Window's command line interface.

MySQL - GUI
With so many free MySQL administration tools available, many developers favor these free Graphical User Interfaces over the command line. The popular options include:

  • MySQL Administrator - A powerful tool developed by the folks at MySQL.com


  • SQLyog - My favourite. You can download free for unlimited basic use. For advance use like backups, you need to upgrade.
    (For more information Download SQLyog.com)


  • Navicat - A purchasable MySQL admin tools for Windows, Mac and Linux. You can download and use free for 30 days only.
    (For more information Download Navicat.com)


  • phpMyAdmin - A popular web interface that is included with almost every type of Shared, Virtual or Dedicated hosting solution.
    (For more information Download phpMyAdmin.com)
    •




    MySQL
    MADE EASY ....



    MySQL - Basics
  • MySQL - Basic
  • MySQL - Pronounced AS
  • MySQL - Introduction
  • MySQL - Setup
  • MySQL - Cost
  • MySQL - Admin
  • MySQL - Syntax
  • MySQL - Database
  • MySQL - Connect
  • MySQL - Create Database
  • MySQL - Create Tables
  • MySQL - Insert
  • MySQL - Query
  • MySQL - Fetch Array
  • MySQL - Select
  • MySQL - Where
  • MySQL - Order By
  • MySQL - Join
  • MySQL - Left Join
  • MySQL - Update
  • MySQL - Delete
  • MySQL - Backup


    • MySQL - Aggregate Functions
  • MySQL - Count
  • MySQL - SUM
  • MySQL - Avg
  • MySQL - Max
  • MySQL - Min
  • MySQL - Group By


    • MySQL - Advanced Topics
  • MySQL - SQL Injection
  • MySQL - Date
  • MySQL - Time
  • MySQL - Index
    • Free OPC Clients   /   Free OPC Servers   /   Free OPC Utilities

    OPC Foundation owns all OPC trademarks including the OPC logo used throughout this site. Most of information in OPC Knowledge Base is from OPC foundation.
    Free Automation Stuff This information made available on Automation Media, are provided "as is" without any representation or warranty, express or implied, of any kind, including, but not limited to, warranties of merchantability, noninfringement, or fitness for any particular purpose. Automation Meida makes no warranty or representation regarding, and does not endorse, any linked Web sites or the information appearing thereon or any of the products or services described thereon.