Advanced Search

Return to Snippet

Revision: 18391
at September 29, 2009 14:00 by cherbert
Updated Code 
INSERT INTO jobs (companyid,clientref,jobid) VALUES (8,2,IFNULL((SELECT max(b.jobid)+1 FROM jobs b where b.clientref=2),1) );

Revision: 18390
at September 29, 2009 14:00 by cherbert
Updated Code 
// MySQL Insert Unique Reference using MAX() to obtain latest value
// Alternate solution to using Composite Primary Keys which INNODB engine does not support.

INSERT INTO jobs (companyid,clientref,jobid) VALUES (8,2,IFNULL((SELECT max(b.jobid)+1 FROM jobs b where b.clientref=2),1) );

Revision: 18389
at September 29, 2009 13:56 by cherbert
Initial Code 
INSERT INTO jobs (companyid,clientref,jobid) VALUES (8,2,IFNULL((SELECT max(b.jobid)+1 FROM jobs b where b.clientref=2),1) );
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
MySQL Insert Unique Reference using MAX() to obtain latest value
Alternate solution to using Composite Primary Keys which INNODB engine does not support.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
MySQL Insert Unique Reference

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL