~drizzle-trunk/drizzle/development

TABLE_CATALOG TABLE_SCHEMA TABLE_NAME NON_UNIQUE INDEX_SCHEMA INDEX_NAME SEQ_IN_INDEX COLUMN_NAME COLLATION CARDINALITY SUB_PART PACKED NULLABLE INDEX_TYPE COMMENT INDEX_COMMENT

NULL mysqltest t1 1 mysqltest string_data 1 b A 0 NULL NULL YES BTREE

show tables like 't%';

show full columns from t3 like "a%";

Field Type Collation Null Key Default Extra Privileges Comment

a int NULL YES MUL NULL #

select * from information_schema.COLUMNS where table_name="t1"

show columns from t3 like "a%";

Field Type Null Key Default Extra

a int YES MUL NULL

select * from information_schema.old_COLUMNS where table_name="t1"

and column_name= "a";

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

NULL mysqltest t1 a 1 NULL YES int NULL NULL 10 0 NULL NULL int Default Default

select table_name, column_name, privileges from information_schema.columns

select table_name, column_name, privileges from information_schema.old_columns

where table_schema = 'mysqltest' and table_name = 't1';

table_name column_name privileges

t1 a

b varchar(30) YES MUL NULL

drop tables mysqltest.t4, mysqltest.t1, t2, t3, t5;

drop database mysqltest;

select * from information_schema.CHARACTER_SETS

select * from data_dictionary.CHARACTER_SETS

where CHARACTER_SET_NAME like 'latin1%';

CHARACTER_SET_NAME DEFAULT_COLLATE_NAME DESCRIPTION MAXLEN

select * from information_schema.COLLATIONS

where COLLATION_NAME like 'latin1%';

COLLATION_NAME CHARACTER_SET_NAME DESCRIPTION ID IS_DEFAULT IS_COMPILED SORTLEN

select * from information_schema.COLLATION_CHARACTER_SET_APPLICABILITY

where COLLATION_NAME like 'latin1%';

COLLATION_NAME CHARACTER_SET_NAME

select * from information_schema.table_names;

ERROR 42S02: Unknown table 'table_names' in information_schema

select column_type from information_schema.columns

select * from data_dictionary.COLLATIONS

where COLLATION_NAME like 'latin1%';

CHARACTER_SET_NAME COLLATION_NAME DESCRIPTION ID IS_DEFAULT IS_COMPILED SORTLEN

select * from information_schema.old_table_names;

ERROR 42S02: Unknown table 'old_table_names' in information_schema

select column_type from information_schema.old_columns

where table_schema="information_schema" and table_name="COLUMNS" and

(column_name="character_set_name" or column_name="collation_name");

column_type

varchar(64)

select TABLE_ROWS from information_schema.tables where

select count(*) from data_dictionary.tables where

table_schema="information_schema" and table_name="COLUMNS";

TABLE_ROWS

select table_type from information_schema.tables

count(*)

select count(*) from data_dictionary.tables

where table_schema="mysql" and table_name="user";

table_type

select table_schema,table_name, column_name from

information_schema.columns

where data_type = 'longtext';

count(*)

select table_schema, table_name, column_name from data_dictionary.columns where data_type = 'longtext';

table_schema table_name column_name

select table_name, column_name, data_type from information_schema.columns

where data_type = 'datetime';

select table_name, column_name, data_type from data_dictionary.columns where data_type = 'datetime';

table_name column_name data_type

INNODB_TRX trx_started datetime

INNODB_TRX trx_wait_started datetime

TABLES CREATE_TIME datetime

TABLES UPDATE_TIME datetime

TABLES CHECK_TIME datetime

SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES A

SELECT COUNT(*) FROM data_dictionary.tables A

WHERE NOT EXISTS

(SELECT * FROM INFORMATION_SCHEMA.COLUMNS B

(SELECT * FROM data_dictionary.columns B

WHERE A.TABLE_SCHEMA = B.TABLE_SCHEMA

AND A.TABLE_NAME = B.TABLE_NAME);

COUNT(*)

107

x_float FLOAT,

108

x_double_precision DOUBLE PRECISION );

109

SELECT COLUMN_NAME, CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH

110

FROM INFORMATION_SCHEMA.COLUMNS

FROM data_dictionary.columns

111

WHERE TABLE_NAME= 't1';

112

COLUMN_NAME CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH

113

x_bigint NULL NULL

114

x_integer NULL NULL

115

x_int NULL NULL

116

x_decimal NULL NULL

117

x_numeric NULL NULL

118

x_real NULL NULL

119

x_float NULL NULL

120

x_double_precision NULL NULL

100

x_bigint 0 0

101

x_integer 0 0

102

x_int 0 0

103

x_decimal 0 0

104

x_numeric 0 0

105

x_real 0 0

106

x_float 0 0

107

x_double_precision 0 0

121

108

drop table t1;

122

SELECT table_schema, count(*) FROM information_schema.TABLES

109

SELECT table_schema, count(*) FROM data_dictionary.tables

123

110

WHERE table_name NOT LIKE 'ndb_%' AND

124

table_name NOT LIKE 'falcon%' AND

125

plugin_name IS NULL

126

GROUP BY TABLE_SCHEMA;

111

table_name NOT LIKE 'falcon%'

112

GROUP BY TABLE_SCHEMA ORDER BY table_schema;

127

113

table_schema count(*)

128

information_schema 24

114

information_schema 16

129

115

show create database information_schema;

130

116

Database Create Database

131

117

information_schema CREATE DATABASE `information_schema`

132

118

create table t1(f1 LONGBLOB, f2 LONGTEXT);

133

119

select column_name,data_type,CHARACTER_OCTET_LENGTH,

134

120

CHARACTER_MAXIMUM_LENGTH

135

from information_schema.columns

121

from information_schema.old_columns

136

122

where table_name='t1';

137

123

column_name data_type CHARACTER_OCTET_LENGTH CHARACTER_MAXIMUM_LENGTH

138

124

f1 blob 4294967295 4294967295

141

127

create table t1(f1 int, f2 int, f3 BIGINT, f4 int,

142

128

f5 BIGINT, f6 int, f7 int);

143

129

select column_name, NUMERIC_PRECISION, NUMERIC_SCALE

144

from information_schema.columns

130

from information_schema.old_columns

145

131

where table_name='t1';

146

132

column_name NUMERIC_PRECISION NUMERIC_SCALE

147

133

f1 10 0

154

140

drop table t1;

155

141

create table t1 (a int not null, b int);

156

142

use information_schema;

157

select column_name, column_default from columns

143

select column_name, column_default from information_schema.old_columns

158

144

where table_schema='test' and table_name='t1';

159

145

column_name column_default

160

146

a NULL

170

156

drop database information_schema;

171

157

ERROR 42000: Access denied for user ''@'' to database 'information_schema'

172

158

use information_schema;

173

drop table tables;

174

ERROR 42000: Access denied for user ''@'' to database 'information_schema'

175

alter table tables;

176

ERROR 42000: Access denied for user ''@'' to database 'information_schema'

159

drop table old_tables;

160

ERROR 42S02: Unknown table 'old_tables' in information_schema

161

alter table old_tables;

162

ERROR 42S02: Unknown table 'old_tables' in information_schema

177

163

use information_schema;

178

create temporary table schemata(f1 char(10));

164

create temporary table OLD_TABLE_CONSTRAINTS(f1 char(10));

179

165

ERROR 42000: Access denied for user ''@'' to database 'information_schema'

180

166

use test;

181

167

create table t1(id int);

202

188

drop table t1;

203

189

create table t1(f1 varbinary(32), f2 varbinary(64));

204

190

select character_maximum_length, character_octet_length

205

from information_schema.columns where table_name='t1';

191

from information_schema.old_columns where table_name='t1';

206

192

character_maximum_length character_octet_length

207

193

32 32

208

194

64 64

209

195

drop table t1;

210

196

select column_type, group_concat(table_schema, '.', table_name), count(*) as num

211

from information_schema.columns where

197

from information_schema.old_columns where

212

198

table_schema='information_schema' and

213

199

(column_type = 'varchar(7)' or column_type = 'varchar(20)'

214

200

or column_type = 'varchar(27)')

215

201

group by column_type order by column_type, num;

216

202

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

217

varchar(20) information_schema.MODULES 1

218

varchar(27) information_schema.COLUMNS 1

203

varchar(27) information_schema.OLD_COLUMNS 1

219

204

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

220

205

select CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH from

221

information_schema.columns where table_schema='test' and table_name = 't1';

206

information_schema.old_columns where table_schema='test' and table_name = 't1';

222

207

CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH

223

208

1 4

224

209

9 36

227

212

create table t1(f1 char(5));

228

213

create table t2(f1 char(5));

229

214

select concat(@a, table_name), @a, table_name

230

from information_schema.tables where table_schema = 'test';

215

from data_dictionary.tables where table_schema = 'test';

231

216

concat(@a, table_name) @a table_name

232

217

.t1 . t1

233

218

.t2 . t2

234

219

drop table t1,t2;

235

220

SELECT t.table_name, c1.column_name

236

FROM information_schema.tables t

221

FROM data_dictionary.tables t

237

222

INNER JOIN

238

information_schema.columns c1

223

information_schema.old_columns c1

239

224

ON t.table_schema = c1.table_schema AND

240

225

t.table_name = c1.table_name

241

226

WHERE t.table_schema = 'information_schema' AND

242

227

c1.ordinal_position =

243

228

( SELECT COALESCE(MIN(c2.ordinal_position),1)

244

FROM information_schema.columns c2

229

FROM information_schema.old_columns c2

245

230

WHERE c2.table_schema = t.table_schema AND

246

231

c2.table_name = t.table_name AND

247

232

c2.column_name LIKE '%SCHEMA%'

248

233

)

249

234

AND t.table_name NOT LIKE 'falcon%'

250

AND t.plugin_name IS NULL;

235

ORDER BY t.table_name, c1.column_name;

251

236

table_name column_name

252

CHARACTER_SETS CHARACTER_SET_NAME

253

COLLATIONS COLLATION_NAME

254

COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME

255

COLUMNS TABLE_SCHEMA

256

GLOBAL_STATUS VARIABLE_NAME

257

GLOBAL_VARIABLES VARIABLE_NAME

258

237

INNODB_CMP page_size

259

238

INNODB_CMPMEM page_size

260

239

INNODB_CMPMEM_RESET page_size

262

241

INNODB_LOCKS lock_id

263

242

INNODB_LOCK_WAITS requesting_trx_id

264

243

INNODB_TRX trx_id

265

KEY_COLUMN_USAGE CONSTRAINT_SCHEMA

266

MODULES MODULE_NAME

267

PLUGINS PLUGIN_NAME

268

PROCESSLIST ID

269

REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA

270

SCHEMATA SCHEMA_NAME

271

SESSION_STATUS VARIABLE_NAME

272

SESSION_VARIABLES VARIABLE_NAME

273

STATISTICS TABLE_SCHEMA

274

TABLES TABLE_SCHEMA

275

TABLE_CONSTRAINTS CONSTRAINT_SCHEMA

244

OLD_COLUMNS TABLE_SCHEMA

245

OLD_GLOBAL_STATUS VARIABLE_NAME

246

OLD_GLOBAL_VARIABLES VARIABLE_NAME

247

OLD_KEY_COLUMN_USAGE CONSTRAINT_SCHEMA

248

OLD_REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA

249

OLD_SESSION_VARIABLES VARIABLE_NAME

250

OLD_STATISTICS TABLE_SCHEMA

251

OLD_TABLE_CONSTRAINTS CONSTRAINT_SCHEMA

252

OPEN_SESSION_STATUS VARIABLE_NAME

276

253

SELECT t.table_name, c1.column_name

277

FROM information_schema.tables t

254

FROM data_dictionary.tables t

278

255

INNER JOIN

279

information_schema.columns c1

256

information_schema.old_columns c1

280

257

ON t.table_schema = c1.table_schema AND

281

258

t.table_name = c1.table_name

282

259

WHERE t.table_schema = 'information_schema' AND

283

260

c1.ordinal_position =

284

261

( SELECT COALESCE(MIN(c2.ordinal_position),1)

285

FROM information_schema.columns c2

262

FROM information_schema.old_columns c2

286

263

WHERE c2.table_schema = 'information_schema' AND

287

264

c2.table_name = t.table_name AND

288

265

c2.column_name LIKE '%SCHEMA%'

289

266

)

290

267

AND t.table_name NOT LIKE 'falcon%'

291

AND t.plugin_name IS NULL;

268

ORDER BY t.table_name, c1.column_name;

292

269

table_name column_name

293

CHARACTER_SETS CHARACTER_SET_NAME

294

COLLATIONS COLLATION_NAME

295

COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME

296

COLUMNS TABLE_SCHEMA

297

GLOBAL_STATUS VARIABLE_NAME

298

GLOBAL_VARIABLES VARIABLE_NAME

299

270

INNODB_CMP page_size

300

271

INNODB_CMPMEM page_size

301

272

INNODB_CMPMEM_RESET page_size

303

274

INNODB_LOCKS lock_id

304

275

INNODB_LOCK_WAITS requesting_trx_id

305

276

INNODB_TRX trx_id

306

KEY_COLUMN_USAGE CONSTRAINT_SCHEMA

307

MODULES MODULE_NAME

308

PLUGINS PLUGIN_NAME

309

PROCESSLIST ID

310

REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA

311

SCHEMATA SCHEMA_NAME

312

SESSION_STATUS VARIABLE_NAME

313

SESSION_VARIABLES VARIABLE_NAME

314

STATISTICS TABLE_SCHEMA

315

TABLES TABLE_SCHEMA

316

TABLE_CONSTRAINTS CONSTRAINT_SCHEMA

317

SELECT MAX(table_name) FROM information_schema.tables;

277

OLD_COLUMNS TABLE_SCHEMA

278

OLD_GLOBAL_STATUS VARIABLE_NAME

279

OLD_GLOBAL_VARIABLES VARIABLE_NAME

280

OLD_KEY_COLUMN_USAGE CONSTRAINT_SCHEMA

281

OLD_REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA

282

OLD_SESSION_VARIABLES VARIABLE_NAME

283

OLD_STATISTICS TABLE_SCHEMA

284

OLD_TABLE_CONSTRAINTS CONSTRAINT_SCHEMA

285

OPEN_SESSION_STATUS VARIABLE_NAME

286

SELECT MAX(table_name) FROM data_dictionary.tables;

318

287

MAX(table_name)

319

TABLE_CONSTRAINTS

320

SELECT table_name from information_schema.tables

288

OPEN_SESSION_STATUS

289

SELECT table_name from data_dictionary.tables

321

290

WHERE table_name=(SELECT MAX(table_name)

322

FROM information_schema.tables);

291

FROM data_dictionary.tables)

292

ORDER BY table_name;

323

293

table_name

324

TABLE_CONSTRAINTS

294

OPEN_SESSION_STATUS

325

295

create table t1 (f1 int);

326

296

create table t2 (f1 int, f2 int);

327

select table_name from information_schema.tables

297

select table_name from data_dictionary.tables

328

298

where table_schema = 'test' and table_name not in

329

(select table_name from information_schema.columns

330

where table_schema = 'test' and column_name = 'f3');

299

(select table_name from information_schema.old_columns

300

where table_schema = 'test' and column_name = 'f3')

301

ORDER BY table_name;

331

302

table_name

332

303

333

304

334

305

drop table t1,t2;

335

select 1 as f1 from information_schema.tables where "CHARACTER_SETS"=

336

(select cast(table_name as char) from information_schema.tables

306

select 1 as f1 from data_dictionary.tables where "CHARACTER_SETS"=

307

(select cast(table_name as char) from data_dictionary.tables

337

308

order by table_name limit 1) limit 1;

338

309

339

340

310

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

341

311

count(*) as num1

342

from information_schema.tables t

343

inner join information_schema.columns c1

312

from data_dictionary.tables t

313

inner join information_schema.old_columns c1

344

314

on t.table_schema = c1.table_schema AND t.table_name = c1.table_name

345

315

where t.table_schema = 'information_schema' AND

346

316

t.table_name not like 'falcon%' AND

347

t.plugin_name IS NULL AND

348

317

c1.ordinal_position =

349

318

(select isnull(c2.column_type) -

350

319

isnull(group_concat(c2.table_schema, '.', c2.table_name)) +

351

320

count(*) as num

352

from information_schema.columns c2 where

321

from information_schema.old_columns c2 where

353

322

c2.table_schema='information_schema' and

354

323

(c2.column_type = 'varchar(7)' or c2.column_type = 'varchar(20)')

355

324

group by c2.column_type order by num limit 1)

356

325

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

357

326

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

358

CHARACTER_SETS information_schema.CHARACTER_SETS 1

359

COLLATIONS information_schema.COLLATIONS 1

360

COLLATION_CHARACTER_SET_APPLICABILITY information_schema.COLLATION_CHARACTER_SET_APPLICABILITY 1

361

COLUMNS information_schema.COLUMNS 1

362

GLOBAL_STATUS information_schema.GLOBAL_STATUS 1

363

GLOBAL_VARIABLES information_schema.GLOBAL_VARIABLES 1

364

INNODB_CMP information_schema.INNODB_CMP 1

365

INNODB_CMPMEM information_schema.INNODB_CMPMEM 1

366

INNODB_CMPMEM_RESET information_schema.INNODB_CMPMEM_RESET 1

367

INNODB_CMP_RESET information_schema.INNODB_CMP_RESET 1

368

INNODB_LOCKS information_schema.INNODB_LOCKS 1

369

INNODB_LOCK_WAITS information_schema.INNODB_LOCK_WAITS 1

370

INNODB_TRX information_schema.INNODB_TRX 1

371

KEY_COLUMN_USAGE information_schema.KEY_COLUMN_USAGE 1

372

MODULES information_schema.MODULES 1

373

PLUGINS information_schema.PLUGINS 1

374

PROCESSLIST information_schema.PROCESSLIST 1

375

REFERENTIAL_CONSTRAINTS information_schema.REFERENTIAL_CONSTRAINTS 1

376

SCHEMATA information_schema.SCHEMATA 1

377

SESSION_STATUS information_schema.SESSION_STATUS 1

378

SESSION_VARIABLES information_schema.SESSION_VARIABLES 1

379

STATISTICS information_schema.STATISTICS 1

380

TABLES information_schema.TABLES 1

381

TABLE_CONSTRAINTS information_schema.TABLE_CONSTRAINTS 1

382

327

alter database;

383

328

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

384

329

alter database test;

393

338

f7 datetime not null,

394

339

f8 datetime default '2006-01-01'

395

340

);

396

select column_default from information_schema.columns where table_name= 't1';

341

select column_default from information_schema.old_columns where table_name= 't1' ORDER BY column_default;

397

342

column_default

398

343

NULL

399

344

NULL

345

NULL

346

NULL

347

NULL

400

348

401

NULL

402

NULL

403

349

404

NULL

405

350

2006-01-01 00:00:00

406

351

show columns from t1;

407

352

Field Type Null Key Default Extra

414

359

f7 datetime NO NULL

415

360

f8 datetime YES 2006-01-01 00:00:00

416

361

drop table t1;

417

show fields from information_schema.table_names;

418

ERROR 42S02: Unknown table 'table_names' in information_schema

419

show keys from information_schema.table_names;

420

ERROR 42S02: Unknown table 'table_names' in information_schema

362

show fields from information_schema.old_table_names;

363

ERROR 42S02: Unknown table 'old_table_names' in information_schema

364

show keys from information_schema.old_table_names;

365

ERROR 42S02: Unknown table 'old_table_names' in information_schema

421

366

SET max_heap_table_size = DEFAULT;

422

367

USE test;

423

368

End of 5.0 tests.

424

SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA

369

SELECT SCHEMA_NAME FROM data_dictionary.schemas

425

370

WHERE SCHEMA_NAME ='information_schema';

426

371

SCHEMA_NAME

427

372

information_schema

428

SELECT TABLE_COLLATION FROM INFORMATION_SCHEMA.TABLES

373

SELECT TABLE_COLLATION FROM data_dictionary.tables

429

374

WHERE TABLE_SCHEMA='mysql' and TABLE_NAME= 'db';

430

375

TABLE_COLLATION

431

select * from information_schema.columns where table_schema = NULL;

432

433

select * from `information_schema`.`COLUMNS` where `TABLE_NAME` = NULL;

434

435

select * from `information_schema`.`KEY_COLUMN_USAGE` where `TABLE_SCHEMA` = NULL;

436

CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION POSITION_IN_UNIQUE_CONSTRAINT REFERENCED_TABLE_SCHEMA REFERENCED_TABLE_NAME REFERENCED_COLUMN_NAME

437

select * from `information_schema`.`KEY_COLUMN_USAGE` where `TABLE_NAME` = NULL;

438

439

select * from `information_schema`.`REFERENTIAL_CONSTRAINTS` where `CONSTRAINT_SCHEMA` = NULL;

440

CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME UNIQUE_CONSTRAINT_CATALOG UNIQUE_CONSTRAINT_SCHEMA UNIQUE_CONSTRAINT_NAME MATCH_OPTION UPDATE_RULE DELETE_RULE TABLE_NAME REFERENCED_TABLE_NAME

441

select * from `information_schema`.`REFERENTIAL_CONSTRAINTS` where `TABLE_NAME` = NULL;

442

CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME UNIQUE_CONSTRAINT_CATALOG UNIQUE_CONSTRAINT_SCHEMA UNIQUE_CONSTRAINT_NAME MATCH_OPTION UPDATE_RULE DELETE_RULE TABLE_NAME REFERENCED_TABLE_NAME

443

select * from information_schema.schemata where schema_name = NULL;

444

CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH

445

select * from `information_schema`.`STATISTICS` where `TABLE_SCHEMA` = NULL;

446

TABLE_CATALOG TABLE_SCHEMA TABLE_NAME NON_UNIQUE INDEX_SCHEMA INDEX_NAME SEQ_IN_INDEX COLUMN_NAME COLLATION CARDINALITY SUB_PART PACKED NULLABLE INDEX_TYPE COMMENT INDEX_COMMENT

447

select * from `information_schema`.`STATISTICS` where `TABLE_NAME` = NULL;

448

TABLE_CATALOG TABLE_SCHEMA TABLE_NAME NON_UNIQUE INDEX_SCHEMA INDEX_NAME SEQ_IN_INDEX COLUMN_NAME COLLATION CARDINALITY SUB_PART PACKED NULLABLE INDEX_TYPE COMMENT INDEX_COMMENT

449

select * from information_schema.tables where table_schema = NULL;

450

TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT PLUGIN_NAME

451

select * from information_schema.tables where table_catalog = NULL;

452

453

select * from information_schema.tables where table_name = NULL;

454

455

select * from `information_schema`.`TABLE_CONSTRAINTS` where `TABLE_SCHEMA` = NULL;

376

select * from data_dictionary.columns where table_schema = NULL;

377

TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE COLLATION_NAME COLUMN_COMMENT

378

select * from `data_dictionary`.`columns` where `TABLE_NAME` = NULL;

379

TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE COLLATION_NAME COLUMN_COMMENT

380

select * from `information_schema`.`OLD_KEY_COLUMN_USAGE` where `TABLE_SCHEMA` = NULL;

381

382

select * from `information_schema`.`OLD_KEY_COLUMN_USAGE` where `TABLE_NAME` = NULL;

383

384

select * from `information_schema`.`OLD_REFERENTIAL_CONSTRAINTS` where `CONSTRAINT_SCHEMA` = NULL;

385

CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME UNIQUE_CONSTRAINT_CATALOG UNIQUE_CONSTRAINT_SCHEMA UNIQUE_CONSTRAINT_NAME MATCH_OPTION UPDATE_RULE DELETE_RULE TABLE_NAME REFERENCED_TABLE_NAME

386

select * from `information_schema`.`OLD_REFERENTIAL_CONSTRAINTS` where `TABLE_NAME` = NULL;

387

CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME UNIQUE_CONSTRAINT_CATALOG UNIQUE_CONSTRAINT_SCHEMA UNIQUE_CONSTRAINT_NAME MATCH_OPTION UPDATE_RULE DELETE_RULE TABLE_NAME REFERENCED_TABLE_NAME

388

select * from data_dictionary.schemas where schema_name = NULL;

389

SCHEMA_NAME DEFAULT_COLLATION_NAME

390

select * from `information_schema`.`OLD_STATISTICS` where `TABLE_SCHEMA` = NULL;

391

TABLE_CATALOG TABLE_SCHEMA TABLE_NAME NON_UNIQUE INDEX_SCHEMA INDEX_NAME SEQ_IN_INDEX COLUMN_NAME COLLATION CARDINALITY SUB_PART PACKED NULLABLE INDEX_TYPE COMMENT INDEX_COMMENT

392

select * from `information_schema`.`OLD_STATISTICS` where `TABLE_NAME` = NULL;

393

TABLE_CATALOG TABLE_SCHEMA TABLE_NAME NON_UNIQUE INDEX_SCHEMA INDEX_NAME SEQ_IN_INDEX COLUMN_NAME COLLATION CARDINALITY SUB_PART PACKED NULLABLE INDEX_TYPE COMMENT INDEX_COMMENT

394

select * from data_dictionary.tables where table_schema = NULL;

395

TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE ROW_FORMAT TABLE_COLLATION TABLE_COMMENT

396

select * from data_dictionary.tables where table_name = NULL;

397

TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE ROW_FORMAT TABLE_COLLATION TABLE_COMMENT

398

select * from `information_schema`.`OLD_TABLE_CONSTRAINTS` where `TABLE_SCHEMA` = NULL;

456

399

CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE

457

select * from `information_schema`.`TABLE_CONSTRAINTS` where `TABLE_NAME` = NULL;

400

select * from `information_schema`.`OLD_TABLE_CONSTRAINTS` where `TABLE_NAME` = NULL;

458

401

CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE

459

402

460

403

# Test that the query is visible to self and others.

461

404

462

SELECT info FROM information_schema.processlist WHERE id = CONNECTION_ID();

405

SELECT info FROM data_dictionary.processlist WHERE id = CONNECTION_ID();

463

406

info

464

SELECT info FROM information_schema.processlist WHERE id = CONNECTION_ID()

407

SELECT info FROM data_dictionary.processlist WHERE id = CONNECTION_ID()

465

408

show processlist;

466

Id User Host db Command Time State Info

409

ID USER HOST DB COMMAND TIME STATE INFO

467

410

# # # test Query # # show processlist

468

# # # test Sleep # #

469

# # # mysqltest Sleep # #

411

# # # test Sleep # # show processlist

412

# # # mysqltest Sleep # # show processlist

470

413

SELECT info, command, db

471

FROM information_schema.processlist

414

FROM data_dictionary.processlist

472

415

WHERE id = CONNECTION_ID();

473

416

info command db

474

417

SELECT info, command, db

475

FROM information_schema.processlist

418

FROM data_dictionary.processlist

476

419

WHERE id = CONNECTION_ID() Query test

477

420

SELECT *

478

FROM information_schema.character_sets

421

FROM data_dictionary.character_sets

479

422

ORDER BY character_set_name;

480

423

CHARACTER_SET_NAME DEFAULT_COLLATE_NAME DESCRIPTION MAXLEN

481

binary binary 1

424

binary binary UTF-8 Unicode 1

482

425

utf8 utf8_general_ci UTF-8 Unicode 4

483

426

SELECT *

484

FROM information_schema.collations

485

ORDER BY collation_name;

486

COLLATION_NAME CHARACTER_SET_NAME DESCRIPTION ID IS_DEFAULT IS_COMPILED SORTLEN

487

binary binary 63 0 Yes 1 0

488

utf8_bin utf8 46 0 Yes 1 0

489

utf8_czech_ci utf8 234 0 Yes 8 0

490

utf8_danish_ci utf8 235 0 Yes 8 0

491

utf8_esperanto_ci utf8 241 0 Yes 8 0

492

utf8_estonian_ci utf8 230 0 Yes 8 0

493

utf8_general_ci utf8 45 0 Yes 1 0

494

utf8_hungarian_ci utf8 242 0 Yes 8 0

495

utf8_icelandic_ci utf8 225 0 Yes 8 0

496

utf8_latvian_ci utf8 226 0 Yes 8 0

497

utf8_lithuanian_ci utf8 236 0 Yes 8 0

498

utf8_persian_ci utf8 240 0 Yes 8 0

499

utf8_polish_ci utf8 229 0 Yes 8 0

500

utf8_romanian_ci utf8 227 0 Yes 8 0

501

utf8_roman_ci utf8 239 0 Yes 8 0

502

utf8_sinhala_ci utf8 243 0 Yes 8 0

503

utf8_slovak_ci utf8 237 0 Yes 8 0

504

utf8_slovenian_ci utf8 228 0 Yes 8 0

505

utf8_spanish2_ci utf8 238 0 Yes 8 0

506

utf8_spanish_ci utf8 231 0 Yes 8 0

507

utf8_swedish_ci utf8 232 0 Yes 8 0

508

utf8_turkish_ci utf8 233 0 Yes 8 0

509

utf8_unicode_ci utf8 224 0 Yes 8 0

510

SELECT *

511

FROM information_schema.collation_character_set_applicability

512

ORDER BY collation_name;

513

COLLATION_NAME CHARACTER_SET_NAME

514

binary binary

515

utf8_bin utf8

516

utf8_czech_ci utf8

517

utf8_danish_ci utf8

518

utf8_esperanto_ci utf8

519

utf8_estonian_ci utf8

520

utf8_general_ci utf8

521

utf8_hungarian_ci utf8

522

utf8_icelandic_ci utf8

523

utf8_latvian_ci utf8

524

utf8_lithuanian_ci utf8

525

utf8_persian_ci utf8

526

utf8_polish_ci utf8

527

utf8_romanian_ci utf8

528

utf8_roman_ci utf8

529

utf8_sinhala_ci utf8

530

utf8_slovak_ci utf8

531

utf8_slovenian_ci utf8

532

utf8_spanish2_ci utf8

533

utf8_spanish_ci utf8

534

utf8_swedish_ci utf8

535

utf8_turkish_ci utf8

536

utf8_unicode_ci utf8

427

FROM data_dictionary.collations

428

ORDER BY collation_name;

429

CHARACTER_SET_NAME COLLATION_NAME DESCRIPTION ID IS_DEFAULT IS_COMPILED SORTLEN

430

binary binary binary 63 TRUE TRUE 1

431

utf8_general_ci utf8_bin utf8 46 FALSE TRUE 1

432

utf8_general_ci utf8_czech_ci utf8 234 FALSE TRUE 8

433

utf8_general_ci utf8_danish_ci utf8 235 FALSE TRUE 8

434

utf8_general_ci utf8_esperanto_ci utf8 241 FALSE TRUE 8

435

utf8_general_ci utf8_estonian_ci utf8 230 FALSE TRUE 8

436

utf8_general_ci utf8_general_ci utf8 45 TRUE TRUE 1

437

utf8_general_ci utf8_hungarian_ci utf8 242 FALSE TRUE 8

438

utf8_general_ci utf8_icelandic_ci utf8 225 FALSE TRUE 8

439

utf8_general_ci utf8_latvian_ci utf8 226 FALSE TRUE 8

440

utf8_general_ci utf8_lithuanian_ci utf8 236 FALSE TRUE 8

441

utf8_general_ci utf8_persian_ci utf8 240 FALSE TRUE 8

442

utf8_general_ci utf8_polish_ci utf8 229 FALSE TRUE 8

443

utf8_general_ci utf8_romanian_ci utf8 227 FALSE TRUE 8

444

utf8_general_ci utf8_roman_ci utf8 239 FALSE TRUE 8

445

utf8_general_ci utf8_sinhala_ci utf8 243 FALSE TRUE 8

446

utf8_general_ci utf8_slovak_ci utf8 237 FALSE TRUE 8

447

utf8_general_ci utf8_slovenian_ci utf8 228 FALSE TRUE 8

448

utf8_general_ci utf8_spanish2_ci utf8 238 FALSE TRUE 8

449

utf8_general_ci utf8_spanish_ci utf8 231 FALSE TRUE 8

450

utf8_general_ci utf8_swedish_ci utf8 232 FALSE TRUE 8

451

utf8_general_ci utf8_turkish_ci utf8 233 FALSE TRUE 8

452

utf8_general_ci utf8_unicode_ci utf8 224 FALSE TRUE 8

537

453

SELECT table_name, column_name

538

FROM information_schema.columns

454

FROM data_dictionary.columns

539

455

WHERE table_name IN

540

(SELECT table_name FROM information_schema.tables

541

WHERE plugin_name IS NULL)

456

(SELECT table_name FROM data_dictionary.tables )

542

457

ORDER BY table_name;

543

458

table_name column_name

544

CHARACTER_SETS CHARACTER_SET_NAME

545

CHARACTER_SETS DEFAULT_COLLATE_NAME

546

CHARACTER_SETS DESCRIPTION

547

CHARACTER_SETS MAXLEN

548

COLLATIONS SORTLEN

549

COLLATIONS IS_COMPILED

550

COLLATIONS IS_DEFAULT

551

COLLATIONS ID

552

COLLATIONS DESCRIPTION

553

COLLATIONS CHARACTER_SET_NAME

554

COLLATIONS COLLATION_NAME

555

COLLATION_CHARACTER_SET_APPLICABILITY CHARACTER_SET_NAME

556

COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME

557

COLUMNS CHARACTER_SET_NAME

558

COLUMNS COLLATION_NAME

559

COLUMNS COLUMN_TYPE

560

COLUMNS COLUMN_KEY

561

COLUMNS EXTRA

562

COLUMNS PRIVILEGES

563

COLUMNS COLUMN_COMMENT

564

COLUMNS STORAGE

565

COLUMNS FORMAT

566

COLUMNS NUMERIC_SCALE

567

COLUMNS NUMERIC_PRECISION

568

COLUMNS CHARACTER_OCTET_LENGTH

569

COLUMNS TABLE_CATALOG

570

COLUMNS TABLE_SCHEMA

571

COLUMNS TABLE_NAME

572

COLUMNS COLUMN_NAME

573

COLUMNS ORDINAL_POSITION

574

COLUMNS COLUMN_DEFAULT

575

COLUMNS IS_NULLABLE

576

COLUMNS DATA_TYPE

577

COLUMNS CHARACTER_MAXIMUM_LENGTH

578

GLOBAL_STATUS VARIABLE_VALUE

579

GLOBAL_STATUS VARIABLE_NAME

580

GLOBAL_VARIABLES VARIABLE_NAME

581

GLOBAL_VARIABLES VARIABLE_VALUE

459

INNODB_CMP page_size

460

INNODB_CMP compress_ops

461

INNODB_CMP compress_ops_ok

462

INNODB_CMP compress_time

463

INNODB_CMP uncompress_ops

582

464

INNODB_CMP uncompress_time

583

INNODB_CMP uncompress_ops

584

INNODB_CMP compress_time

585

INNODB_CMP compress_ops_ok

586

INNODB_CMP compress_ops

587

INNODB_CMP page_size

588

465

INNODB_CMPMEM relocation_time

589

466

INNODB_CMPMEM relocation_ops

590

467

INNODB_CMPMEM pages_free

623

500

INNODB_TRX trx_started

624

501

INNODB_TRX trx_state

625

502

INNODB_TRX trx_id

626

KEY_COLUMN_USAGE ORDINAL_POSITION

627

KEY_COLUMN_USAGE POSITION_IN_UNIQUE_CONSTRAINT

628

KEY_COLUMN_USAGE REFERENCED_TABLE_SCHEMA

629

KEY_COLUMN_USAGE REFERENCED_TABLE_NAME

630

KEY_COLUMN_USAGE REFERENCED_COLUMN_NAME

631

KEY_COLUMN_USAGE COLUMN_NAME

632

KEY_COLUMN_USAGE TABLE_NAME

633

KEY_COLUMN_USAGE TABLE_SCHEMA

634

KEY_COLUMN_USAGE TABLE_CATALOG

635

KEY_COLUMN_USAGE CONSTRAINT_NAME

636

KEY_COLUMN_USAGE CONSTRAINT_SCHEMA

637

KEY_COLUMN_USAGE CONSTRAINT_CATALOG

638

MODULES MODULE_LICENSE

639

MODULES MODULE_DESCRIPTION

640

MODULES MODULE_LIBRARY

641

MODULES IS_BUILTIN

642

MODULES MODULE_AUTHOR

643

MODULES MODULE_VERSION

644

MODULES MODULE_NAME

645

PLUGINS MODULE_NAME

646

PLUGINS IS_ACTIVE

647

PLUGINS PLUGIN_TYPE

648

PLUGINS PLUGIN_NAME

649

PROCESSLIST INFO

650

PROCESSLIST STATE

651

PROCESSLIST TIME

652

PROCESSLIST COMMAND

653

PROCESSLIST DB

654

PROCESSLIST HOST

655

PROCESSLIST USER

656

PROCESSLIST ID

657

REFERENTIAL_CONSTRAINTS REFERENCED_TABLE_NAME

658

REFERENTIAL_CONSTRAINTS TABLE_NAME

659

REFERENTIAL_CONSTRAINTS DELETE_RULE

660

REFERENTIAL_CONSTRAINTS UPDATE_RULE

661

REFERENTIAL_CONSTRAINTS MATCH_OPTION

662

REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_NAME

663

REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_SCHEMA

664

REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_CATALOG

665

REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME

666

REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA

667

REFERENTIAL_CONSTRAINTS CONSTRAINT_CATALOG

668

SCHEMATA SQL_PATH

669

SCHEMATA DEFAULT_COLLATION_NAME

670

SCHEMATA DEFAULT_CHARACTER_SET_NAME

671

SCHEMATA SCHEMA_NAME

672

SCHEMATA CATALOG_NAME

673

SESSION_STATUS VARIABLE_NAME

674

SESSION_STATUS VARIABLE_VALUE

675

SESSION_VARIABLES VARIABLE_VALUE

676

SESSION_VARIABLES VARIABLE_NAME

677

STATISTICS INDEX_COMMENT

678

STATISTICS COMMENT

679

STATISTICS INDEX_TYPE

680

STATISTICS NULLABLE

681

STATISTICS PACKED

682

STATISTICS SUB_PART

683

STATISTICS CARDINALITY

684

STATISTICS COLLATION

685

STATISTICS COLUMN_NAME

686

STATISTICS TABLE_CATALOG

687

STATISTICS TABLE_SCHEMA

688

STATISTICS TABLE_NAME

689

STATISTICS NON_UNIQUE

690

STATISTICS INDEX_SCHEMA

691

STATISTICS INDEX_NAME

692

STATISTICS SEQ_IN_INDEX

693

TABLES DATA_FREE

694

TABLES AUTO_INCREMENT

695

TABLES CREATE_TIME

696

TABLES UPDATE_TIME

697

TABLES CHECK_TIME

698

TABLES TABLE_COLLATION

699

TABLES CHECKSUM

700

TABLES CREATE_OPTIONS

701

TABLES TABLE_COMMENT

702

TABLES PLUGIN_NAME

703

TABLES INDEX_LENGTH

704

TABLES MAX_DATA_LENGTH

705

TABLES TABLE_CATALOG

706

TABLES TABLE_SCHEMA

707

TABLES TABLE_NAME

708

TABLES TABLE_TYPE

709

TABLES ENGINE

710

TABLES VERSION

711

TABLES ROW_FORMAT

712

TABLES TABLE_ROWS

713

TABLES AVG_ROW_LENGTH

714

TABLES DATA_LENGTH

715

TABLE_CONSTRAINTS TABLE_NAME

716

TABLE_CONSTRAINTS TABLE_SCHEMA

717

TABLE_CONSTRAINTS CONSTRAINT_NAME

718

TABLE_CONSTRAINTS CONSTRAINT_SCHEMA

719

TABLE_CONSTRAINTS CONSTRAINT_CATALOG

720

TABLE_CONSTRAINTS CONSTRAINT_TYPE

503

OLD_COLUMNS CHARACTER_SET_NAME

504

OLD_COLUMNS COLLATION_NAME

505

OLD_COLUMNS COLUMN_TYPE

506

OLD_COLUMNS COLUMN_KEY

507

OLD_COLUMNS EXTRA

508

OLD_COLUMNS PRIVILEGES

509

OLD_COLUMNS COLUMN_COMMENT

510

OLD_COLUMNS STORAGE

511

OLD_COLUMNS FORMAT

512

OLD_COLUMNS NUMERIC_SCALE

513

OLD_COLUMNS NUMERIC_PRECISION

514

OLD_COLUMNS CHARACTER_OCTET_LENGTH

515

OLD_COLUMNS TABLE_CATALOG

516

OLD_COLUMNS TABLE_SCHEMA

517

OLD_COLUMNS TABLE_NAME

518

OLD_COLUMNS COLUMN_NAME

519

OLD_COLUMNS ORDINAL_POSITION

520

OLD_COLUMNS COLUMN_DEFAULT

521

OLD_COLUMNS IS_NULLABLE

522

OLD_COLUMNS DATA_TYPE

523

OLD_COLUMNS CHARACTER_MAXIMUM_LENGTH

524

OLD_GLOBAL_STATUS VARIABLE_VALUE

525

OLD_GLOBAL_STATUS VARIABLE_NAME

526

OLD_GLOBAL_VARIABLES VARIABLE_NAME

527

OLD_GLOBAL_VARIABLES VARIABLE_VALUE

528

OLD_KEY_COLUMN_USAGE REFERENCED_COLUMN_NAME

529

OLD_KEY_COLUMN_USAGE REFERENCED_TABLE_NAME

530

OLD_KEY_COLUMN_USAGE REFERENCED_TABLE_SCHEMA

531

OLD_KEY_COLUMN_USAGE POSITION_IN_UNIQUE_CONSTRAINT

532

OLD_KEY_COLUMN_USAGE ORDINAL_POSITION

533

OLD_KEY_COLUMN_USAGE COLUMN_NAME

534

OLD_KEY_COLUMN_USAGE TABLE_NAME

535

OLD_KEY_COLUMN_USAGE CONSTRAINT_CATALOG

536

OLD_KEY_COLUMN_USAGE CONSTRAINT_SCHEMA

537

OLD_KEY_COLUMN_USAGE CONSTRAINT_NAME

538

OLD_KEY_COLUMN_USAGE TABLE_CATALOG

539

OLD_KEY_COLUMN_USAGE TABLE_SCHEMA

540

OLD_REFERENTIAL_CONSTRAINTS REFERENCED_TABLE_NAME

541

OLD_REFERENTIAL_CONSTRAINTS TABLE_NAME

542

OLD_REFERENTIAL_CONSTRAINTS DELETE_RULE

543

OLD_REFERENTIAL_CONSTRAINTS UPDATE_RULE

544

OLD_REFERENTIAL_CONSTRAINTS MATCH_OPTION

545

OLD_REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_NAME

546

OLD_REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_SCHEMA

547

OLD_REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_CATALOG

548

OLD_REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME

549

OLD_REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA

550

OLD_REFERENTIAL_CONSTRAINTS CONSTRAINT_CATALOG

551

OLD_SESSION_VARIABLES VARIABLE_VALUE

552

OLD_SESSION_VARIABLES VARIABLE_NAME

553

OLD_STATISTICS TABLE_CATALOG

554

OLD_STATISTICS TABLE_SCHEMA

555

OLD_STATISTICS TABLE_NAME

556

OLD_STATISTICS NON_UNIQUE

557

OLD_STATISTICS INDEX_SCHEMA

558

OLD_STATISTICS INDEX_NAME

559

OLD_STATISTICS SEQ_IN_INDEX

560

OLD_STATISTICS INDEX_COMMENT

561

OLD_STATISTICS COMMENT

562

OLD_STATISTICS INDEX_TYPE

563

OLD_STATISTICS NULLABLE

564

OLD_STATISTICS PACKED

565

OLD_STATISTICS SUB_PART

566

OLD_STATISTICS CARDINALITY

567

OLD_STATISTICS COLLATION

568

OLD_STATISTICS COLUMN_NAME

569

OLD_TABLE_CONSTRAINTS CONSTRAINT_TYPE

570

OLD_TABLE_CONSTRAINTS TABLE_NAME

571

OLD_TABLE_CONSTRAINTS TABLE_SCHEMA

572

OLD_TABLE_CONSTRAINTS CONSTRAINT_NAME

573

OLD_TABLE_CONSTRAINTS CONSTRAINT_SCHEMA

574

OLD_TABLE_CONSTRAINTS CONSTRAINT_CATALOG

575

OPEN_SESSION_STATUS VARIABLE_NAME

576

OPEN_SESSION_STATUS VARIABLE_VALUE

721

577

SELECT *

722

FROM information_schema.key_column_usage;

578

FROM information_schema.old_key_column_usage;

723

579

724

580

SELECT *

725

FROM information_schema.referential_constraints;

581

FROM information_schema.old_referential_constraints;

726

582

CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME UNIQUE_CONSTRAINT_CATALOG UNIQUE_CONSTRAINT_SCHEMA UNIQUE_CONSTRAINT_NAME MATCH_OPTION UPDATE_RULE DELETE_RULE TABLE_NAME REFERENCED_TABLE_NAME

727

SELECT catalog_name, schema_name

728

FROM information_schema.schemata

729

ORDER BY schema_name;

730

catalog_name schema_name

731

NULL information_schema

732

NULL mysql

733

NULL test

734

SELECT *

735

FROM information_schema.session_status

736

ORDER BY variable_name;

737

VARIABLE_NAME VARIABLE_VALUE

738

# #

739

# #

740

# #

741

# #

742

# #

743

# #

744

# #

745

# #

746

# #

747

# #

748

# #

749

# #

750

# #

751

# #

752

# #

753

# #

754

# #

755

# #

756

# #

757

# #

758

# #

759

# #

760

# #

761

# #

762

# #

763

# #

764

# #

765

# #

766

# #

767

# #

768

# #

769

# #

770

# #

771

# #

772

# #

773

# #

774

# #

775

# #

776

# #

777

# #

778

# #

779

# #

780

# #

781

# #

782

# #

783

# #

784

# #

785

# #

786

# #

787

# #

788

# #

789

# #

790

# #

791

# #

792

# #

793

# #

794

# #

795

# #

796

# #

797

# #

798

# #

799

# #

800

# #

801

# #

802

# #

803

# #

804

# #

805

# #

806

# #

807

# #

808

# #

809

# #

810

# #

811

# #

812

# #

813

# #

814

# #

815

# #

816

# #

817

# #

818

# #

819

# #

820

# #

821

# #

822

# #

823

# #

824

# #

825

# #

826

# #

827

# #

828

# #

829

# #

830

# #

831

# #

832

# #

833

# #

834

# #

835

# #

836

# #

837

# #

838

# #

583

SELECT count(schema_name) FROM data_dictionary.schemas ORDER BY schema_name;

584

count(schema_name)

585

839

586

SHOW STATUS;

840

587

Variable_name Value

841

588

# #

940

687

# #

941

688

# #

942

689

SELECT *

943

FROM information_schema.global_status

690

FROM information_schema.old_global_status

944

691

ORDER BY variable_name;

945

692

VARIABLE_NAME VARIABLE_VALUE

946

693

# #

1045

792

# #

1046

793

# #

1047

794

SELECT *

1048

FROM information_schema.table_constraints;

795

FROM information_schema.old_table_constraints;

1049

796

CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE

1050

797

SELECT table_schema, table_name

1051

FROM information_schema.tables

1052

WHERE plugin_name IS NULL

798

FROM data_dictionary.tables

799

WHERE table_schema="data_dictionary"

1053

800

ORDER BY table_name;

1054

801

table_schema table_name

1055

information_schema CHARACTER_SETS

1056

information_schema COLLATIONS

1057

information_schema COLLATION_CHARACTER_SET_APPLICABILITY

1058

information_schema COLUMNS

1059

information_schema GLOBAL_STATUS

1060

information_schema GLOBAL_VARIABLES

1061

information_schema INNODB_CMP

1062

information_schema INNODB_CMPMEM

1063

information_schema INNODB_CMPMEM_RESET

1064

information_schema INNODB_CMP_RESET

1065

information_schema INNODB_LOCKS

1066

information_schema INNODB_LOCK_WAITS

1067

information_schema INNODB_TRX

1068

information_schema KEY_COLUMN_USAGE

1069

information_schema MODULES

1070

information_schema PLUGINS

1071

information_schema PROCESSLIST

1072

information_schema REFERENTIAL_CONSTRAINTS

1073

information_schema SCHEMATA

1074

information_schema SESSION_STATUS

1075

information_schema SESSION_VARIABLES

1076

information_schema STATISTICS

1077

information_schema TABLES

1078

information_schema TABLE_CONSTRAINTS

802

SELECT count(*) FROM data_dictionary.plugins;

803

count(*)

804

Older »