MySQL Archives - Page 10 of 20

How To Execute Stored Procedure In MySQL Workbench

Sometimes you may need to run stored procedure in MySQL Workbench. Here’s how to execute stored procedure in MySQL workbench.

Sometimes you may need to find duplicate rows in table or find duplicate values. Here’s how to get duplicate records in MySQL.

Sometimes you may need to make column unique in MySQL. Here’s how to add unique constraint in MySQL.

Sometimes you may need to rename column in MySQL or change column name. Here’s how to change column name in MySQL query.

Sometimes you may need to clone tables in MySQL or copy data from one table to another. Here’s how to duplicate table in MySQL.

Sometimes you may need to create stored procedure with parameters in MySQL. Here’s how to create stored procedures with parameters in MySQL.

Sometimes you may need to create composite primary key in MySQL. Here’s how to create composite primary key in MySQL.

Sometimes you may need to delete all rows in a table in MySQL. Here’s how to truncate table in MySQL.

Sometimes you may need to drop MySQL view. Here’s how to drop view in MySQL using MySQL DROP VIEW command.

July 6, 2020 Sreeram Sreenivasan MySQL

MySQL Indexes speed up SQL queries and lookups. Here’s how to create index in MySQL to improve database performance.