Hi,
How can I delete empty rows in a table that I have.
f_huge_id | f_huge_name | f_huge_badge | f_huge_city
| f_huge_edu
-----------+-------------+--------------+-------------+-------------------
1 | Apparao | A12345 | Anakapalli
| Brown University
2 | Paparao | A23456 | Madugula
| Town University
3 | | |
|
4 | Chinnarao | A34456 | Uppalada
| Sink University
5 | Gangaraju | B34657 | Srikakulam
| Kulam University
6 | | |
|
7 | Appalaraju | A34457 | Chodavaram
| AMAL college
8 | Kanakarao | A56788 | Pisinikada
| Temple University
9 | | |
|
10 | | |
|
In this table columns 3,6,9 and 10 are completely
empty. I tried
=>DELETE from my_table where fc_huge_name = ' NULL';
DELTE 0
However nothing is deleted.
Is there some command or statement that I am missing.
Can any one suggest some way.
Thank you.
Kumar.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com