Here is the syntax to execute sql statement from terminal

I'm assuming that you are using MySQL.

Syntax:

mysql -u user_name -p password -e 'SQL Query' database

Clearificance:

-u : Specify mysql database user name
-p : Prompt for password
-e : Execute sql query
database : Specify database name

Example:

• If you want to create a table person then:

  mysql -u root -p -e 'Create table person(PersonID int, LastName varchar(255), FirstName varchar(255))' mydb
  

  where root is the username, mydb is the name of the database. Similary you can execute any query you want.

• If you want to insert values in person:

  mysql -u root -p -e 'Insert into person(PersonID,LastName,FirstName) Values(100,"Kumar","Saurav")' mydb
  

• If you want to select all the information from person and want to save in a file:

  mysql -u root -p -e 'Select * from person' mydb > personinfo
  

And of-course you can create a database using terminal itself

• To create database mydb execute following command in terminal:

  mysql -u root -p -e 'create database mydb'
  

  it will silently create a database mydb without giving any message/output.

• To list all the databases execute this command in terminal:

  mysql -u root -p -e 'show databases'
  

Hope it helps you.. Reply if you need further assistance..