0
votes
1answer
78 views

Lookup data while in mysql cli edit mode (external editor) (\e)

I'm using the mysql cli in edit mode (\e). > Select * from \e Goes to vim and I finish typing my command. Select * from test_table; Only to realize I've forgotten to use the database I need. ...
0
votes
1answer
6k views

What's a good (free) client for MySQL on Windows? [closed]

I am almost repeating a question done here by another user, but related to MySQL. What do you think is the best free (if any) MySQL client software? Thank you!
1
vote
1answer
491 views

can mysql cli exit with error if no records returned?

I would like to execute a sql command in bash, and do something based on whether or not there was a result. e.g. $ LOOKUP=123; mysql -e \ 'SELECT id FROM table WHERE id='$LOOKUP dbname \ ...
5
votes
3answers
809 views

MySQL client believes they're in a transaction, gets KILLed, wreaks havoc

Open up two mysql command-line clients and connect to your database. In client #1, enter START TRANSACTION; In client #2, use SHOW PROCESSLIST, then KILL [n]; where n is the id for client #1's ...