emexinc Posted January 14, 2009 Share Posted January 14, 2009 ...in my database i have empty rows, if we ignore how they get there, what can i do to delete them...i know i can drop columns, how do I go about this with empty rows?... Quote Link to comment Share on other sites More sharing options...
fenway Posted January 14, 2009 Share Posted January 14, 2009 What? Quote Link to comment Share on other sites More sharing options...
aschk Posted January 14, 2009 Share Posted January 14, 2009 Assuming you do actually have empty rows i.e. all columns in the row are blank (the default empty string) then you can do // The following is pseudo-sql, fill in the required parts (< >) DELETE FROM <table name here> WHERE <column> = '' AND <column> = '' [AND <columnn = ''> [REPEAT!]] Quote Link to comment Share on other sites More sharing options...
fenway Posted January 14, 2009 Share Posted January 14, 2009 Hey, aschk! You're back... where do you go??? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.