How to delete duplicate rows in SQL


To find and delete duplicate rows from a table, you can execute the query below. Note that this is for Oracle. You can use it for other databases but you need to change the ‘rowid’ then. delete from table_name A where a.rowid > any ( select B.rowid from table_name B where A.column_name = B.column_name ); You need to change the ‘table_name’ by your table name an the...

How to optimize MySQL


On , you find two interesting tools for MySQL. A configuration wizard that recommends a MySQL configuration based on your server settings. There is also a query analyzer tool that analyzes your SQL query and provides feedback. To use the tools, you need to log in, but they are free! MySQL settings optimizer The MySQL optimizer will ask you to fill in your server configuration and database...

Tag Cloud