How to get rid of tail 'InnoDB free: 8192 kB' in table comment?

boraldo · #1 (**permalink**) 01-07-11, 13:06

When I create table it's comment is set to "InnoDB free: 8192 kB".
If I define comment that text is appended to what I defined.
Can I get rid of it ?

it-iss.com · #2 (**permalink**) 01-07-11, 15:59

Hi,

with what tool are you looking at the comment information? I have seen something similar in the past but the issue was related to the GUI tool that was being used rather than the data in the table itself.

Check out this link

boraldo · #3 (**permalink**) 01-08-11, 06:19

Here is a sequence of queries I've made.
My tool just uses jdbc.
But to make sure I made the last query by Java code.

Code:

create database myschema;
create table myschema.mytable (id int);
alter table myschema.mytable comment = 'qwe';

select TABLE_COMMENT from information_schema.TABLES
where TABLES.TABLE_SCHEMA = 'myschema' and TABLES.TABLE_NAME = 'mytable';

The result is

Code:

qwe; InnoDB free: 8192 kB

Internet Services

Web Development

Digital Marketing

Consumer Tech