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

12
LINES

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

IOIOI

1  
In: [[CREATE TABLE `demotable` (

2  
  `dt_id` int(11) NOT NULL AUTO_INCREMENT,

3  
  `dt_hello` text NOT NULL,

4  
  PRIMARY KEY (`dt_id`)

5  
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;]]

6  
Out: "demotable"

7  
In: [[CREATE TABLE `demotable2` (

8  
  `dt2_a` int(11) NOT NULL,

9  
  `dt2_b` date NOT NULL,

10  
  `dt2_c` text NOT NULL

11  
) ENGINE=MyISAM DEFAULT CHARSET=latin1;]]

12  
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: 1241 / 237
Referenced in: [show references]