MYSQL codes not being read

Question

When I input a code or anything into MySQL and hit "enter" it moves down and "->" appears. It is as if the code is not going through or the code is not being read.

I have attempted to download "add-ons" but I am really not sure what I am doing. This is for school and I am having trouble getting in touch with the professor.

I am new to this and can't figure out what I am doing wrong. Please help!

Please see image of what it looks like to me.

What do you want to do? Just try help on the client prompt? type help; without quotes. Type quit to quit . Ignore the single quotes in the "welcome message" — Vladislav Vaintroub, Jul 17 '20 at 07:32

score 1 · Accepted Answer · answered Jul 16 '20 at 02:42

1

Please add semicolon ; after the mysql code.

answered Jul 16 '20 at 02:42

joy

164
1
7

Did this really help? – Rick James Jul 16 '20 at 05:41
I doubt that :) – Vladislav Vaintroub Jul 17 '20 at 07:31

score 0 · Answer 2 · answered Jul 16 '20 at 05:52

Problem 1: Be aware of the prompt. Either of these

MariaDB >
mysql >

means that you are inside the MySQL commandline tool. You can enter only SQL statements. Most SQL queries need to be terminated by a ; or \G (but not both). To exit that tool:

exit

Or, if you get stuck in certain ways

CTRL-C
exit

Each of these implies a shell script:

$
#
mymachine$
/usr/home/rj $
C:\Users\rj:

and many others

Problem 2: mysqldump is a command, not SQL. So it needs to be executed in a shell script.

Problem 3: There is yet another problem. When it suggested typing 'help;', it did not mean for you to include the quotes. Instead, type just help;.

MYSQL codes not being read

2 Answers2