Database Queries

SHOW FULL COLUMNS FROM `exam`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'exam' AND `kcu`.`TABLE_NAME` = 'exam'

SELECT * FROM `exam` WHERE `id`=0

SELECT * FROM `paper` ORDER BY `updated_at` DESC

SHOW FULL COLUMNS FROM `paper`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'paper' AND `kcu`.`TABLE_NAME` = 'paper'

SELECT * FROM `classify`

SHOW FULL COLUMNS FROM `classify`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'classify' AND `kcu`.`TABLE_NAME` = 'classify'

SELECT * FROM `paper_question` WHERE `paper_id`='31' ORDER BY `sort`

SHOW FULL COLUMNS FROM `paper_question`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'paper_question' AND `kcu`.`TABLE_NAME` = 'paper_question'

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='31'

SELECT * FROM `paper_question` WHERE `paper_id`='30' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='30'

SELECT * FROM `paper_question` WHERE `paper_id`='29' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='29'

SELECT * FROM `paper_question` WHERE `paper_id`='28' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='28'

SELECT * FROM `paper_question` WHERE `paper_id`='27' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='27'

SELECT * FROM `paper_question` WHERE `paper_id`='26' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='26'

SELECT * FROM `paper_question` WHERE `paper_id`='25' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='25'

SELECT * FROM `paper_question` WHERE `paper_id`='24' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='24'

SELECT * FROM `paper_question` WHERE `paper_id`='23' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='23'

SELECT * FROM `paper_question` WHERE `paper_id`='22' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='22'

SELECT * FROM `paper_question` WHERE `paper_id`='19' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='19'

SELECT * FROM `paper_question` WHERE `paper_id`='21' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='21'

SELECT * FROM `paper_question` WHERE `paper_id`='20' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='20'

SELECT * FROM `paper_question` WHERE `paper_id`='18' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='18'

SELECT * FROM `paper_question` WHERE `paper_id`='16' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='16'

SELECT * FROM `paper_question` WHERE `paper_id`='17' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='17'

SELECT * FROM `paper_question` WHERE `paper_id`='15' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='15'

SELECT * FROM `paper_question` WHERE `paper_id`='14' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='14'

SELECT * FROM `paper_question` WHERE `paper_id`='13' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='13'

SELECT * FROM `paper_question` WHERE `paper_id`='12' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='12'

SELECT * FROM `paper_question` WHERE `paper_id`='11' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='11'

SELECT * FROM `paper_question` WHERE `paper_id`='10' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='10'

SELECT * FROM `paper_question` WHERE `paper_id`='9' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='9'

SELECT * FROM `paper_question` WHERE `paper_id`='8' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='8'

SELECT * FROM `paper_question` WHERE `paper_id`='7' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='7'

SELECT * FROM `paper_question` WHERE `paper_id`='6' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='6'

SELECT * FROM `paper_question` WHERE `paper_id`='5' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='5'

SELECT * FROM `paper_question` WHERE `paper_id`='4' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='4'

SELECT * FROM `paper_question` WHERE `paper_id`='3' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='3'

SELECT * FROM `paper_question` WHERE `paper_id`='2' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='2'

SELECT * FROM `paper_question` WHERE `paper_id`='1' ORDER BY `sort`

SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='1'

SELECT * FROM `classify`

SELECT * FROM `classify` WHERE `user_id`='78'