Run sql command line

Run sql script from command line

mysql -u yourUserName -p yourDatabaseName < yourFileName.sql

Source: tutorialspoint.com

Run sql command line

sqlplus username/password@service	-- OR sqlplus / as sysdba

SQL> SELECT * FROM dual;

How to run sql query

/*in Sql Server (SSMS)*/
/*Hightlight the statements you would like to execute*/
/*Then click on the green play button (somtimes with the word execute) or press F5*/

Similar codes

1 vote316 views2 answers
Sql queries practice
SQL
0 vote306 views1 answer
How to drop a trigger in postgresql
SQL
0 vote290 views1 answer
Replace sqlalchemy
SQL
8 votes338 views4 answers
Postgresql server restart
SQL
0 vote326 views1 answer
Procedure excute monthly oracle
SQL
1 vote350 views1 answer
Postgresql float 2 decimal places
SQL
0 vote294 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
3 votes344 views2 answers
Savepoint in sql
SQL
11 votes293 views1 answer
How to get ddl for materialized view
SQL
0 vote285 views1 answer
Oracle list chain steps
SQL