View Single Post
  #16  
Old 02-22-2016, 11:04 PM
ionhsmith
Discordant
 
Join Date: Jun 2014
Posts: 284
Default

Code:
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='information_schema';
SHOW TABLE STATUS FROM `information_schema`;
SHOW FUNCTION STATUS WHERE `Db`='information_schema';
SHOW PROCEDURE STATUS WHERE `Db`='information_schema';
SHOW TRIGGERS FROM `information_schema`;
SHOW EVENTS FROM `information_schema`;
SELECT *, EVENT_SCHEMA AS `Db`, EVENT_NAME AS `Name` FROM information_schema.`EVENTS` WHERE `EVENT_SCHEMA`='peq';
SHOW KEYS FROM `guild_members` WHERE `Key_name` LIKE 'PRIMARY';
/* Affected rows: 0  Found rows: 0  Warnings: 0  Duration for 1 query: 0.000 sec. */
Code:
/* Delimiter changed to ; */
/* Connecting to 127.0.0.1 via MySQL (TCP/IP), username root, using password: Yes ... */
SELECT CONNECTION_ID();
/* Connected. Thread-ID: 979 */
/* Characterset: utf8mb4 */
SHOW STATUS;
SHOW VARIABLES;
SHOW DATABASES;
USE `peq`;
/* Entering session "EQ" */
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='peq';
SHOW TABLE STATUS FROM `peq`;
SHOW FUNCTION STATUS WHERE `Db`='peq';
SHOW PROCEDURE STATUS WHERE `Db`='peq';
SHOW TRIGGERS FROM `peq`;
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='information_schema';
SHOW TABLE STATUS FROM `information_schema`;
SHOW FUNCTION STATUS WHERE `Db`='information_schema';
SHOW PROCEDURE STATUS WHERE `Db`='information_schema';
SHOW TRIGGERS FROM `information_schema`;
SHOW EVENTS FROM `information_schema`;
SELECT *, EVENT_SCHEMA AS `Db`, EVENT_NAME AS `Name` FROM information_schema.`EVENTS` WHERE `EVENT_SCHEMA`='peq';
SHOW KEYS FROM `guild_members` WHERE `Key_name` LIKE 'PRIMARY';
/* Affected rows: 0  Found rows: 0  Warnings: 0  Duration for 1 query: 0.000 sec. */
SHOW KEYS FROM `group_id` WHERE `Key_name` LIKE 'PRIMARY';
/* Affected rows: 0  Found rows: 4  Warnings: 0  Duration for 1 query: 0.000 sec. */

This everything you needed?
Reply With Quote