[Vultra]

Hello all,

While I was doing my SQL work for uni, I've got a couple of questions.
1. Can I <TAB> a variable to complete the word? So, If it's been stated somewhere in the terminal or, in the MySQL editor, I can auto complete the word. (Currently in terminal) - UPDATE: Tested in terminal and doesn't work & Seems to work in the editor since, I'm using atom to copy my code across.
2. How come SQL terminal registers arrows keys as symbols? When I'm typing, I like to do double brackets () then go back so, I know then i'm in the brackets.

thanks,

- mimi

[mothered]

Are you working from the MySQL Command Line Client?

If so, once you submit a query and then hold the right arrow key, It will complete all or part (whatever you prefer) of the query you've just submitted.

Please elaborate on the first part of your second point, preferably with a screenshot. I've never experienced an arrow key to register a symbol. It does what I've stated above. To navigate back to the parenthesis (double brackets), the left arrow key does just that. Whether you need to go back to an array of subqueries or on It's own, there's no difference.

The up arrow key will take you to all prior queries submitted In the same SQL session.

[Vultra]

Are you working from the MySQL Command Line Client?

If so, once you submit a query and then hold the right arrow key, It will complete all or part (whatever you prefer) of the query you've just submitted.

Please elaborate on the first part of your second point, preferably with a screenshot. I've never experienced an arrow key to register a symbol. It does what I've stated above. To navigate back to the parenthesis (double brackets), the left arrow key does just that. Whether you need to go back to an array of subqueries or on It's own, there's no difference.

The up arrow key will take you to all prior queries submitted In the same SQL session.

I'm working from the terminal as of right now.
To the second question: When I hit right arrow on my keyboard, this shows "^[[C". So, this limits me going back to my previous comment or, scrolling through my code to do any fixes.

[mothered]

The terminal Is (as mentioned) the MySQL Command Line Client.

So you're working off the CLI as per below, correct?

Spoiler:

[Vultra]

The terminal Is (as mentioned) the MySQL Command Line Client.

So you're working off the CLI as per below, correct?

Spoiler:

Oh, I've been using PuTTy as suggested in the task.

[mothered]

The terminal Is (as mentioned) the MySQL Command Line Client.

So you're working off the CLI as per below, correct?

Spoiler:

Oh, I've been using PuTTy as suggested in the task.

Why not Install MySQL as a Localhost, and use the CLI to create the databases and then go ahead and create your tables & columns?

You can Insert, query, modify, select, delete/truncate, drop, join, change, rename, update, concat (better stop here) table names & values, datatypes, column names and so on without any Issues whatsoever.