DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?

by

What @Matus and @CeesTimmerman said about MSSQL, works in MySQL 5.1.73 too:

delete <alias> from <table> <alias> where <alias>.<field>...

More Related Contents:

  1. Using an Alias in SQL Calculations
  2. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  3. SQL Query needed for fetch value from Two identical table but not fully identical table
  4. How to create a MySQL hierarchical recursive query?
  5. Error related to only_full_group_by when executing a query in MySql
  6. SQL split values to multiple rows
  7. How to reset AUTO_INCREMENT in MySQL
  8. How to declare a variable in MySQL?
  9. MySQL Query GROUP BY day / month / year
  10. MySQL Cannot Add Foreign Key Constraint
  11. Grouping into interval of 5 minutes within a time range
  12. SQL counting all rows instead of counting individual rows
  13. Convert timestamp to date in MySQL query
  14. Update a column value, replacing part of a string
  15. MySQL Like multiple values
  16. In MySQL, should I quote numbers or not?
  17. MySQL add days to a date
  18. mysql dynamic query in stored procedure
  19. Check for x consecutive days – given timestamps in database
  20. MySQL Insert Into from one Database in another
  21. How to alter a column and change the default value?
  22. How to select one row randomly taking into account a weight?
  23. Composite key as foreign key (sql)
  24. MySQL – Replace Character in Columns
  25. Sort the rows according to the order specified in WHERE IN clause
  26. update a column by subtracting a value
  27. How can I use SQL’s YEAR(), MONTH() and DAY() in Doctrine2?
  28. What does it mean by select 1 from table?
  29. Update multiple rows with multiple ‘where’ clauses for each individual row
  30. ORDER BY alphabet first then follow by number

Leave a Comment