How to take all the data from the table in the database and send it to Excel (make a report)?

Closed due to the fact that the issue is too common for the participants of Kromster , Harry , fori1ton , Denis Bubnov , rjhdby Jan 22 '17 at 8:31 .

Please correct the question so that it describes the specific problem with sufficient detail to determine the appropriate answer. Do not ask a few questions at once. See “How to ask a good question?” For clarification. If the question can be reformulated according to the rules set out in the certificate , edit it .

  • Describe the task in more detail ... or maybe export to "CSV for Excel" will be enough ... - Akina
  • It is necessary to transfer the data from the student table to excel in order to later change the data in Excel - As Lan

1 answer 1

In phpMyAdmin :

  • Click the Export tab (when viewing the required table)
  • Decide on методом экспорта , such as Быстрый
  • Select Формат - CSV for MS Excel from the dropdown menu.
  • Click the Вперед button and select the location to save the file.
  • Open file using Excel
  • about ATP) earned - As Lan