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

0 vote391 views1 answer
How to use sqlcommand
SQL
0 vote344 views1 answer
Start and stop mysql
SQL
0 vote333 views1 answer
Linked server delete openquery
SQL
7 votes393 views1 answer
Oracle pagination query rownum
SQL
1 vote351 views1 answer
Oracle duration between timestamps
SQL
2 votes351 views1 answer
How to show the whole table in sql
SQL
0 vote359 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
27 votes369 views5 answers
Mysql set password for user
SQL
2 votes337 views2 answers
Get all columns from table sql
SQL
3 votes370 views1 answer
Only join in sql
SQL