Find Jobs
Hire Freelancers

Stock quantity Trigger in MySql

$10-30 USD

Closed
Posted over 2 years ago

$10-30 USD

Paid on delivery
Hello guys, I want a simple pl/sql code that works on phpmyadmin to do the following. I have two tables, the first is called products and the second is called order. The two tables have a column with the name of quantity. When I add to the order table, the quantity from the products table decreases. The problem is that I want to make a trigger, see if I was adding an unavailable quantity in the products table, or see if the quantity in it is 0 and send me an Exception telling me that the quantity is not available, for example, please help me with this simple code because I did not find a simple solution for it
Project ID: 32610176

About the project

5 proposals
Remote project
Active 2 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
5 freelancers are bidding on average $28 USD for this job
User Avatar
Hi, I can do it combinig triggers and constraints to do so. One question: the order table has only inserts or updates and deletions as well? Because the triggers should control all changes on order table, if not, qty field will not reflect real changes. Let's chat. Best regards, Esteban
$30 USD in 1 day
5.0 (5 reviews)
3.8
3.8
User Avatar
Hi I am system admin, will resolve the issues as per your requirement, and have expertise in the dabase management field. I have 5+ years of experience. Ping me for further queries. Thanks
$20 USD in 7 days
5.0 (6 reviews)
3.6
3.6
User Avatar
Hi In my current Profession -I perfom the DBA and Developer duties in high traffic OLTP environment -Python programing, -Data Scraping using python, data analysis using python and R -Database development in (Mysql,Postgres,SQlite and SQl) -Data Mining -Automation -Data warehousing on sql,mysql and postgres database (Star Schemas) and Business Intelligence systems development -Data extractions using Talend Open Studio,Python -Data Intergration using WSO2 ,Talend Open Studio -I have rich experienced in Database Administration, Excel -Data visualisation using Power BI,BIRT ,Jasper ,excel -SQL server installations I am looking for the clear final requirements docs of your project so that I can start working immediately. If you need to discuss with me for any kind of suggestions or information, please knock me anytime. I am looking forward to hearing from you I can assure that if you work with me once, you will always work with me on these kind of projects and I can deliver quality and superior work at a price we are both comfortable with and within the agreed timeline. Kindly consider my bid.I will do whatever it takes to complete this project and earn a 5 star rating from you as well Kind Regards Takudzwa
$20 USD in 1 day
5.0 (4 reviews)
2.2
2.2
User Avatar
Hello. I'm a web developer with 7 + years experience. I have Node, Express, MongoDB, Angular, AngularJS, React and JavaScript skills. I hope to discuss more detail via chat. If you give me a chance, I'll give you good result. I hope to work with you.
$50 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of EGYPT
Cairo, Egypt
0.0
0
Member since Jan 11, 2022

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.