Skip to content

ruchanb/Json2SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Json2SQL

Convert Json List to SQL Select statement.

Json String

[    
    {"name":"Ram", "email":"[email protected]", "age":23},    
    {"name":"Shyam", "email":"[email protected]", "age":28},  
    {"name":"John", "email":"[email protected]", "age":33},    
    {"name":"Bob", "email":"[email protected]", "age":41}   
]

Converted SQL statement

Select 'Ram' as A, '[email protected]' as B, 23 as C
Union All
Select 'Shyam', '[email protected]', 28
Union All
Select 'John', '[email protected]', 33
Union All
Select 'Bob', '[email protected]', 41

About

Convert Json List to SQL Select

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published