How to remove empty rows from my mysql

[DavidTigerch]

Hi all i recently uploaded data from text file .Bu unfortuently there were empty lines between each records in the text file and now after transfering the data to mysql i got one empty row for those empty lines. Could any oone tell me how i can remove those empty rows. Thanks

 

[johnwm]

Documentation for MySQL is at:

http://dev.mysql.com/doc/

See strongm's post in thread222-1227142 - these forums are designed for computer professionals so we expect you to do SOME work on your own, particularly the obvious stuff. You might also re-read faq222-2244

For this question, look up the Delete keyword:

http://www.mysql.com/search/?q=delete&charset=

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[Kozusnik]

DELETE FROM table WHERE some_field = ''

That should work.

Mark