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

0 vote232 views1 answer
Psql check if value in array
SQL
2 votes221 views1 answer
Mysql list users on ubuntu
SQL
0 vote287 views1 answer
Insert query return id mysql
SQL
10 votes236 views4 answers
Join with multiple conditions sql
SQL
0 vote234 views1 answer
Oracle step procedure
SQL
0 vote238 views1 answer
How to export only procedures mysql
SQL
1 vote264 views1 answer
Sql check roles
SQL
0 vote250 views1 answer
How to find columns with null values in sql
SQL
0 vote233 views1 answer
Pgadmin see indexes
SQL
7 votes221 views1 answer
Grant schema permissions postgres
SQL