Just wondering what’s the delete button in sqlite shell? Tried the delete button on MAC but doesn’t work. Let’s say I have typos in some lines and I discover them before I execute the codes. How to edit those lines? I couldn’t even move the cursor to the place I want.
Bash’s command-line editor (and sqlite shell) doesn’t support editing of continuation prompt lines, so it’s best to keep everything in one line separated by semicolons.