P1-S22|
@hb_mulesoftTechworld
DB Connector task
::
CREATE A TABLE technologies IN MYSQL DB
CREATE MULESOFT SERVICE TO PERFORM CRUD OPERATIONS IN DATABASE
TO POST/INSERT Technologies records
To GET the technologies details
To UPDATE the technologies details
To DELETE the technology record
MY SQL DB details
===========
localhost
3306
root
mysql
Table script
=================
CREATE TABLE hbt.technologies(
technology varchar(30) PRIMARY KEY,
provider varchar(30),
created_by varchar(30),
creation_date date,
updation_date date
);
Post/Insert statement EXAMPLE
::
INSERT INTO hbt.technologies(technology, provider, created_by, creation_date, updation_date) VALUES('Mulesoft', 'A Salesforce product', 'Chandra', '2020-10-23', '2020-10-23');
Get EXAMPLE
::
select * from hbt.technologies;
Update EXAMPLE
::
UPDATE hbt.technologies
SET provider = 'The Oracle Enterprise', updation_date=CURDATE(), created_by='My Sql'
where technology = 'Java'
;
Delete EXAMPLE
::
DELETE FROM hbt.technologies
WHERE technology = :p_technology
;
Watch video P1-S22| online without registration, duration hours minute second in high quality. This video was added by user Mulesoft 29 December 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 15 once and liked it people.