MyTechForum
database
-
How do I find the slow queries in MySQL?
The easiest way to isolate the slowest queries in the slow queries log is to use mysqlsla. Run mysqlsla on your slow...
-
How do I display the top 10 query results in MySQL?
Use the limit operator to reduce the number of results returned to be 10. SELECT * FROM tbl LIMIT 10; For example,...
-
How do I change the MySQL client prompt?
How do I change the MySQL client prompt? (MySQL 4.0.2 and higher) (from http://dev.mysql.com/doc/mysql/en/mysql_Commands.html) e.g. “prompt \d\R\m>” will show the current database...
-
How do I export a MySQL table to a .csv file?
select * into outfile ‘/tmp/table.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’ from mytable;
-
How do I find duplicate records in a MySQL table?
To find duplicate records in a table, use a select statement like the one below: select name, count(address) as count from address_book...