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 vote236 views1 answer
Postgresql remove new line from string
SQL
0 vote206 views1 answer
PSQL qith variables
SQL
0 vote189 views1 answer
Sql find gaps in date ranges
SQL
0 vote231 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote207 views1 answer
Sql query interview questions githu
SQL
0 vote207 views1 answer
Minus equivalent in my sql
SQL
0 vote202 views1 answer
How to find lowest in sql
SQL
0 vote255 views2 answers
How to take recent row without limit in mysql
SQL
28 votes182 views4 answers
Show tables mysql
SQL
1 vote172 views1 answer
Login to database mysql terminal
SQL