Learn how to export particular column from a table through PhpMyAdmin. Text Tutorial here …
Original source
How to Export Particular / Specific Columns from a Table – MySQL PhpMyadmin Tutorial
Learn how to export particular column from a table through PhpMyAdmin. Text Tutorial here …
Original source
13 responses to “How to Export Particular / Specific Columns from a Table – MySQL PhpMyadmin Tutorial”
Thank you very much, I need something like that but work very well!!!
Great help, thanks.
thank you babu!! This was a big help.
Super, thanks!
thanks
Thank you for the quick reply. It turns out that the problem is with Excel; it cannot exceed the limit of 1,048,576 rows. Bah. Trying Gnumeric now.
Hi Brian,
I think you are trying the export button besides the Check All / Uncheck. It is actually below "Query results operations", try that export button it will do. Try the tutorial link in my description.
Hi Agurchand,
good video. However SELECT `depth` FROM `tag_index` does not work for me. I have a huge table with over a million rows. My 'depth' column ranges from 3 to 4,326, but the only value exported is 3. I select "check all" but it only selects values of 3 and shows:
SELECT `depth`
FROM `tag_index`
WHERE ((`tag_index`.`depth` =3))
I tried depth=3-4326, but this fails. do you know why this is not working?
excellent – I didn't know to use the Export at the bottom of the result set (as opposed to table Export)
Excellent! Thanks!
Informative!! Thanks.
Thank you for taking the time to do this video, it was quite helpful.
Thanks just what I needed…