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?... Link to comment https://forums.phpfreaks.com/topic/140764-solved-delete-empty-row/ Share on other sites More sharing options...
fenway Posted January 14, 2009 Share Posted January 14, 2009 What? Link to comment https://forums.phpfreaks.com/topic/140764-solved-delete-empty-row/#findComment-736893 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!]] Link to comment https://forums.phpfreaks.com/topic/140764-solved-delete-empty-row/#findComment-736908 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??? Link to comment https://forums.phpfreaks.com/topic/140764-solved-delete-empty-row/#findComment-737027 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.