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 vote212 views1 answer
Postgresql comandos basicos
SQL
0 vote202 views1 answer
Convert rows into columns in oracle
SQL
12 votes193 views1 answer
Env var for setting password for root user mysql docker hub
SQL
7 votes206 views1 answer
Minecraft forge server host
SQL
1 vote212 views1 answer
Sql avg group by
SQL
0 vote205 views1 answer
Select the date 30 days less that the todays date sql request
SQL
7 votes207 views3 answers
Foreign key oracle
SQL
8 votes208 views1 answer
Oracle create datafile
SQL
1 vote200 views1 answer
Show per page table in xampp
SQL
1 vote204 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL