Em Andamento

Enhanced Database Modification Script

I need a script that will allow me to create a set of rules to apply to a mysql table. The rules will be based on a single field (source_url), and if the value in the rule matches (source_url) contents, it will apply the following changes:

1. Overwrite the source_url field with a new value

(This is something like: is source_url LIKE '%domain_name%' then overwrite source_url with '[url removed, login to view]'

2. If source_url LIKE '%domain_name%' then overwrite privacy_url with 'http://www.privacy_url'

3. If source_url LIKE '%domain_name%' then overwrite category with 'Category of Interest'

4. If source_url LIKE '%domain_name%' then overwrite source_id with 'VALUE'

I will need to be able to add/modify/delete these rules as per the template, and they should be run all at once (not individually). The point is that I have scripts to do this one source_url at a time now, but I may have dozens in a single table, and I want to update all of them in a single operation.

There is an example of a before and after mysql table here:

[url removed, login to view]

(It was too large to upload to [url removed, login to view])

Habilidades: Linux, PHP

Ver mais: rules database modification, upload database, script linux, php script create table, linux script, gz, create operation, script update database mysql, point interest, run script linux, delete mysql tables, database example, point modification, create script linux, update database mysql, example mysql script, mysql create table template, mysql update database, enhanced, need modification, mysql delete tables, script modify, large script, script update mysql tables, php changes database

Acerca do Empregador:
( 7 comentários ) Tampa, United States

ID do Projeto: #160178