Creating SEO data directly in MySQL

WordPress version: 3.5.1
WordPress SEO version: 1.4.6

I did this:
Hi I have a directory website with over 25000 records and I wanted to create SEO data automatically for each page. Obviously I’m not going to do it manually. So I did one manually and checked the results.

Seems I need to insert the following SQL.

insert into wp_postmeta values (458622,12494,’_yoast_wpseo_focuskw’,’My Focus Keyword’);
insert into wp_postmeta values (458623,12494,’_yoast_wpseo_title’,”);
insert into wp_postmeta values (458624,12494,’_yoast_wpseo_metadesc’,’My metadesc.’);
insert into wp_postmeta values (458625,12494,’_yoast_wpseo_meta-robots-noindex’,’0′);
insert into wp_postmeta values (458626,12494,’_yoast_wpseo_meta-robots-nofollow’,’0′);
insert into wp_postmeta values (458627,12494,’_yoast_wpseo_meta-robots-adv’,’none’);
insert into wp_postmeta values (458628,12494,’_yoast_wpseo_sitemap-include’,’-‘);
insert into wp_postmeta values (458629,12494,’_yoast_wpseo_sitemap-prio’,’-‘);
insert into wp_postmeta values (458630,12494,’_yoast_wpseo_canonical’,”);
insert into wp_postmeta values (458631,12494,’_yoast_wpseo_redirect’,”);
insert into wp_postmeta values (458632,12494,’_yoast_wpseo_opengraph-description’,”);
insert into wp_postmeta values (458633,12494,’_yoast_wpseo_google-plus-description’,”);

Obviously I substituted in the relevant details for lines 1 and 3

I expected the plugin to do this: I expected it to create the relevant SEO details for the post and allow me to see them in the posts listing columns, filter them by seo quality etc.

Instead it did this: It updates each post fine when I go into the individual post, however it doesn’t show them as updated in the bulk post listings page. They show as no focus keyword.

Am I missing an update somewhere else in the database or a file?
Does it matter that they don’t show up here and yet have the relevant data against the post?

Any help or suggestions on how to do this gratefully received.

Best regards Steve

https://www.ads-software.com/extend/plugins/wordpress-seo/