~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/embedded_innodb/tests/r/basic_innodb_table_proto_table.result

• browse files at revision 1405.5.5
• compare with another revision
• download diff
• download tarball
• view history from revision 1405.5.5

Show diffs side-by-side

added

removed

plugin/embedded_innodb/tests/r/basic_innodb_table_proto_table.result

 

1

show create table data_dictionary.innodb_table_definitions;

 

2

Table   Create Table

 

3

innodb_table_definitions        CREATE TABLE `innodb_table_definitions` (

 

4

  `table_name` varbinary(192) DEFAULT NULL,

 

5

  `message` blob,

 

6

  PRIMARY KEY (`table_name`) USING BTREE

 

7

) ENGINE=InnoDB

 

8

select * from data_dictionary.innodb_table_definitions;

 

9

table_name      message

 

10

use data_dictionary;

 

11

show tables like 'innodb%';

 

12

Tables_in_data_dictionary (innodb%)

 

13

innodb_table_definitions

 

14

use test;

 

15

create table t1 (a int primary key);

 

16

select table_name from data_dictionary.innodb_table_definitions;

 

17

table_name

 

18

test/t1

 

19

drop table t1;

 

20

select count(table_name) from data_dictionary.innodb_table_definitions;

 

21

count(table_name)

 

22

0

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1