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 vote128 views1 answer
Check if string is a number sql
SQL
0 vote127 views1 answer
Sql select sum group by id laravel join
SQL
2 votes129 views1 answer
Show max_allowed_packet mysql
SQL
0 vote120 views1 answer
Test the postgresql db connection
SQL
2 votes120 views1 answer
Sql create database
SQL
3 votes122 views2 answers
Mysql config user password
SQL
0 vote112 views1 answer
Dasebase_url-postgres for windows
SQL
5 votes118 views2 answers
Oracle tables with column name
SQL
10 votes87 views2 answers
Sql where clause multiple values
SQL
0 vote299 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL