delete duplicate rows from table. Not Working!

robertohuertasm / SQLite4Unity3d

SQLite made easy for Unity3d

MIT License

1.27k stars 265 forks source link

delete duplicate rows from table. Not Working! #88

Open mubeenfahmed opened 6 years ago

mubeenfahmed commented 6 years ago

I am trying to delete duplicate records from table, using following query, but its not working.

Delete FROM users GROUP BY name, email HAVING COUNT(*) > 1

It just throw following errors: SQLiteException: near "count": syntax error. SQLiteException: near "group": syntax error SQLiteException: near "having": syntax error

what should I do, Need Help!

Salbrox commented 6 years ago

You should be using % as wildcard not * if i'm not mistaken.