Devam Ediyor

478420 Populate/build database table

Hi, I need someone to build a database table, as the current table is incomplete.

For example:

INSERT INTO `phunny_images` (`item_id`, `item_cat_id`, `item_title`, `item_photo`, `item_photo_big`, `item_total_view`, `item_added_date`, `item_updated_date`, `item_status`, `item_features`) VALUES

(19004, 899, 'SETNAME', '[url removed, login to view]', '[url removed, login to view]', 0, '2011-02-16 03:52:55', '2011-02-16 03:52:55', 'Active', 'Unfeatured'),

(19005, 899, 'SETNAME', '[url removed, login to view]', '[url removed, login to view]', 0, '2011-02-16 03:52:55', '2011-02-16 03:52:55', 'Active', 'Unfeatured'),

(19006, 899, 'SETNAME', '[url removed, login to view]', '[url removed, login to view]', 0, '2011-02-16 03:52:55', '2011-02-16 03:52:55', 'Active', 'Unfeatured'),

(19007, 899, 'SETNAME', '[url removed, login to view]', '[url removed, login to view]', 0, '2011-02-16 03:52:55', '2011-02-16 03:52:55', 'Active', 'Unfeatured'),

(19008, 899, 'SETNAME', '[url removed, login to view]', '[url removed, login to view]', 0, '2011-02-16 03:52:55', '2011-02-16 03:52:55', 'Active', 'Unfeatured'),

(19009, 899, 'SETNAME', '[url removed, login to view]', '[url removed, login to view]', 0, '2011-02-16 03:52:55', '2011-02-16 03:52:55', 'Active', 'Unfeatured'),

(19010, 899, 'SETNAME', '[url removed, login to view]', '[url removed, login to view]', 0, '2011-02-16 03:52:55', '2011-02-16 03:52:55', 'Active', 'Unfeatured'),

(19011, 899, 'SETNAME', '[url removed, login to view]', '[url removed, login to view]', 0, '2011-02-16 03:52:55', '2011-02-16 03:52:55', 'Active', 'Unfeatured'),

(19012, 899, 'SETNAME', '[url removed, login to view]', '[url removed, login to view]', 0, '2011-02-16 03:52:55', '2011-02-16 03:52:55', 'Active', 'Unfeatured'),

(19013, 899, 'SETNAME', '[url removed, login to view]', '[url removed, login to view]', 0, '2011-02-16 03:52:55', '2011-02-16 03:52:55', 'Active', 'Unfeatured'),

As you can see, the table is missing lines for images that exist (ie, it is missing image # 1, 4, 7, 8, 12, 15, 16) I need a complete table.

I will provide a list of setnames, cat ID's, and # of images in each set, and you build the table from this information. The rest of the fields (item_total_view, item_added_date, item_updated_date, item_status & item_features) stay the same. Each image will need a unique item_ID.

Please be advised that there is approx. 1100 sets, each containing a handful of pictures all the way up to several hundred. This project is adult-related.

The table will contain entries for approximately 50,000 images so you must have an efficient way of conducting this process.

Thanks, I look forward to working with you!

Andrew

Beceriler: Her şey Kabul, Veri Tabanı Yönetimi, Düzenleme, SQL

Daha fazlasını görün: database build - i need, build sql, build database sql, table jpg, image table, database rest, insert adult, build complete, populate database, insert related, missing table, missing database table, adult insert, project populate, build image, table exist, adult jpg, related database, editing database, complete build, unique image editing, list build, pictures editing project, adult lines, database populate

İşveren Hakkında:
( 24 değerlendirme ) Leeds, United States

Proje NO: #2224327

Seçilen:

0 gün içinde 200$ USD
(543 Değerlendirme)
7.2