Node.js - Actualizare si Stergere date in tabel MySQL

Curs Javascript

- Delete cu Node.js in MySQL

Metoda query() a modulului "mysql" poate efectua interogari SQL care actualizeaza (Update) si sterg (Delete) inregistrari in tabelul mysql.

Update cu Node.js in MySQL

Puteti actualiza inregistrari existente intr-un tabel MySQL folosind instructiunea "UPDATE".
Pentru a obtine numarul de randuri afectate/actualizate, se foloseste proprietatea affectedRows a obiectului rezultat.

- In acest exemplu vom actualiza datele din coloana "address" din randul cu id-ul 5, folosind metoda mysql.escape() pentru a filtra datele in interogarea SQL:

const mysql = require('mysql');

const pool = mysql.createPool({
  host: '127.0.0.1',
  user: 'root',
  password: 'pass',
  database: 'nodedb',
  charset: 'utf8'
});

//update with escape()
var adr ='Happy 12';
var id =5;
let sql ='UPDATE friends SET address ='+ mysql.escape(adr) +' WHERE id ='+ mysql.escape(id);

pool.getConnection((err, con)=>{
  if(err) throw err;

  con.query(sql, (err, res)=>{
    if(err) throw err;
    con.release(); //release the connection
    console.log('Record(s) updated: '+ res.affectedRows);
  });
});

- In urmatorul cod se folosesc inlocuitori '?' in instructiunea Update:

const mysql = require('mysql');

const pool = mysql.createPool({
  host: '127.0.0.1',
  user: 'root',
  password: 'pass',
  database: 'nodedb',
  charset: 'utf8'
});

//update using placeholders
let sql ='UPDATE friends SET address =? WHERE id =?';
var placeh =['Happy 12', 5]; //values for placeholders

pool.getConnection((err, con)=>{
  if(err) throw err;

  con.query(sql, placeh, (err, res)=>{
    if(err) throw err;
    con.release(); //release the connection
    console.log('Record(s) updated: '+ res.affectedRows);
  });
});

- O alta metoda cu inlocuitori '?', adaugarea numelor coloanelor si a valorilor intr-un obiect:

const mysql = require('mysql');

const pool = mysql.createPool({
  host: '127.0.0.1',
  user: 'root',
  password: 'pass',
  database: 'nodedb',
  charset: 'utf8'
});

//update using placeholders
let sql ='UPDATE friends SET ? WHERE ?';
var adr ={address:'Happy 12'};
var id ={id:5};

pool.getConnection((err, con)=>{
  if(err) throw err;

  con.query(sql, [adr, id], (err, res)=>{
    if(err) throw err;
    con.release(); //release the connection
    console.log('Record(s) updated: '+ res.affectedRows);
  });
});

Resultat:

Delete cu Node.js in MySQL

Puteti sterge inregistrari dintr-un tabel MySQL folosind instructiunea "DELETE FROM".
Pentru a obtine numarul randurilor afectate/sterse, se foloseste proprietatea affectedRows a obiectului resultat.

const mysql = require('mysql');

const pool = mysql.createPool({
  host: '127.0.0.1',
  user: 'root',
  password: 'pass',
  database: 'nodedb',
  charset: 'utf8'
});

//deleted with placeholders
let sql ='DELETE FROM friends WHERE id =? OR name =?';
var id =2;
var name='Olpram';

pool.getConnection((err, con)=>{
  if(err) throw err;

  con.query(sql, [id, name], (err, res)=>{
    if(err) throw err;
    con.release(); //release the connection
    console.log('Rows deleted: '+ res.affectedRows);
  });
});

Resultat:

<table></tr>
  <td>Cell-1</td><td>Cell-2</td>
</tr></table>

h3 {
  background-image: url("image.jpg");
}

var arr = [1, "ab", "CoursesWeb.net"];
for(var i=0; i< arr.length; i++) { alert(arr[i]); };

$arr =["k1"=>"v1", "k2"=>"v2", "k3"=>"v3");
foreach($arr AS $k => $v) { echo "<br/>". $k ." - ". $v; }

He is so kind and meek.
- El este atat de amabil si bland.

Tu padre tiene un carácter muy manso.
- Tatal tau are un caracter foarte bland.