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? Quote 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 Quote 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. Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/230130-mysql-insert-language-translation/#findComment-1185585 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.