Can we run a mysql query through command prompt in windows?

Can we run MySQL query from windows command prompt? If so, how can we do that and process the query result through command prompt?

Solution

Try to use mysql — the MySQL command-line tool with '--execute=statement' or '-e statement' option.

Mysql IF conditional Left Join same table twice
Oracle to PostgreSQL query converter Possible?
Mysql count instances of substring, then order by
SELECT rows where a JSON key is bigger/smaller than
django reconnect to DB when connection is lost (async code)
Error "Host x.x.x.x is not allowed to connect to this mariaDB server"
MySQL: What's the difference between float and double?
Why specify delimiter for stored procedure when there's BEGIN and END?
How to insert TIMESTAMP into my MySQL table?
Dynamically setting __tablename__ for sharding in SQLAlchemy?
Mysql ERROR at line 1153: Unknown command '\'
could not execute statement; SQL [n/a]; constraint [PRIMARY]; nested exception is org.hibernate.exception.ConstraintViolationException
PHP REST API POSTMAN Fatal error Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax
Compare data in array and count the number of instances it occurs in the database using codeigniter
Body not correct for MySQL INSERT for POST Method
When I am entering the IP address in my Postman I am getting data in the Postman from my API?
Symfony - Expected value of type '' got "string" instead
does extracting strings into another table and making the original column a foreign key save space?
Get counts while grouping by a column with Codeigniter's active record
select count(*) with group_by in Codeigniter
Error: token "@" is not valid in preprocessor expressions
TypeError: The "payload" argument must be of type object. Received null
Invalid schema detected - no type or db_type element Dreamfactory
Dynamic dialog radiolist from MySQL or MariaDB query?
Unknown/unsupported storage engine: InnoDB
get image dimension from blob column in MySQL database
Why mysql uses index with cardinality=1?
PDO Prepared Statements with % and concat
maxWait MySQL configuration taking no effect in Grails?
MySQL Event scheduler every day start at 12 AM and continue work EVERY 15 MINUTE till 5 AM