MySQL Forums :: General :: Wrong info from Information_schema


Advanced Search

Wrong info from Information_schema
Posted by: Tom Byars ()
Date: April 24, 2009 11:55AM

I deleted a column from table Tbl a few weeks back and then reinserted it a week ago. When I run this query

select group_concat(column_name) from information_schema.columns where table_schema='dbase' and table_name='Tbl';

the deleted/reinserted column is missing.

I created a new table with

create table NewTbl select * from Tbl;

select group_concat(column_name) from information_schema.columns where table_schema='dbase' and table_name='NewTbl';

did show the column in question but when I renamed Tbl to Tbl2 and then NewTbl to Tbl the query

select group_concat(column_name) from information_schema.columns where table_schema='dbase' and table_name='Tbl';

did not show the column in question yet the query

select group_concat(column_name) from information_schema.columns where table_schema='dbase' and table_name='NewTbl';

did show the column even though the dbase schema no longer contained a table called NewTbl.

Can anyone cast any light on this? I'm using MySQL community 5.1.

Options: ReplyQuote


Subject Written By Posted
Wrong info from Information_schema Tom Byars 04/24/2009 11:55AM
Re: Wrong info from Information_schema Tom Byars 04/24/2009 12:27PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.