Đang Thực Hiện

151122 MySQL Syntax

We are using a photo gallery script with a MySQL database and currently the text from the name of the image files uploaded needs to be slightly modified and copied to other tables.

The record that has the data in is "filename" in the table "uploaded_images" which is referenced to a number in the "id" field in this table. This "id" number is used in the table "photo_package" which has the following fields to populate:

"title" where the image filename is used without the .JPG extension and any number greater than 4 digits (or value of 3000) is removed.

"keywords" where the image filename is used without the .JPG extension and any number greater than 4 digits (or value of 3000) is removed and all spaces are converted to commas.

"description" where the image filename is used without the .JPG extension and any number greater than 4 digits (or value of 3000) is removed.

The script needs to only change the records that do not have any data in "title". As images are uploaded, this script will be frequently run to update the batches.

To summarize, a script is needed to take the text from an image filename already in the database and populate three other fields in a different table with a modified version of this text.

Kỹ năng: Bất kì công việc gì, MySQL, Thiết lập Bản thảo, SQL

Xem thêm: mysql data files, syntax, sql mysql, sql update text, sql update field text, script update database mysql, mysql populate table, mysql number sql, converted mysql, update text sql, sql update text field, mysql update field, update field sql field field, sql update text text, mysql record, populate table using, mysql sql syntax, sql script mysql, script update mysql tables, mysql converted, sql syntax, mysql update table, update images sql database, script needs modified, gallery script mysql

Về Bên Thuê:
( 57 nhận xét )

Mã Dự Án: #1897302

Đã trao cho:

alexhistev

Hello, we can write script on php. Work will be done during several hours. I guarantee quality of our work. Best regards, Alex Histev (WDG [url removed, login to view])

$20 USD trong 0 ngày
(146 Đánh Giá)
6.7