What is P in MySQL command?

What is P in MySQL?

It's an alias for the table. It's pointless in the example you gave. In a more complex query, it would let you refer to the table as p instead of by its name. See the table reference syntax in the docs.

What is P in MySQL u root p?

mysql -u root -p means, that you trying to connect to MySQL shell with parameters - -u parameter specified MySQL user name. -u, --user=name User for login if not current user. In your case it's root user. -p, --password[=name] Password to use when connecting to server. If password is not given it's asked from the tty.

What is MySQL command line?

mysql is a simple SQL shell with input line editing capabilities. It supports interactive and noninteractive use. When used interactively, query results are presented in an ASCII-table format. When used noninteractively (for example, as a filter), the result is presented in tab-separated format.

What does '> mean in MySQL?

It means that it is treating any input which follows as part of a string literal, until it encounters a(n unescaped) string termination quote ' character. This will have happened because you previously began the string literal with such a string termination quote character.