How do add a line to my mysql database?
tanitious asked:
I just downloaded a contribution for Oscommerce that requires I add a few lines to my database. All it says is add these lines to the database but I have no idea where to go when I get into PHPMyAdmin? Help please!
// Each of these lines go into the MySQL Database. You must add them one at a time using PHPMyAdmin
I just downloaded a contribution for Oscommerce that requires I add a few lines to my database. All it says is add these lines to the database but I have no idea where to go when I get into PHPMyAdmin? Help please!
// Each of these lines go into the MySQL Database. You must add them one at a time using PHPMyAdmin
ALTER TABLE `catalog`.`products` ADD `products_subimage1` VARCHAR(64) AFTER `products_bimage`
ok I see, yah you have to go to the SQL section of phpmyadmin and paste those queries in and run them, one line at a time
you will have to paste the sql query statement into the sql tabs text box.
click on your database from the left hand side of phpmyadmin.
then at the top there will be a SQL tab click it and paste your sql statement there.
then run it and it will either show you an error or alter your tables successfully
if it looks like insert into blah fields (moo,ha, cow) values (‘blah’,'ho’,'green green grass’) then you can just click the little green button that says SQL and paste it in there…
uhh.. how about a nice walkthru…