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

MS SQL Maintenance

Below is a list of practical SQL snippets to administer Microsoft databases: -- Shrink Database:…

PowerShell: Get SQL Server Performance Counters

Version 2 # getSqlPerformanceCounter.ps1 # version 0.02 $computername='sql0003.kimconnect.com' function getSqlPerformanceCounter($server=$env:computername,$sampleInterval=10,$maxSamples=1){ $PerformanceCounterSampleSet=$result=@() $counters=@( '\Memory\Available MBytes', '\Memory\Pages/sec',…

MongoDB: Backup and Restore

Manual Methods:Using mongodump and mongorestoreMaking a backup using mongodump- Permissions required: grant find action, backup…