Create & DROP Table in MySQL Database in Ignition from Database Query Browser | Ignition SCADA |
In this tutorial, we will learn how to create and drop tables in MySQL database using Ignition's Database Query Browser. We will start with creating a new table, defining its columns, and setting primary key. Then we will insert some data into the table and finally we will drop the table.
To create a new table, we will use the CREATE TABLE statement followed by table name and columns with their data types. We will also set the primary key using the PRIMARY KEY constraint.
To insert data into the table, we will use the INSERT INTO statement followed by the table name and values to be inserted.
✅Query to Create Table name "Ignition":
CREATE TABLE Ignition (
ID int,
Var_Name varchar(255),
Value varchar(255)
);
To drop the table, we will use the DROP TABLE statement followed by the table name.
✅Query to Delete or DROP the table name "Ignition":
DROP TABLE Ignition ;
With the help of Database Query Browser, performing these tasks becomes easier and faster.
------------------------------------------------------------
🌐Website : https://fusion-automate.super.site/
💬Telegram: https://t.me/PYLIN
📸Instagram: / fusion_automate
🗺Facebook: / papercodein
🛒Shop: https://automation-nodes.com/
💼LinkedIn: / fusion-automate
👨💻GitHub: https://github.com/papercodeIN/
📢Join this channel to get access to perks: / @fusion_automate
------------------------------------------------------------