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, tell me about myself, suppliers products, search for manufacturers, questions to ask about a job, questions to ask, products manufacturers, products database design, php job uk, php code search mysql database, need a manufacturer of my product, Mysql questions, manufacturers suppliers, manufacturers products, manufacturer search, manufacturer products, i want to know how to design website, i want to design products, i want to create website now, i want to create website for myself, i want to create my website now, i want to create my website, i want to create an website, i want to create a database website, i want to code

Tietoa työnantajasta:
( 4 arvostelua ) Newcastle, United Kingdom

Projektin tunnus: #35246