hiI have a question I can't figure out.lets say I have tblproduct table with autogenerated key on productId , then I have a tblcompany with compid as unique.then a table that links them, called tblall with compid and productId , but when a company adds a product how do I get that productId to be the same as productId in tblall ?

What database? and if MySQL what engine?

hey, thanks for replyits mysql , MylSAM.

Well that's a couple of possibilities out straight away

use
INSERT INTO tblall (compid, productId) VALUES(1, last_insert_id() ) ;
immediately after inserting the new product

heymmmmmm, ok does that work even if there a huge amount of inserts per second?thanks for help by the way

lock the table before the insert

insert the product
LOCK TABLES tblproduct WRITE
run the inserts
UNLOCK TABLES

You must use transactions

Originally Posted by Necaxa

hey, thanks for replyits mysql , MylSAM.

Originally Posted by edygalantzan

You must use transactions

Transactions are ONLY available on InnoDb and BDB storage engines.

What??

MyISAM is the general purpose fast retrieval storage engine built on IBMs ISAM storage and has never supported transactions.
If transactional processing is needed the InnoDB engine is the one to use. Or move on to PostGre

Originally Posted by Learning Newbie

What??

Mysql John, you remember ?
That db that transforms nulls into empty when you try to insert a null value in a non nullable field.
Or that truncate fields that are too long.

That db that makes me feel dirty when I have to work with.