How to Send Sql Queries to Mysql from the Command Line

Method 1 of 1:

Running without the console.

  1. How to Send Sql Queries to Mysql from the Command Line Picture 1
    Find the mysql program (Should be in a subdirectory called bin under the directory where MySQL was installed)
    1. E.g. Windows users: C:mysqlbinmysql.exe
    2. E.g. Linux/Unix users: /usr/local/mysql/bin/mysql
  2. How to Send Sql Queries to Mysql from the Command Line Picture 2
    Start mysql - At the command prompt, type: mysql -h hostname -u username -p db_name -e "query"
    1. where
      1. host is the machine where the MySQL server is running
      2. username is the MySQL account you want to use
      3. -p will make mysql prompt you for the MySQL account password.
      4. db_name is the name of the database to run the query in, and,
      5. query is the query that you want to run.
  3. How to Send Sql Queries to Mysql from the Command Line Picture 3
    Enter your password when prompted.
  4. How to Send Sql Queries to Mysql from the Command Line Picture 4
    MySQL should return the result of your query.
4 ★ | 1 Vote

May be interested

  • 5 best SQL query optimization software to speed up MySQLPhoto of 5 best SQL query optimization software to speed up MySQL
    the sql query optimizer analyzes many options for a given query, estimates the cost of each of these options, and finally, selects the lowest cost option.
  • TRUNCATE TABLE statement in SQLPhoto of TRUNCATE TABLE statement in SQL
    the truncate table statement is used to completely delete records from an existing table in sql.
  • HAVING clause in SQLPhoto of HAVING clause in SQL
    the having clause in sql is used to filter records and retrieve only those records that match the requirements or are actually needed.
  • The clause combines UNION data in SQLPhoto of The clause combines UNION data in SQL
    in sql, you can combine the same structured data from multiple tables into one query using the union and union all operators.
  • Frame view VIEW in SQLPhoto of Frame view VIEW in SQL
    in sql, a view view is a virtual table in a database whose content is defined through a certain sql statement.
  • TRANSACTION in SQLPhoto of TRANSACTION in SQL
    a transaction is successfully performed when all commands are successful, then all data changes made in the transaction are saved to the database.