|
|
Posted by J.O. Aho on 10/02/15 11:33
Graeme wrote:
> "J.O. Aho" <user@example.net> wrote in message
> news:3v99tcF14i9vuU1@individual.net...
>> Graeme wrote:
>>> The question is all in the title.
>>>
>>> My suppliers csv files have been used to populate a mySQL
>>> database
>>> and this has then been used to generate all of the product
>>> pages.
>>>
>>> Now I want to remove certain manufacturers entirely however, I
>>> don't know how. Thus I'd be grateful for any advice or perhaps
>>> a
>>> URL to a tutorial or help page on the subject?
>> Much depends on what tools you have that you can use to
>> manipulate the
>> database with.
>
> When I login I see phpMyAdmin 2.6.2
>
I haven't myself used phpmyadmin, used to the command line tool, but after you
have logged in you should select the database from the drop-down-menu on the
left side, you will then get all the tables that is part of the database.
You will find on the right frame a section named
"Run SQL query/queries on database <databasename>_<tablename>"
modify the "SELECT * FROM `<tablename>` WHERE 1" to something like
"SELECT * FROM `<tablename>` WHERE <id_column_name>='<id_value_for_manufactor>'"
Then run the query (press on the "Go" button) and see that you only get the
lines you want to remove, if you get to many or none at all, modify the query
until it's right.
When it's right, then change "SELECT *" to "DELETE".
Before you do this, I recommend you go into the "Export" part and export the
database, so you can get it back in case you would mess things up (better to
have those manufacturers there than the database don't work).
If you do feel unsure about the whole thing, then it's better you try to get
someone who knows SQL to do it for you (do a export of the database before you
ask someone to do it, so you can restore it if the person turns out to ruin
things for you instead of helping).
//Aho
Navigation:
[Reply to this message]
|