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

MySQL Database
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.

MySQL Database
A MySQL database is very simple and nothing in itself. In other words, MySQL database is a way of organizing a Group of Tables.

Create Your First Database
Most web hosts do not allow to create a database directly through ASP or PHP script. We need to call them and request to create a new database. Sometime they require that you use the MySQL Administration tools on the web host control panel to create a databases.

Tip
Download SQLYog, a MySQL Client Software (free utility) and install on your personal computer. You can use it to connect to either MySQL database on your local computer or direclty to your WebHosting Server.

For connecting your web hosting company, you need to call and ask Server IP address.

Create a database and assign a new user to this database.





Overall and typically you need to know following information:

  • Server: localhost or IP address of server
  • Database: e.g. alarms
  • Table: e.g. ProcessValues
  • Username: e.g. Admin
  • Password: e.g. AnyPW


    • The Server is the name of the server we want to connect to. If your MySQL database is installed on your local computer, then use localhost. If your MySQL database is installed on remote computer then then use IP address or remote URL to connect server.

    Before moving next...
  • You should have created a new database.
  • Assigned a user to it.
  • ...and NOT created a table yet.


    • If you are Okay so far then continue the tutorial. You will be making our first table in an upcoming lessons.


    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.