jonw118 Posted October 7, 2010 Share Posted October 7, 2010 Hi all - I'd greatly appreciate any help. I am using phpMyAdmin and trying to export a table to a CSV. Many rows within the CSV do not have any values in any of the columns. When I go to export to CSV it "skips" these rows and doesn't export them. Does anyone know if it's possible to export the rows to CSV even if there are null values in a rows columns? Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/215334-exporting-rows-with-null-values/ Share on other sites More sharing options...
BlueSkyIS Posted October 7, 2010 Share Posted October 7, 2010 yes, of course it is possible. I don't know how to do it specifically with phpMyAdmin, but the SQL would be something like SELECT * FROM table_name Quote Link to comment https://forums.phpfreaks.com/topic/215334-exporting-rows-with-null-values/#findComment-1119784 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.