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

Web Server Files and mySQL backup and restore

Backup: mysqldump -u [username] -p [password] [databasename] > /home/shares/backup_db.sql   Restore: mysql -u root -p…

Microsoft SQL: Login failed for user ‘sa’. (.Net SqlClient Data Provider)

Error: ===================================Cannot connect to SQL-SERVER===================================Login failed for user 'sa'. (.Net SqlClient Data Provider) Resolution: 1.…

MySQL on Localhost

Modern versions of MySQL is memory intensive; thus, it is a pre-requisite that an adequate…
Other project: DragonCoin.com