Hello. I got the following tables : CREATE TABLE A ( id_a INT AUTO_INCREMENT PRIMARY KEY, name_a VARCHAR(50), surname_a VARCHAR(50)); ...
Read More
insert foreign keys with trigger
Databases
Showing posts with label Databases. Show all posts
Showing posts with label Databases. Show all posts
Simpify my query
Databases
hi can you help me simplifying my query: SELECT SUM(NewQuote.total*.20) + (SELECT SUM((Invoice.invoiceTotal-NewQuote.total)*.30) FROM `Ne...
Read More
help getting query work
Databases
hi there, can i ask some help please. i need to get the addon percentage on my database... add on is being computed based on the differen...
Read More
Phpmyadmin trigger
Databases
Hi "A" table (sipid,totalkg) 1 .. 2.. 3.. "B" table (id,sipid,kg) 1 1 500 2 1 200 3 2 150 I want similer sipid...
Read More
Subscribe to:
Posts (Atom)