Get field names from MYSQL create table (IOIOI) [1000649]

15
LINES

< > BotCompany Repo | #1000649 // Get field names from MYSQL create table (IOIOI)

IOIOI

--

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

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: "dt2_a, dt2_b, dt2_c"

download show line numbers

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

2 comment(s) hidden. show

Snippet ID:	#1000649
Snippet name:	Get field names from MYSQL create table (IOIOI)
Eternal ID of this version:	#1000649/1
Text MD5:	90bb509b840888efe111588f62591d85
Author:	stefan
Category:
Type:	IOIOI
Public (visible to everyone):	Yes
Archived (hidden from active list):	No
Created/modified:	2015-08-21 00:57:23
Source code size:	391 bytes / 15 lines
Pitched / IR pitched:	No / Yes
Views / Downloads:	770 / 167
Referenced in:	[show references]

1	--
2
3	In: [[CREATE TABLE `demotable` (
4	`dt_id` int(11) NOT NULL AUTO_INCREMENT,
5	`dt_hello` text NOT NULL,
6	PRIMARY KEY (`dt_id`)
7	) ENGINE=MyISAM DEFAULT CHARSET=latin1;]]
8	Out: "dt_id, dt_hello"
9
10	In: [[CREATE TABLE `demotable2` (
11	`dt2_a` int(11) NOT NULL,
12	`dt2_b` date NOT NULL,
13	`dt2_c` text NOT NULL
14	) ENGINE=MyISAM DEFAULT CHARSET=latin1;]]
15	Out: "dt2_a, dt2_b, dt2_c"