XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Beginner's Corner 
  4.  / can phpMyadmin export a query result?
Register
1
go2eu
can phpMyadmin export a query result?

  • 2005/9/13 8:13

  • go2eu

  • Just popping in

  • Posts: 16

  • Since: 2004/2/14


hi

how is that possible to export a query result in phpMyadin?

which means, give each line of query result a insert statement .

This is very important to recover the deleted topic .

Thank you very much !!
2
Dave_L
Re: can phpMyadmin export a query result?

  • 2005/9/13 8:48

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


I'm not sure if I understand what you want to do.

You can do an INSERT ... SELECT query, which inserts rows based on the result of a SELECT query.

Reference:http://dev.mysql.com/doc/mysql/en/insert-select.html
3
davidthomas1
Re: can phpMyadmin export a query result?

In PHP MyAdmin, there's an export link at the bottom of the query results page.

After you run the query, click the export link and you can export the query result in many different formats (e.g CSV, Excel, Word...)

I think you can also export as SQL, that should let you insert the query later,

try it out,

hope it helps,

D.
みんなちがってみんないい。

XOOPS 2.0.13.2

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

223 user(s) are online (128 user(s) are browsing Support Forums)

Members: 0

Guests: 223

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits