35 lines
1.3 KiB
Plaintext
35 lines
1.3 KiB
Plaintext
--disable_warnings
|
|
DROP DATABASE IF EXISTS d12;
|
|
--enable_warnings
|
|
CREATE DATABASE d12 CHARACTER SET ascii;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
DROP DATABASE d12;
|
|
CREATE DATABASE d12 CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
DROP DATABASE d12;
|
|
CREATE DATABASE d12 CHARACTER SET binary;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
DROP DATABASE d12;
|
|
CREATE DATABASE d12 CHARACTER SET swe7;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
DROP DATABASE d12;
|
|
CREATE DATABASE d12 CHARACTER SET cp1251;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
DROP DATABASE d12;
|
|
CREATE SCHEMA d12 CHARACTER SET ascii;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
DROP SCHEMA d12;
|
|
CREATE SCHEMA d12 CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
DROP SCHEMA d12;
|
|
CREATE SCHEMA d12 CHARACTER SET binary;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
DROP SCHEMA d12;
|
|
CREATE SCHEMA d12 CHARACTER SET swe7;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
DROP SCHEMA d12;
|
|
CREATE SCHEMA d12 CHARACTER SET cp1251;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
DROP SCHEMA d12;
|
|
|