Know any tricks for navigating the MySQL CLI?

Question

For example, ^e jumps to the beginning, ^e jumps to the end, and ^w deletes the next word. ^l is clear, ^k deletes, ^j enters, ^b goes backwards...

It seems similar to bash shortcuts but still somewhat different.

Answer 1

Ending a query in \e takes you into your editor, which is handy for modifying long, convoluted queries

SELECT foo FROM bar\e