Find table name in MySQL create statement [1000666]

12
LINES

< > BotCompany Repo | #1000666 // Find table name in MySQL create statement

IOIOI

In: [[CREATE TABLE `demotable` (
  `dt_id` int(11) NOT NULL AUTO_INCREMENT,
  `dt_hello` text NOT NULL,
  PRIMARY KEY (`dt_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;]]
Out: "demotable"
In: [[CREATE TABLE `demotable2` (
  `dt2_a` int(11) NOT NULL,
  `dt2_b` date NOT NULL,
  `dt2_c` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;]]
Out: "demotable2"

Author comment

Began life as a copy of #1000665

download show line numbers

Travelled to 12 computer(s): aoiabmzegqzx, bhatertpkbcr, cbybwowwnfue, gwrvuhgaqvyk, ishqpsrjomds, lpdgvwnxivlt, mqqgnosmbjvj, pyentgdyhuwx, pzhvpgtvlbxg, tslmcundralx, tvejysmllsmz, vouqrxazstgt

1 comment(s) hidden. show

Snippet ID:	#1000666
Snippet name:	Find table name in MySQL create statement
Eternal ID of this version:	#1000666/1
Text MD5:	514ebad9b83774a7d1aa020a7156bb05
Author:	stefan
Category:	mysql
Type:	IOIOI
Public (visible to everyone):	Yes
Archived (hidden from active list):	No
Created/modified:	2015-08-21 22:03:10
Source code size:	385 bytes / 12 lines
Pitched / IR pitched:	No / Yes
Views / Downloads:	904 / 175
Referenced in:	[show references]