- Instant help with your Sql coding problems

Delete records from MySQL table

by Mike
Question:
How to delete records from MySQL table?
Answer:
DELETE FROM mytable WHERE id=123;
Description:

DELETE is a DML statement that removes rows from a table. The DELETE statement deletes rows from tbl_name and returns the number of deleted rows. To check the number of deleted rows, call the ROW_COUNT() function.

The conditions in the optional WHERE clause identify which rows to delete. With no WHERE clause, all rows are deleted.

Reference:
The delete statement reference
Share "How to delete records from MySQL table?"
Related snippets:
Tags:
delete record from table, delete record mysql, delete all records
Technical term:
Delete records from MySQL table
Trending snippets
Create INSERT statement for each record with mysqldumpGet last 30 days records in MySQLBackup only certain rows from MySQL databaseBackup MySQL data onlyBackup MySQL database without locking tablesSkip tables in MySQL backupDelete all records from a table in MySQLCreate table in MySQLGet current year in MySQLBackup MySQL schema onlyDelete records from MySQL tableReturn 0 if field is NULL in MySQLConvert INT to DATETIME in MySQLBackup only selected tables in MySQLBackup MySQL databaseGroup by year of Unix timestamp in MySQLSort MySQL resultsSelect year from a Unix timestamp in MySQLImport an SQL file using the command line in MySQLGet current date in MySQL
Network articles
Create Web Worker in React TypescriptGet element by ID in ReactFix the 'React' must be in scope when using JSX errorWait until page is completely loaded in PuppeteerHow to use calc() in TailwindCSSDisable tooltip in VS CodeOpen VS Code with the current folder from terminalForce list bullets inside the containerCount the number of words in a string using JavaScriptGenerate random date with JavaScriptSolving the Uncaught SyntaxError: Cannot use import statement outside a modulePlay video in fullscreen with vanilla JavaScriptGo to line in VS CodeConvert date to timestamp in PHPGet yesterday's date in PHPPHP switch case statementAdd dots if text is too longGet the first Monday of a month in JavaSubmit HTML form to self pageGet yesterday's date in JavaScript