MYSQL syntax or query follows a particular rules and regulation which are denoted as MYSQL Syntax. Every MYSQL query starts with standard operators and ends with the semicolon.

Some of The Most Important MYSQL Commands

CREATE DATABASE - creates a new database

ALTER DATABASE - modifies a database

CREATE TABLE - creates a new table

ALTER TABLE - modifies a table

DROP TABLE - deletes a table

INSERT INTO - inserts new data into a database

SELECT - retrieves data from a database

UPDATE - updates data in a database

DELETE - deletes data from a database

CREATE INDEX - creates an index (search key)

DROP INDEX - deletes an index




If you want to add more comments to the article or you see any thing incorrect please write a comment below and we will surely get back to you.



Trending Articles


Incorrect table definition there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

Web Server vs Application Server Difference Explained

Infix To Postfix Conversion Using Stack in Javascript

SQL Overview

Binary Search Tree Insert node Implementation in Javascript

Evaluate Postfix Expressions Using Stack In Javascript

Linked List Size or Count in Javascript

MYSQL Dump - How to take mysql dump or export mysql data