469,293 Members | 1,364 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,293 developers. It's quick & easy.

running update stats

Hi,

I am trying to run an update stats command but keep getting a syntax error:
Looking at the doco it looks like I can use:
update stats <table_name>;

but when I use:
mysql> update stats x_balance;
ERROR 1064: You have an error in your SQL syntax near 'x_balance' at line 1

What am I doing wrong.

thanks
pete

redhat 9 / mysql 3.23
Jul 20 '05 #1
1 3219
Peter Sands wrote:
I am trying to run an update stats command but keep getting a syntax error:
Looking at the doco it looks like I can use:
update stats <table_name>;


Could you tell url to the page of the document you refer here, because I
couldn't find anything like that from the manual.

http://dev.mysql.com/doc/mysql/en/index.html
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by robert | last post: by
6 posts views Thread by Scott Sabo | last post: by
1 post views Thread by Chris Weston | last post: by
9 posts views Thread by ankitdesai | last post: by
2 posts views Thread by Karthik Gurusamy | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.