<!DOCTYPE html>
<html><head><meta charset="UTF-8">
<title>SQL Code Category Generator</title>
<style>
@import url('https://fonts.googleapis.com/css?family=Cuprum');
body {background: rgb(204,204,204);font-family: 'Cuprum', sans-serif;margin:0;padding:0;}
textarea {font-size: 100%;padding: 0;font-family: 'Cuprum', sans-serif;box-sizing: border-box;text-align: center;border: 0px;border-right: 1px solid #AAA;border-bottom: 1px solid #AAA;width: 50%;height: 90%;position: absolute;resize: none;transition: 0.5s;}
textarea:last-child {border-right: 0px;}
textarea:focus, button:focus {outline: none;}
textarea:hover {background: #EEE;}
button {width: 100%;height: 10%;position: absolute;font-family: 'Cuprum', sans-serif;border: 0px;font-size: 40px;bottom: 0;background: #EEE;}
.front {left:0;}
.result {right:0;}
</style></head><body>
<textarea class="front" placeholder="Одна категория на одну строку">1|2|QWE|qwe
1|2|ASD|asd
1|2|ZXC|zxc</textarea>
<textarea class="result" placeholder="Здесь будет результат"></textarea>
<button>GENRATE</button>
<script src="http://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
<script>
$('button').click(function(){
var list = $(".front").val().split("\n");
for (var i = 0, ln = list.length; i < ln; ++i)
var separ = list[i].split("|");
for (var i = 0, ln = separ.length; i < ln; ++i)
$(".result").append("INSERT INTO `dle_category` ( `parentid`, `posi`, `name`, `alt_name`) VALUES ('"+separ[0]+"', '"+separ[1]+"', '"+separ[2]+"', '"+separ[3]+"');\n");
});
</script></body></html>