Many times you may need to create new user for a database in MySQL. Here’s how to create user in MySQL.
Author: Sreeram Sreenivasan
How To Create Database in MySQL
How To Create Table in MySQL
Many times you may need to create table in MySQL. Here’s how to create table using MySQL create table command.
MySQL Add Foreign Key
Foreign Key helps maintain referential integrity and database relationships. Here’s how to add foreign key in MySQL.
MySQL Alter Table Column
Sometimes you may need to modify column name or data type in MySQL. Here’s how to alter table column in MySQL.
MySQL ADD COLUMN
Sometimes you may need to add column to existing table in MySQL database. Here’s how to add column in MySQL database using MySQL Add Column query.
MySQL DROP UNIQUE CONSTRAINT
Unique constraints help maintain database integrity. Here’s how to remove unique constraint in MySQL using MySQL DROP UNIQUE CONSTRAINT command.
MySQL DROP INDEX
Sometimes you may need to delete index in MySQL. Here’s how to drop index in MySQL using MySQL DROP INDEX command.
MySQL DROP FOREIGN KEY Constraint
Sometimes you may need to drop foreign key constraints in MySQL database. Here’s how to drop foreign key constraint in MySQL.
MySQL DROP DATABASE
Sometimes you need to delete database in MySQL. Here’s how to drop database in MySQL using MySQL DROP DATABASE command query.