Posts Tagged ‘pager’

Removing all databases from a MySQL instance

Posted: 3rd March 2011 by Darren Cassar in Beginner, MySQL
Tags: , , , ,
2

Many out there will have different ideas about this, some using procs, some using a function, others using a shell script. Well I didn’t want to spend much time on it so decided a group_concat(concat would be enough. There is no genius, rather laziness :) but what if you have a hundred databases and you [...]

Show warnings with MANY MANY warnings

Posted: 14th June 2010 by Darren Cassar in MySQL
Tags: , , , ,
0

What to do when you have too many warnings and would like to check them out. Say you were trying to run a query which returned a heap of warnings and you want to go through the list …. mysql> load data infile ‘/aaa/bbb/ccc’ into table xyz LINES TERMINATED BY ‘\r\n’; Query OK, 0 rows [...]