<div dir="ltr">Hi<div><br></div><div>I have a DB with about 600 tables. I want to know the size of the tables in descending size order but it's not workable to have this in a shell window.</div><div><br></div><div style>
Does anyone know of a way to run a query in mysql that will output to a csv file or even a text file?</div><div style><br></div><div style>Olly</div></div>

<br>
<img alt="" src="https://lh5.googleusercontent.com/-2-gHGBUE9eQ/Tx6JwDAOA5I/AAAAAAAABBI/Il4nIT8hNKU/s0-d/personal2.jpg" style="font:normal normal normal medium/normal 'Times New Roman'"><span style="font:normal normal normal medium/normal 'Times New Roman'"></span><table border="0" cellspacing="0" cellpadding="0" bgcolor="#ffffff" style="width:500px"><tbody><tr><td valign="top" width="220"><img alt="" src="https://lh3.googleusercontent.com/-b1F1QX1hEHU/Tx6K_mSOZ1I/AAAAAAAABBg/7fUhv69QANk/w500-h157-k/G2_SUPPORT_LLP_NEW_SMALL_220_50_white.jpg" width="220" height="69"></td><td valign="top" width="280" align="left"><div style="margin-top:10px"><font color="#808080" size="2" face="Calibri">Network Support<br>Online Backups<br>Server Management</font></div></td></tr><tr><td colspan="2"><p><font color="#000000" size="2" face="Calibri">Tel: 0845 307 3443<br>Web: <a href="http://www.g2support.com/" target="_blank">http://www.g2support.com</a><br>Twitter: <a href="http://twitter.com/home?status=@g2support" target="_blank">g2support</a><br>Google+: <a href="http://www.g2support.com/plus" target="_blank">http://www.g2support.<WBR>com/plus</a><br>Facebook: <a href="http://www.facebook.com/g2support" target="_blank">http://www.facebook.com/<WBR>g2support</a><br>Mail: Unit H, Hove Technology Centre, Hove, Sussex, BN3 7ES<br></font></p><p><font color="#000000" size="2" face="Calibri">Have you said something nice about us to a friend or colleague ? Let us say thanks. Find out more at <a href="http://www.g2support.com/referral" target="_blank">www.g2support.com/referral</a></font></p><p><font face="Calibri"><font color="#808080" size="2">G2 Support LLP is registered at Mill House, 103 Holmes Avenue, HOVE<br>BN3 7LE. Our registered company number is OC316341.</font></font></p></td></tr></tbody></table><br><div><img src="https://lh3.googleusercontent.com/-AJb6rYW9F9s/UGW-0nD_TnI/AAAAAAAAGP0/fwAuTYi_nRc/s75/Google-Apps-Button.png">  <span style="font-size:1.3em"> </span><img src="https://lh5.googleusercontent.com/-8r74XXu4XgU/UGW_4gD99nI/AAAAAAAAGQI/BTEAWLc8tzI/s75/lenovo.png" style="font-size:1.3em">   <img src="https://lh6.googleusercontent.com/-Xf84YuvL9TA/UGXCGSAbFBI/AAAAAAAAGQY/zLQyy21sQLQ/s118/ruckus.png" style="font-size:1.3em"></div>