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 vote176 views1 answer
Postgres statistics
SQL
0 vote136 views1 answer
Mysql sleep connections
SQL
0 vote164 views1 answer
Mysql remove tabs from string
SQL
0 vote177 views1 answer
Groupby error in mysql
SQL
0 vote175 views1 answer
Intellij idea add mysql connector
SQL
0 vote178 views1 answer
Mysql join only one column
SQL
7 votes184 views3 answers
How ot change name of column mysql
SQL
0 vote169 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
24 votes166 views4 answers
Mssql get all table names
SQL
0 vote173 views1 answer
Linked server delete openquery
SQL