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
download show line numbers
Travelled to 12 computer(s): aoiabmzegqzx, bhatertpkbcr, cbybwowwnfue, gwrvuhgaqvyk, ishqpsrjomds, lpdgvwnxivlt, mqqgnosmbjvj, pyentgdyhuwx, pzhvpgtvlbxg, tslmcundralx, tvejysmllsmz, vouqrxazstgt
| 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: |
902 / 174 |
| Referenced in: |
[show references] |