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 vote149 views1 answer
Psql generate id in existing database
SQL
3 votes183 views1 answer
Sql several or
SQL
0 vote153 views1 answer
Error code 1451 sql
SQL
1 vote129 views1 answer
Reutrn string after character sql
SQL
0 vote143 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
0 vote131 views1 answer
Kotlin sqlite delete row
SQL
1 vote151 views4 answers
Aggregate function in sql
SQL
0 vote161 views1 answer
Python sqlalchemy connection show server
SQL
0 vote132 views2 answers
Android sqlite tutorial for beginners
SQL
5 votes144 views1 answer
Commentaire table oracle
SQL