How to run sql query

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

10 votes234 views2 answers
Mysql select timestamp group by day
SQL
0 vote207 views1 answer
Hangfire clean script
SQL
0 vote263 views1 answer
Count in sql and diff
SQL
0 vote257 views1 answer
Mysql foreach insert
SQL
2 votes264 views1 answer
Mariadb json select
SQL
0 vote250 views2 answers
Sql searching via key word
SQL
2 votes258 views2 answers
How to check data type in sql server
SQL
-1 vote224 views1 answer
Plsql while
SQL
0 vote292 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
4 votes259 views1 answer
Refresh postgres config
SQL