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

How to Get Table Sizes of a Database in Microsoft SQL Server

Obtain Table Sizes of One or Multiple Names -- Get sizes of multiple tables use…

PowerShell: Graceful Shutdown of MS SQL Server

import-module sqlps CD SQLSERVER:\SQL\$env:computername $sql = (get-item .).ManagedComputer # This command stops MSSQL$instanceName, SQLSERVERAGENT, SQLAGENT$instanceName,…

MS SQL: Admin_Report_Notification

/* Admin_Report_Notification */DECLARE @tab char(1) SET @tab = CHAR(9)EXEC msdb.dbo.sp_send_dbmail@profile_name = 'Report DBMail Profile',@recipients =…