MySQL Archives - Page 11 of 20

How To Create Stored Procedure in MySQL

Stored procedure allows you to save and call SQL queries. Here’s how to create stored procedure in MySQL.

Many times you may need to create new user for a database in MySQL. Here’s how to create user in MySQL.

Here are the steps on how to create database in MySQL for your business.

Many times you may need to create table in MySQL. Here’s how to create table using MySQL create table command.

Foreign Key helps maintain referential integrity and database relationships. Here’s how to add foreign key in MySQL.

Sometimes you may need to modify column name or data type in MySQL. Here’s how to alter table column in MySQL.

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.

Unique constraints help maintain database integrity. Here’s how to remove unique constraint in MySQL using MySQL DROP UNIQUE CONSTRAINT command.

Sometimes you may need to delete index in MySQL. Here’s how to drop index in MySQL using MySQL DROP INDEX command.

Sometimes you may need to drop foreign key constraints in MySQL database. Here’s how to drop foreign key constraint in MySQL.