← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/r/information_schema.result

Merged from trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/information_schema.result
52
52
show full columns from t3 like "a%";
53
53
Field   Type    Collation       Null    Key     Default Extra   Privileges      Comment
54
54
a       int(11) NULL    YES     MUL     NULL                    
55
 
show full columns from mysql.db like "Insert%";
56
 
Field   Type    Collation       Null    Key     Default Extra   Privileges      Comment
57
 
Insert_priv     enum('N','Y')   utf8_general_ci NO              NULL                    
58
55
select * from information_schema.COLUMNS where table_name="t1"
59
56
and column_name= "a";
60
57
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME     ORDINAL_POSITION        COLUMN_DEFAULT  IS_NULLABLE     DATA_TYPE       CHARACTER_MAXIMUM_LENGTH        CHARACTER_OCTET_LENGTH  NUMERIC_PRECISION       NUMERIC_SCALE   CHARACTER_SET_NAME      COLLATION_NAME  COLUMN_TYPE     COLUMN_KEY      EXTRA   PRIVILEGES      COLUMN_COMMENT  STORAGE FORMAT
140
137
select table_type from information_schema.tables
141
138
where table_schema="mysql" and table_name="user";
142
139
table_type
143
 
BASE TABLE
144
140
show open tables where `table` like "user";
145
141
Database        Table   In_use  Name_locked
146
142
show status where variable_name like "%database%";
198
194
WHERE table_name NOT LIKE 'ndb_%' AND table_name NOT LIKE 'falcon%' GROUP BY TABLE_SCHEMA;
199
195
table_schema    count(*)
200
196
information_schema      16
201
 
mysql   19
202
197
show create database information_schema;
203
198
Database        Create Database
204
199
information_schema      CREATE DATABASE "information_schema" /*!40100 DEFAULT CHARACTER SET utf8 */
380
375
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
381
376
SELECT MAX(table_name) FROM information_schema.tables;
382
377
MAX(table_name)
383
 
user
 
378
TABLE_CONSTRAINTS
384
379
SELECT table_name from information_schema.tables
385
380
WHERE table_name=(SELECT MAX(table_name)
386
381
FROM information_schema.tables);
387
382
table_name
388
 
user
 
383
TABLE_CONSTRAINTS
389
384
create table t1 (f1 int(11));
390
385
create table t2 (f1 int(11), f2 int(11));
391
386
select table_name from information_schema.tables
478
473
SELECT TABLE_COLLATION FROM INFORMATION_SCHEMA.TABLES
479
474
WHERE TABLE_SCHEMA='mysql' and TABLE_NAME= 'db';
480
475
TABLE_COLLATION
481
 
utf8_bin
482
476
select * from information_schema.columns where table_schema = NULL;
483
477
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME     ORDINAL_POSITION        COLUMN_DEFAULT  IS_NULLABLE     DATA_TYPE       CHARACTER_MAXIMUM_LENGTH        CHARACTER_OCTET_LENGTH  NUMERIC_PRECISION       NUMERIC_SCALE   CHARACTER_SET_NAME      COLLATION_NAME  COLUMN_TYPE     COLUMN_KEY      EXTRA   PRIVILEGES      COLUMN_COMMENT  STORAGE FORMAT
484
478
select * from `information_schema`.`COLUMNS` where `TABLE_NAME` = NULL;