Delete query not working in mysql

by

You don’t need to use the asterisk in a delete. Just do DELETE FROM user_enrole to delete all records.

If you want to delete specific records filtered by one or more conditions, you will specify those conditions in the WHERE clause, like so:

DELETE FROM user_enrole
WHERE somecolumn > 1
AND anothercolumn = 'Username'

More Related Contents:

  1. get first occurrence of last changed value of a column [closed]
  2. SQL Print the name of all Employees together with the name of their supervisor
  3. MySQL – Rows to Columns
  4. ROW_NUMBER() in MySQL
  5. multiple query same table but in different columns mysql
  6. How can I make SQL case sensitive string comparison on MySQL?
  7. How can I temporarily disable a foreign key constraint in MySQL?
  8. How to do a batch insert in MySQL
  9. MySQL offset infinite rows
  10. Ordering by the order of values in a SQL IN() clause
  11. Creating a “Numbers Table” in MySQL
  12. SQL Selecting from two Tables with inner join and limit [duplicate]
  13. MySQL Group by SUM
  14. Get the latest date from grouped MySQL data
  15. In SQL, how to select the top 2 rows for each group
  16. Mysql query to dynamically convert rows to columns on the basis of two columns
  17. MySQL Error 1264: out of range value for column
  18. mysql trigger stored trigger is already used by statement which invoked stored trigger
  19. MySQL error 1241: Operand should contain 1 column(s)
  20. How to set a MySQL row to READ-ONLY?
  21. Split a string and loop through values in MySQL stored procedure
  22. How to create dummy variable columns for thousands of categories in Google BigQuery?
  23. Mysql: Order by like?
  24. MySQL Select Query – Get only first 10 characters of a value
  25. Most efficient way to store IP Address in MySQL [duplicate]
  26. Getting first day of the week in MySql using Week No
  27. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  28. mysql select id and name from other table and join query
  29. How do you force mysql LIKE to be case sensitive? [duplicate]
  30. In what order are MySQL JOINs evaluated?

Leave a Comment