jonathan.patton

Hi,=20

I have a query that runs in Microsoft Access against my mysql database =
just fine. It is:=20

=20
UPDATE discussion_categories AS discussion_categories_1=20
INNER JOIN discussion_categories ON=20
discussion_categories_1.parent_1_text =3D discussion_categories.name=20
SET discussion_categories_1.parent_1 =3D =
[discussion_categories].[category_id];


I tried to write this in mysql but couldn't figure it out. Is it =
possible to join a table on itself in mysql?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmysql@freebsd.csie.nctu.edu.tw

jonathan.patton

I answered my own question, this works for joining a table on itself and =
doing an update query:

update=20
discussion_categories discussion_categories1, discussion_categories
set=20
discussion_categories1.parent_1 =3D discussion_categories.category_id
where=20
discussion_categories1.`parent_1_text` =3D discussion_categories.name

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmysql@freebsd.csie.nctu.edu.tw