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

2 votes358 views1 answer
Sql percentage with % rounded down
SQL
0 vote386 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote332 views1 answer
In mysql workbench contnent not feching
SQL
4 votes329 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
4 votes312 views1 answer
To date oracle with time
SQL
2 votes304 views3 answers
Mysql cheat sheet
SQL
0 vote331 views2 answers
Sql query for getting details by id
SQL
1 vote338 views1 answer
Ora-01950 no privileges on tablespace
SQL
12 votes326 views5 answers
Sql merge
SQL
1 vote347 views1 answer
How to delay stored procedure execution in sql server
SQL