- 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
Backup only certain rows from MySQL databaseGet last 30 days records in MySQLCreate INSERT statement for each record with mysqldumpBackup MySQL data onlyBackup MySQL database without locking tablesSkip tables in MySQL backupDelete all records from a table in MySQLCreate table in MySQLBackup MySQL schema onlyDelete records from MySQL tableBackup only selected tables in MySQLGet current year in MySQLBackup MySQL databaseSort MySQL resultsConvert INT to DATETIME in MySQLGroup by year of Unix timestamp in MySQLReturn 0 if field is NULL in MySQLImport an SQL file using the command line in MySQLList all tables in a MySQL databaseFind MySQL data directory location
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