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 vote197 views1 answer
How to get nth number in sql
SQL
3 votes141 views1 answer
Ubuntu install postgresql 12
SQL
1 vote172 views1 answer
User privileges postgresql information_schema
SQL
0 vote173 views1 answer
Mysql add to value
SQL
12 votes187 views6 answers
Between in sql
SQL
4 votes238 views1 answer
Alter session set nls_date_format
SQL
0 vote159 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote276 views1 answer
Run mysql xampp shell
SQL
1 vote253 views2 answers
Sql server find all foreign keys that reference a column
SQL
3 votes272 views2 answers
Mysql user permission database
SQL