~drizzle-trunk/drizzle/development

plugin_name IS NULL

GROUP BY TABLE_SCHEMA;

table_schema    count(*)

show create database information_schema;

Database        Create Database

information_schema      CREATE DATABASE `information_schema`

 or column_type = 'varchar(27)')

group by column_type order by column_type, num;

column_type     group_concat(table_schema, '.', table_name)     num

varchar(27)     information_schema.OLD_COLUMNS  1

create table t1(f1 char(1) not null, f2 char(9) not null);

select CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH from

OLD_GLOBAL_STATUS       VARIABLE_NAME

OLD_GLOBAL_VARIABLES    VARIABLE_NAME

OLD_KEY_COLUMN_USAGE    CONSTRAINT_SCHEMA

OLD_PROCESSLIST ID

OLD_REFERENTIAL_CONSTRAINTS     CONSTRAINT_SCHEMA

OLD_SCHEMATA    SCHEMA_NAME

OLD_GLOBAL_STATUS       VARIABLE_NAME

OLD_GLOBAL_VARIABLES    VARIABLE_NAME

OLD_KEY_COLUMN_USAGE    CONSTRAINT_SCHEMA

OLD_PROCESSLIST ID

OLD_REFERENTIAL_CONSTRAINTS     CONSTRAINT_SCHEMA

OLD_SCHEMATA    SCHEMA_NAME

group by c2.column_type order by num limit 1)

group by t.table_name order by num1, t.table_name;

table_name      group_concat(t.table_schema, '.', t.table_name) num1

alter database;

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '' at line 1

alter database test;

OLD_KEY_COLUMN_USAGE    ORDINAL_POSITION

OLD_KEY_COLUMN_USAGE    COLUMN_NAME

OLD_KEY_COLUMN_USAGE    TABLE_NAME

OLD_KEY_COLUMN_USAGE    TABLE_SCHEMA

OLD_PROCESSLIST INFO

OLD_PROCESSLIST STATE

OLD_PROCESSLIST TIME

information_schema      OLD_GLOBAL_STATUS

information_schema      OLD_GLOBAL_VARIABLES

information_schema      OLD_KEY_COLUMN_USAGE

information_schema      OLD_PROCESSLIST

information_schema      OLD_REFERENTIAL_CONSTRAINTS

information_schema      OLD_SCHEMATA