<?php
$db = new PDO('mysql:host=localhost;dbname=wordpress;charset=utf8', 'root', '');
$query = "INSERT INTO $wpdb->terms (term_id, name, slug) VALUES (%d, %s, %s)";
$wpdb->query($wpdb->prepare($query, $term_id, $name, $slug));
foreach($db->query('SELECT * FROM wp_posts') as $row) {
global $wpdb;
$term_id = $row['ID'];
$name = $row['category'];
$slug = $row['category'];
$term_taxonomy_id = /*INCREASE THE BY 1(one) THE MAX TAZ_ID ALREDY INSERTED*/;
$taxonomy = 'category';
$query = "INSERT INTO $wpdb->term_taxonomy (term_taxonomy_id, term_id, taxonomy) VALUES (%d, %d, %s)";
$wpdb->query($wpdb->prepare($query, $term_taxonomy_id, $term_id, $taxonomy));
}
?>

...
SELECT wp.ID, wp.category, 'category',(SELECT MAX(t.term_id) FROM tmp t)+1 FROM wp_posts wp

quote:

---

Originally posted by James K

change the inner select:

...
SELECT wp.ID, wp.category, 'category',(SELECT MAX(t.term_id) FROM tmp t)+1 FROM wp_posts wp

I don't know the logic that you are trying to implement, but be aware that if there is more than one row in wp_posts, all the new rows inserted into tmp will have the same term_id. And, if there are no rows already existing in tmp or if the term_id for for any existing rows are null, then the new rows will be inserted with a null.

---

USE wordpress;

INSERT tmp
	(
		post_id,
		slug,
		tax,
		term_id
	)
SELECT	ID,
	category,
	'category',
  (SELECT MAX(t.term_id) + 1 FROM tmp t)
FROM wp_posts;

quote:

---

Originally posted by SwePeso

DECLARE	@t INT;

SELECT	@t = ISNULL(MAX(term_id), 1)
FROM	dbo.tmp;

INSERT	tmp
	(
		post_id,
		slug,
		tax,
		term_id
	)
SELECT	ID,
	category,
	'category',
	ROW_NUMBER() OVER (ORDER BY post_ID) + @t
FROM	dbo.wp_posts;

---

Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA

---