Not logged in.  Login/Logout/Register | List snippets | | Create snippet | Upload image | Upload data

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: 769 / 167
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?)