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

Comments [hide]

ID	Author/Program	Comment	Date
1051	stefan	Mysteriously unsolved although VERY similar to #1000665...	2015-08-21 22:04:07

add comment

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:	1239 / 236
Referenced in:	#681 - All IOIOI examples (collection) #3000382 - Answer for ferdie (>> t = 1, f = 0) #3000383 - Answer for funkoverflow (>> t=1, f=0 okay) #3000384 - Answer for 6uru0fsh1va (>> t-sql?)