Posted On March 31, 2019

SQL: DELETE FROM Statement

kimconnect 0 comments
blog.KimConnect.com >> Database >> SQL: DELETE FROM Statement
DELETE FROM `Profiles` WHERE Picture = '0'
--------------------------------------------------
Change password to "sexcenter"
UPDATE `Profiles`
SET Password = '5863294bde549649adab89940c3e09ea'
WHERE Password = 'pass123word'
-------------------------------

DELETE FROM `Profiles` WHERE Email = ''

-----------------------------

DELETE * FROM `Profiles`
WHERE Email != '%@%'

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post

Some MySQL Admin Stuff

make sure it's running ps -ef | grep mysql Creating MySQL DB HOWTO on creating…

Loading the SQL Server Management Objects (SMO)

function loadSMO{ $ErrorActionPreference = "Stop" $sqlpsRegistry="HKLM:\SOFTWARE\Microsoft\PowerShell\1\ShellIds\Microsoft.SqlServer.Management.PowerShell.sqlps" try{ if (Get-ChildItem $sqlpsRegistry -ErrorAction "SilentlyContinue") { throw "SQL…

Microsoft Dynamics Email Router Failed to Start

Symptoms Event Log: Item 1: highest correlating event ID 26234 #26234 - The Email Router…