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

1 vote193 views1 answer
Add many column to sap iq table
SQL
11 votes233 views2 answers
Sql rank
SQL
11 votes196 views1 answer
Creating tables in sql with python
SQL
0 vote181 views1 answer
How to Remove milliseconds from Date time
SQL
4 votes192 views1 answer
Oracle show error line number
SQL
0 vote189 views3 answers
Create and attach user to a postgresql database
SQL
8 votes180 views1 answer
How to remove tables from postgresql
SQL
0 vote177 views1 answer
Dump multiple tables mysql
SQL
0 vote198 views1 answer
Max mysql
SQL
0 vote242 views1 answer
How to pass list as parameter in SQL query
SQL