I have a problem where I need to just export selected data from my phpmyadmin, i'm using XAMPP. I have a table named "<code>Tbl_Records</code>" and I only need to get all the data of year 2014 or just a specific year in that table. I tried <pre class="prettyprint lang-xml prettyprint-override"><code>Select * From Tbl_Records Where Year = 2014 </code></pre> in Phpmyadmin to get only the specific year and then exported the data but it still exported everything.

You need to use the <code>Export</code> link located under the data from the query and not the Export tab at the top, as shown in the picture below: <img src="https://i.stack.imgur.com/u8zAO.png" alt="enter image description here">

phpmyadmin export selected data from SQL to excel

Tags:

database

php

mysql

excel

phpmyadmin

I have a problem where I need to just export selected data from my phpmyadmin, i'm using XAMPP.

I have a table named "Tbl_Records" and I only need to get all the data of year 2014 or just a specific year in that table.

I tried

Select * From Tbl_Records Where Year = 2014

in Phpmyadmin to get only the specific year and then exported the data but it still exported everything.

968

asked Dec 10 '14 02:12

Allan-LaLa De Joya

1 Answers

You need to use the Export link located under the data from the query and not the Export tab at the top, as shown in the picture below:

enter image description here

answered Oct 06 '22 01:10

Michael

Related questions
                            
                                JQuery UI autocomplete with json and ajax
                            
                                Which is faster / more efficient - lots of little MySQL queries or one big PHP array?
                            
                                Compile a referenced LESS file into CSS with PHP automatically
                            
                                Uploading a file with XMLHttprequest - Missing boundary in multipart/form-data
                            
                                How to implement hook_theme in drupal 7?
                            
                                Models in Symfony2, and other MVC frameworks?
                            
                                OAuth 2.0 Server for PHP
                            
                                how to change port of wamp server and how to create first application [closed]
                            
                                PHP can't remove cookie that was set by JavaScript
                            
                                Codeigniter $this->db->order_by(' ','desc') result is not complete
                            
                                Find week days date from range of the two dates
                            
                                Should i develop in codeigniter now on? [closed]
                            
                                How do I stop WordPress loading jQuery and jQuery-migrate?
                            
                                Laravel 4 make post request from controller to external url with data
                            
                                PHP setlocale not working even with locales existing
                            
                                How do I access the _context variable within a macro in TWIG?
                            
                                Laravel 4 and the way to deploy app using FTP
                            
                                Setting Woocommerce Product Tags and Categories via Custom Frontend Form
                            
                                how to keep double quotes in twig?
                            
                                Overriding parent theme javascript from child theme