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 vote200 views1 answer
See the structure of a table mysql
SQL
11 votes188 views2 answers
Having in sql
SQL
2 votes168 views2 answers
Function in sql
SQL
2 votes142 views1 answer
Oracle sql drop column if exists
SQL
0 vote207 views1 answer
Sparql if bound query
SQL
0 vote185 views1 answer
Select a row include list of array with join table SQL
SQL
1 vote180 views1 answer
OstgreSQL version
SQL
1 vote199 views2 answers
Oracle leftmost characters
SQL
0 vote161 views1 answer
Lister les index d'une table oracle
SQL
0 vote176 views1 answer
Mysql backup certain tables workbench
SQL