Questions tagged as 'delete'

How can I delete a record being inserted into a specific condition in a trigger? example: USE 'scompraslenovo'; DELIMITER $$ CREATE TRIGGER 'precad_fornecedor_BUPD' BEFORE UPDATE ON 'precad_fornecedor' FOR EACH ROW BEGIN IF (new.f1 IS N...

I want to delete the rows that I select with my checkbox and also delete the database so that pq is given in this part of the code: <?php include "conexao.php"; if (isset($_POST['sel'])) { foreach ($_POST['sel'] as $id) { $sql...

I am failing mysql by recognizing the delete function $code = '1234'; $conn = new PDO('mysql:host=localhost;dbname=data', 'root'); $stmt = $conn->prepare('SELECT * FROM codes WHERE code='.$code.''); $stmt->execute(); $result = $st...