Home » Open Source » MySQL » what's 'KEY' in 'SHOW CREATE TABLE'? (MySQL 5.1.66)
what's 'KEY' in 'SHOW CREATE TABLE'? [message #605863] Wed, 15 January 2014 07:14 Go to next message
rc3d
Messages: 213
Registered: September 2013
Location: Baden-Württemberg
Senior Member
Hi

here SHOW CREATE TABLE output:

   CREATE TABLE `QRTZ_TRIGGERS` (
  `TRIGGER_NAME` varchar(255) NOT NULL,
  `TRIGGER_GROUP` varchar(20) NOT NULL,
  `JOB_NAME` varchar(255) NOT NULL,
  `JOB_GROUP` varchar(20) NOT NULL,
  `IS_VOLATILE` varchar(1) NOT NULL,
  `DESCRIPTION` varchar(120) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(80) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` longblob,
  PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `JOB_NAME` (`JOB_NAME`,`JOB_GROUP`),
  KEY `idx_qrtz_t_next_fire_time` (`NEXT_FIRE_TIME`),
  KEY `idx_qrtz_t_state` (`TRIGGER_STATE`),
  KEY `idx_qrtz_t_nft_st` (`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
  KEY `idx_qrtz_t_volatile` (`IS_VOLATILE`),
  CONSTRAINT `QRTZ_TRIGGERS_ibfk_1` FOREIGN KEY (`JOB_NAME`, `JOB_GROUP`) REFERENCES `QRTZ_JOB_DETAILS` (`JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8


I don't understand what's KEY:

  KEY `JOB_NAME` (`JOB_NAME`,`JOB_GROUP`),
  KEY `idx_qrtz_t_next_fire_time` (`NEXT_FIRE_TIME`),
  KEY `idx_qrtz_t_state` (`TRIGGER_STATE`),
  KEY `idx_qrtz_t_nft_st` (`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
  KEY `idx_qrtz_t_volatile` (`IS_VOLATILE`),


from naming convention it looks like idx = Index?
This output seems not to be full CREATE TABLE statement? Can you explain?
Re: what's 'KEY' in 'SHOW CREATE TABLE'? [message #605869 is a reply to message #605863] Wed, 15 January 2014 08:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
what's 'KEY' in 'SHOW CREATE TABLE'?

I bet this is explained in the documentation and on the web.

[Updated on: Wed, 15 January 2014 08:02]

Report message to a moderator

Re: what's 'KEY' in 'SHOW CREATE TABLE'? [message #605871 is a reply to message #605869] Wed, 15 January 2014 08:52 Go to previous messageGo to next message
rc3d
Messages: 213
Registered: September 2013
Location: Baden-Württemberg
Senior Member
Michel Cadot wrote on Wed, 15 January 2014 08:02

Quote:
what's 'KEY' in 'SHOW CREATE TABLE'?

I bet this is explained in the documentation and on the web.



link?
Re: what's 'KEY' in 'SHOW CREATE TABLE'? [message #605872 is a reply to message #605871] Wed, 15 January 2014 08:58 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

http://www.google.com

Previous Topic: untill condition is true do (merged)
Next Topic: Ndbcluster engine
Goto Forum:
  


Current Time: Thu Mar 28 09:34:01 CDT 2024