SQL query questions

[cczernia]

I have two questions regarding SQL queries.

 

1. I am trying to delete and entire column. I'm looking for the command to delete a cell that has something in it. This is what I have so far:

 

UPDATE `table`
SET `field1` = NULL
WHERE `field1` <> NULL

 

It didn't work. Any ideas on how to right this correctly.

 

2. I need to increase the value of about 2000 items on my site by 11%. Is there a query or contributions that can do this quickly?

 

Thanks in advance.

[Guest]

1. To drop an entire column from a table

ALTER TABLE `sometable` DROP `column_name_to_drop`

 

2. Have you tried EP?

[cczernia]

Thanks for the help with the SQL. I was told I can't use EP for the site because I have too many items and too many attributes that it would overload excel.

 

Any other suggestions?

 

2. Have you tried EP?