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

21 votes197 views1 answer
SQL cheat sheet pdf
SQL
5 votes224 views1 answer
Mysql count newlines in field
SQL
10 votes210 views1 answer
How to import database in mysql by cmd
SQL
0 vote297 views1 answer
Delet all record statment sql
SQL
0 vote214 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote206 views1 answer
Copy data from one postgres container to another
SQL
2 votes239 views1 answer
Sql string starts with
SQL
1 vote161 views1 answer
Unique vs distinct sql
SQL
3 votes204 views3 answers
Raw select laravel
SQL
0 vote182 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL