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 vote205 views1 answer
Connect postgresql using a connection string
SQL
1 vote217 views1 answer
Epoch time converter in snowflake
SQL
0 vote185 views1 answer
Mysql_error replacement
SQL
5 votes254 views1 answer
Migrate sql table another database
SQL
5 votes195 views2 answers
Ranking functions in sql
SQL
1 vote227 views1 answer
Ora-01109 database not open in oracle 19c
SQL
41 votes275 views6 answers
Alter table add column in SQL Server
SQL
0 vote178 views1 answer
Suse start MySQL
SQL
6 votes227 views1 answer
How to get the size of the database in postgresql
SQL
0 vote203 views1 answer
Update top 100 order by sql server
SQL