I am searching -google, mysql-man, forums- for a solution for more than four hours but could not find anything. I need simply a function+
condition to update hundreds of tables.

This query stopped on first error:

update ignore table1 set id2=id1;
update ignore table2 set id2=id1;
...

Any idea?

After I changed post settings (changed teaser length from 400 to 200 chars) on Drupal, teasers are not changed. I have thousands of nodes and can not edit them manually. Is there a short & fast way withput cutting words?

Can anyone tell me which of the free shopping carts has a one-page checkout or at least allows customers to checkout without creating an account? I am looking for one that is also templated and displays products in a grid format with multiple categories and cross selling. Any suggestions appreciated.

When I try to use nide_import module to import data from csv files, I get this error on step 7 to 8: An illegal choice has been detected. Please contact the site administrator. Why?

When I use GD to create thumbnails from anim-GIFs, I get just the first frame. PHP removes all other animation frames. I am looking for a technique to create thumbnails from animations with same frame length and delay etc. It could be with imagemagick instead of gd.

I want build a small video portal and looking for a script which can upload videos and convert to flash format. I have googled and find ffmpeg but I am not a linux guru to customize many things. I need a easy to setup php script. Any suggestion?

Mysql uses regex and returns true/false, also just if matching but can not capture/catch. Is there a way to use mysql-regex to replace matching records without php?

I want to play some video-files from my PC on an 10 years old orion TV. Which minimum equipment do I need and how much does it cost?

I want to install web server, database system and php on my laptop with windows xp. Which is the most secure way and which versions of that software should I take and do I need Lighthttpd and Postgresql too?

I need audio drivers for fujitsu-siemens laptop 1milo 1510. I couldnt find on fsc website.