Thursday, November 21, 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

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

Introduction of MySQL
Where to Use?
MySQL is an open source relational database management system (RDBMS) that uses Structured Query Language (SQL), the most popular language for adding, accessing, and processing data in a database.

Where it Works Best?
MySQL is noted mainly for its speed, reliability, and flexibility. Most agree, however, that it works best when managing content and not executing transactions.



MySQL is the most popular open source database server in existence. On top of that, it is very commonly used in conjunction with ASP and PHP scripts to create dynamic and powerful server side applications.

Why some criticize on MySQL?
MySQL has been criticized in the past because it does not have all the features of other DataBase Management Systems. However, MySQL continues to improve significantly, with each major upgrade, and has great popularity because of these improvements.

Does Industrial Software use it?
MySQL getting popularity in Industrial Software as it help to lower down cost of Industrial software. Many companies are using it. e.g. Win911 - Remote Alarm Notification Software.


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.