LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 07-13-2010, 06:38 AM   #1
neverland
Member
 
Registered: Mar 2010
Posts: 31

Rep: Reputation: 15
ERROR 1146: Table 'information_schema.tables' doesn't exist


Hi there,
Does anyone know how to write this command for mysql version 4? (The command is for mysql version 5, I guess since when I check database in mysql server version4 there is no database name information_schema )

command:select concat(table_schema,'.',table_name) as table_name,table_rows from information_schema.tables where table_rows > 1000000 order by table_rows desc;

meaning:show all database,table name and row count from all databases that has table row more than 1000000

Run result with mysql version 5:
mysql> select concat(table_schema,'.',table_name) as table_name,table_rows from information_schema.tables where table_rows > 1000000 order by table_rows desc; +-------------------------------------+------------+
| table_name | table_rows |
+-------------------------------------+------------+
| waka2_dev.PYAT_TABLE_CELL_OLD | 110557706 |
| caap63_ded2.PIOFIT2 | 20052885 |

Run result with mysql version 4
mysql> select concat(table_schema,'.',table_name) as table_name,table_rows from information_schema.tables where table_rows > 1000000 order by table_rows desc;
ERROR 1146: Table 'information_schema.tables' doesn't exist

Anyone please helps
Thanks in advanced!
 
Old 07-15-2010, 02:09 PM   #2
ogin
LQ Newbie
 
Registered: Nov 2005
Posts: 11

Rep: Reputation: 1
Seeing as this is a place for Linux specific questions, you'd be better served in a mysql forum or by doing a simple google search.
 
Old 07-15-2010, 02:48 PM   #3
ogin
LQ Newbie
 
Registered: Nov 2005
Posts: 11

Rep: Reputation: 1
Aaaaand I forgot which forum I was in. Sorry about that.
 
Old 07-15-2010, 02:59 PM   #4
GrapefruiTgirl
Guru
 
Registered: Dec 2006
Location: underground
Distribution: Slackware64
Posts: 7,594

Rep: Reputation: 550Reputation: 550Reputation: 550Reputation: 550Reputation: 550Reputation: 550
ogin,

Hi there. As this is the second thread which you have removed from the zero-reply list by suggesting the OP would be better served in another forum, I am hereby asking kindly that you do not make the first reply to a brand new thread to suggest that the OP is posting his/her question in the wrong place.

If a question doesn't belong somewhere, please feel free to use the REPORT button and ask a moderator to have a look and/or to inform the OP that they might do better elsewhere. Alternately, just let it slide until there have been some other replies that attempt to address the issue.

Thanks and kind regards,

Sasha
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
can't initialize iptables table `filter': Table does not exist... sodek Linux - Software 3 05-07-2012 02:54 AM
Strange database issue table doesn't exist [error code: 1146] edenCC Linux - Server 2 06-20-2010 12:29 AM
How to route using my own custom routing tables and not the Kernel's table WhiskeyTangoFoxtrot Linux - Networking 1 03-17-2009 10:03 AM
Finding What Tables Exist In A MySQL Database taylor_venable Programming 7 12-19-2005 09:52 PM
Table 'mysql.host' doesn't exist Zac2003 *BSD 5 09-14-2003 12:37 PM


All times are GMT -5. The time now is 02:02 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration