jazz7381

ps -ef | grep 'proccess name' | awk '{print $2}' | xargs -r kill

jazz7381

SELECT * FROM tablename
WHERE id IN (SELECT id
  FROM (SELECT id,
           ROW_NUMBER() OVER (partition BY column1, column2 ORDER BY id) AS rnum
   FROM tablename) t
WHERE t.rnum > 1);

jazz7381

DELETE FROM tablename
WHERE id IN (SELECT id
  FROM (SELECT id,
           ROW_NUMBER() OVER (partition BY column1, column2 ORDER BY id) AS rnum
   FROM tablename) t
WHERE t.rnum > 1);

jazz7381

	function tattoo_submit() {

	  if (isset($_POST["addtattoo"])) {

	    $title = "Tattoo : ". $_POST["tatooInput"];

	    $my_post = array(
	      'post_title'    => $title,
	      'post_status'   => 'publish',
	      'post_author'   => 1,