If you are working on a big mysql query and want to get the mysql query as email when it finishes use the below trick. Go to mysql command:Set pager directive: mysql> pager mail -s “subject” emailme@domain.comPAGER set to ‘mail’ -s “subject” emailme@domain.com The trick uses pager directive to redirect the query output result to […]
MySQL provides a LIMIT clause that is used to specify the number of records to return. The LIMIT clause makes it easy to code multi page results or pagination with SQL, and is very useful on large tables. Assume we wish to select all records from 1 – 30 (inclusive) from a table called “Orders”. […]
You can find duplicate rows in the mysql table, just use below select query, to find duplicate rows in Oracle, Sql, Mysql, DB2. SELECT columnName, COUNT(*) as countFROM selectedTableGROUP BY columnNameHAVING COUNT(*) > 1; You came from below query:how to find duplicate rows in sql server 2008how to find duplicate rows in sql and deletehow […]
