get Insert id for meta field

Question

I'm in a situation where i also need to get the id of the inserted meta( meta_id for post meta and umeta_id for user meta)

For eg i add a user meta

add_user_meta($user_id,'some_key',$some_value,false);

is there a built in method of getting the umeta_id for this meta field without using custom query?

Same case for retrieving meta value with meta id. I had to use this

$sql_query = 'select umeta_id as my_key_id, meta_value from  wp_usermeta where user_id = "'.$user_id.'" and meta_key = "some_key" order by my_key_id asc';

Any better alternative?

Answer 1

No need to get Insert id for meta field.You get key value by using this function.

$user_some_value = get_user_meta( $user_id, some_key ); 

Answer 2

$wpdb->insert_id was the simple solution.

Example:

global $wpdb;
add_user_meta($user_id,'some_key',$some_value,false);
$new_meta_key_id = $wpdb->insert_id;