Joomla syntax for the last inserted mysql id?

Get db connection

$db = JFactory::getDBO();

      

        
        
        
      

    

Create a new request object.

$query = $db->getQuery(true);

      

        
        
        
      

    

Request to insert data

$query->insert('tablename')->columns('columnname')->values('custom msg');

      

        
        
        
      

    

Reset the request using the newly populated request object.

$db->setQuery($query);

      

        
        
        
      

    

Execute request

$db->execute();
$lastinsertid = $db->insertid(); // last insert id