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

4 votes123 views1 answer
Wilayah indonesia sql
SQL
1 vote145 views1 answer
Ora-01109 database not open in oracle 19c
SQL
1 vote129 views2 answers
Restart identity cascade
SQL
11 votes119 views2 answers
Having in sql
SQL
2 votes113 views1 answer
How to add where command in update comand with joins
SQL
1 vote131 views1 answer
Psql connect to another database
SQL
3 votes119 views2 answers
Update Query in SQL Server
SQL
3 votes116 views2 answers
Truncate table
SQL
4 votes113 views1 answer
What are the data types in sql
SQL
4 votes115 views2 answers
How to delete row in sql
SQL