I had to change the software for one of the sites i own on my server so i need to retrieve all e-mails from the old database to send an e-mail to old members to join the site again.
using mysqlman i clicked on sql monitor and entered
SELECT * FROM email ORDER BY id LIMIT 0, 20
but it only list 20 e-mails per page even if i change 20 to 100
what command do i need to use to list them all on one page?
using mysqlman i clicked on sql monitor and entered
SELECT * FROM email ORDER BY id LIMIT 0, 20
but it only list 20 e-mails per page even if i change 20 to 100
what command do i need to use to list them all on one page?
command to list all data on one page