MyTechForum
Posts By johngiggs
-
database
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...
-
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;
-
database
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...