Find From Table in SQL
by LeeMellinger
HTML
<div id="console-log"><h3>Output:</h3></div>
CSS
.console-line
{
font-family: monospace;
margin: 2px;
}
TypeScript
let consoleLine = "<p class=\"console-line\"></p>";
namespace console {
export function log (text) {
$("#console-log").append($(consoleLine).html(text));
}
}
let sql = 'select * from account';
let a: any[] = sql.split(' ');
let found: boolean = false;
console.log('len: ' + a.length);
for (let i=0; i < a.length; i++) {
// console.log(a[i]);
if (found && a[i]) {
console.log(a[i]);
} else if (a[i] == 'from') {
found = true;
// console.log(a[i+1]);
}
}