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

T-SQL: How To Rename Database in Microsoft SQL Server

The T-SQL USE master; GO ALTER DATABASE TEST_MSCRM SET SINGLE_USER WITH ROLLBACK IMMEDIATE; GO ALTER…

iSeries Access ODBC Setup

Run ODBC Data Source Administrator > click on System DSN

DB2 AS400 to Microsoft SQL Conversion

SQL Ways Wizard: Enter ODBC data source, username, and password >> press Next Set Target…