Gossamer Forum
Home : Products : Others : MySQLMan :

command to list all data on one page

Quote Reply
command to list all data on one page
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?
Subject Author Views Date
Thread command to list all data on one page theguy 11419 Jan 5, 2012, 2:12 AM
Thread Re: [theguy] command to list all data on one page
theguy 11081 Jan 19, 2012, 5:38 AM
Post Re: [theguy] command to list all data on one page
Andy 11087 Jan 19, 2012, 6:38 AM