Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How do I export particular column in MySQL using phpmyadmin?

Tags:

php

mysql

phpmyadmin

I do have thousands of website list and other info in MySQL database.

I want only website column named "web" to be exported to excel or text or csv.

I know how to export the whole data but dont know how to export particular column.

like image 450
mathew Avatar asked Dec 20 '10 03:12

mathew

People also ask

How do I export a single column in MySQL?

You can do it very easily using MySQL GUI tools like SQLyog, PHPMyAdmin. In SQLyog you just need to select the table, Click on "Export As..." Icon and you will get dialog to select the columns that you want to Export. Then click on "Export Button".

How do I export a column?

Select Miscellaneous > File Export > General or Configuration > External > Export Files to access the Export File List screen. Select the export from the list and select the Edit button to access the Export File Details screen. Select the Export Columns button. The Export Column Details screen appears.

How do I export my database from phpMyAdmin?

phpMyAdmin has two export options: Quick and Custom. If you’re not familiar with SQL tables or want the simplest way to export your database, you can select the Quick option.

How to export specific column data in MySQL?

How to export specific column data in MySQL? select yourColumnName from yourTableName into outfile 'yourLocationOfFile’; mysql> create table DemoTable ( StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentFirstName varchar (20), StudentLastName varchar (20) ); Query OK, 0 rows affected (0.54 sec)

What is the maximum database size that phpMyAdmin can import?

Note: phpMyAdmin can only import databases up to 50 MB in size. If your database is larger you will need to use SSH instead of phpMyAdmin. See Managing Databases with Command Line for further instructions.

What is phpMyAdmin and how to use it?

phpMyAdmin is one of the most popular tools used to administrate MySQL databases. This free and open-source tool has a user-friendly interface that allows you to run MySQL queries and manage your databases easily, including but not limited to exporting them. Most web hosting providers add phpMyAdmin to their control panel.

1 Answers

Query 

SELECT `web` FROM `yourtablename`

Or this to export unique records only:

SELECT DISTINCT `web` FROM `yourtablename`

Then click export link given on bottom (in phpmyadmin)

It is easiest way as per me

like image 107
Kinjalk Avatar answered Oct 09 '22 11:10

Kinjalk
Sign in to Comment

Related questions

Naming of interfaces/abstract classes in PHP 5.3 (using namespaces)
Php find string with regex
Is the order of keys returned from array_keys the same as the order in the input array?
What is the best way to define a global constant in PHP which is available in all files?
Can I create a PHP function that I can call without parentheses?
How to fix curl: (35) Cannot communicate securely with peer: no common encryption algorithm(s)
Bounce Email handling with PHP?
Passing object method to array_map()
Undefined offset while accessing array element which exists
Can someone spoof an IP address to any number? [closed]
php : echo"", print(), printf()
Where can I learn about PHP internals? [closed]
PHP UTC to Local Time
php null value confusion in switch statement
Fully Understanding PDO ATTR_PERSISTENT
How can I replace the "+" plus sign with its corresponding url encoding of "%2B"?
Get an ini setting in PHP at the command line
Yii2 : How to write distinct SQL query?
Get Laravel Models with All Attributes
Finding out the filename that called my function in PHP

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!