Latest Blog Post
javascript wrap selected text in textarea
the script:
function wrapText(elementID, openTag, closeTag) {
var textArea = $('#' + elementID);
var len = textArea.val().length;
var start = textArea[0].selectionStart;
var end = textArea[0].selectionEnd;
var selectedText = textArea.val().substring(start, end);
var replacement = openTag + selectedText + closeTag;
[...]
sql copy table data from different database connection
INSERT INTO `db1name`.`table1name`
SELECT * FROM `db2name`.`table2name`;
sql comparing data from two tables
Basically, I have two tables. 1 with a list of all identification number (idnum), and the other 1 have only processed idnum. So, I want to compare those two table and bring out the list of unprocessed idnum. The sql as follows:
SELECT * FROM all_idnum
WHERE NOT EXISTS (
SELECT idnum FROM processed_idnum
WHERE processed_idnum.icno = all_idnum.idnum
);
