How to write stored procedure in mysql workbench. SELECT, INSERT, UPDATE,DELETE
-
How to write stored procedure in mysql workbench. SELECT, INSERT, UPDATE,DELETE create table `admin_sales`( `sales_id` int(10) unsigned NOT NULL auto_increment, `sales_name` varchar(500) NOT NULL, `sales_father_name` varchar(500) NOT NULL, `sales_mobile_no` varchar(20) NOT NULL, `sales_date_of_birth` varchar(50) NOT NULL, `sales_date_of_joining` varchar(50) NOT NULL, `sales_present_address` varchar(500) NOT NULL, `sales_area` varchar(100) NOT NULL, `sales_city` varchar(100) NOT NULL, `sales_state` varchar(100) NOT NULL, `sales_country` varchar(500) NOT NULL, `sales_pin_code` varchar(50) NOT NULL, `submission_date` DATETIME , `modified_date` DATETIME , `modified_by` varchar(100) NOT NULL, PRIMARY KEY (`sales_id`) )
-
How to write stored procedure in mysql workbench. SELECT, INSERT, UPDATE,DELETE create table `admin_sales`( `sales_id` int(10) unsigned NOT NULL auto_increment, `sales_name` varchar(500) NOT NULL, `sales_father_name` varchar(500) NOT NULL, `sales_mobile_no` varchar(20) NOT NULL, `sales_date_of_birth` varchar(50) NOT NULL, `sales_date_of_joining` varchar(50) NOT NULL, `sales_present_address` varchar(500) NOT NULL, `sales_area` varchar(100) NOT NULL, `sales_city` varchar(100) NOT NULL, `sales_state` varchar(100) NOT NULL, `sales_country` varchar(500) NOT NULL, `sales_pin_code` varchar(50) NOT NULL, `submission_date` DATETIME , `modified_date` DATETIME , `modified_by` varchar(100) NOT NULL, PRIMARY KEY (`sales_id`) )
I'd use a text editor. But why would you want to do that anyway?
You'll never get very far if all you do is follow instructions.