I need to remove products from MySQL (a very simple job)

My suppliers csv files have been used to create a MySQL database.

This in turn is used to dynamically generate all of my product pages.

Now I want to remove three of the manufacturers entirely and two "types of products" however, unfortunately I don't know how to do this myself and, I'm too scared to try in case of messing everything up.

When I login to the DB I see "phpMyAdmin 2.6.2"

Evidently, it's possible to search by doing something like as follows:

"Run SQL query/queries on database _"

No doubt it'll be possible to identify all of the products by any given manufacturer and then delete them en masse.

As to the "types of products" I simply want to remove all of the "oversize" and "hazardous" products. Once again these can easily be identified and presumably removed quite simply/swiftly.

Lastly, I want you to explain/show me how to remove an individual item myself.

For example lets say I wanted to remove:

[url removed, login to view]

I'd do the search using the SKU code i.e. UC1254.

So in conclusion you would just tell me how to do this.

If you have any questions about the job please do not hesitate to ask.

Taidot: PHP, verkkosivujen suunnittelu

Näytä lisää: delete products mysql, suppliers products, questions ask job, questions ask, products manufacturers, products database design, mysql questions, manufacturers suppliers, manufacturers products, manufacturer search, manufacturer products, want design products, want create database website, want code, need create design, need manufacturers, easily create website, create php pages, create database using php, design item website, design job search, database design job, create products, deleting product mysql, delete products mysql database

About the Employer:
( 4 reviews ) Newcastle, United Kingdom

Projektin tunnus: #35246