Tuesday, April 23, 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 Syntax & Strategies
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 Syntax & Strategies
Code is not Very Difficult
The MySQL code is very human readable, as opposed to hard programming languages like C or C++. There are very little special characters and symbols that are required to create a MySQL query and most queries consist entirely of English words.

The best way to learn is through direct examples.

Reserved Keywords
There are many keywords in MySQL and a good programming habit when using ANY of these words is to capitalize them. This helps draw them out from the rest of the code and makes the codes much easier to read. Below is an example MySQL query written in ASP or PHP that retrieves all the data from a MySQL table named "alarms".

In php
$result = mysql_query("SELECT * FROM alarms")

In ASP
sqlQRY = "SELECT * FROM alarms"

You can see easily that "SELECT" and "FROM" are the MySQL keywords that were used in this query.

Don't memorize Reserved MySQL Words
You don't need to memorize Reserved MySQL Words. Just check out the List of Reserved MySQL Words. You could probably program relentlessly in MySQL for years without ever using all of the MySQL keywords.





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.