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

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"



      
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
 	

    
1329 #738 Solved!

Details:
LHotwire(prog=class("main"), programID="#1000648")		 2017-09-17 17:19:00  delete  


1039 stefan hotwire #1000648 2015-08-21 00:58:12 

 
 
add comment
      
      
  

  

    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:
    883 / 188
  

      

    Referenced in:
[show references]