dflow Posted March 9, 2011 Share Posted March 9, 2011 i have a list of things in english in one column in a table, i would like to translate and insert it so UPDATE `amenities` SET `Amenity_de` =Aufzug' WHERE Amentiy='elevator' how can i create a loop in sql for this? Link to comment https://forums.phpfreaks.com/topic/230130-mysql-insert-language-translation/ Share on other sites More sharing options...
TOA Posted March 9, 2011 Share Posted March 9, 2011 You could do it in php, but mysql does have a where loop: http://dev.mysql.com/doc/refman/5.0/en/while-statement.html I think that's what you're looking for Link to comment https://forums.phpfreaks.com/topic/230130-mysql-insert-language-translation/#findComment-1185218 Share on other sites More sharing options...
fenway Posted March 10, 2011 Share Posted March 10, 2011 Yeah, but that's in an SP. Link to comment https://forums.phpfreaks.com/topic/230130-mysql-insert-language-translation/#findComment-1185330 Share on other sites More sharing options...
dflow Posted March 10, 2011 Author Share Posted March 10, 2011 Yeah, but that's in an SP. at the end of things i created a distinct list table and left joined them Link to comment https://forums.phpfreaks.com/topic/230130-mysql-insert-language-translation/#findComment-1185585 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.