How to drop function in MySQL ?
In this article, we will learn how can we delete the created function in MySQL.
You have to use the drop function statement with the name of function without any brackets in SQL shell to drop the function in MySQL. You can use drop function statement to only delete the user defined functions. You can't delete the inbuilt function in MySQL databases.
SQL Query :
drop function getYesterdayDate ;
Output :
mysql> drop function getYesterdayDate ; Query OK, 0 rows affected (0.43 sec)
If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.
Don't forget to share this article! Help us spread the word by clicking the share button below.
We appreciate your support and are committed to providing you valuable and informative content.
We are thankful for your never ending support.
Random Code Snippet Queries: Sql
- How to create view in MySQL database
- Drop foreign id column (user_id) in MySQL
- ERROR 3780 (HY000): Referencing column 'order_id' and referenced column 'id' in foreign key constraint 'order_items_ibfk_1' are incompatible.
- How to show database tables in mysql using command line
- How to retrieve data from two tables with one SQL statement
- MySQL create procedure example
- SQL query to delete records older than 6 months
- Database connection using mySQLi with object-oriented
- How to check column exists or not in table using MySQL
- SQLSTATE[01000]: Warning: 1265 Data truncated for column 'visibility' at row 1
- Self join in mysql employee manager example
- How to check the MySQL version
- Cannot drop index 'fk_role_id': needed in a foreign key constraint
- Get create table Query from existing table in phpMyAdmin
- How to create a new table from existing table in SQL
- How to Rename column name in MySql ?
- Insert multiple rows in a single MySQL query
- Create Employee table in MySQL
- Get full name of a person in SQL using function
- Get data in random order with limit from table using mysql
- How to get yesterday's date in MySQL ?
- How to get the list of all constraints in MySQL database
- Create Index in MySQL with example
- Get comma separated ids from table using MySQL
- Clear the terminal screen in MySQL within the Windows powershell