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 vote274 views2 answers
Cascade syntax in sql
SQL
1 vote209 views1 answer
Display total number of tables in mysql
SQL
16 votes199 views3 answers
Delete row psql
SQL
0 vote232 views1 answer
Returning with sqlalchemy
SQL
1 vote390 views1 answer
Postgres upgrade to superuser
SQL
0 vote216 views1 answer
Horizontal join sqlite
SQL
1 vote209 views1 answer
How to subtract from the value of a table in sql
SQL
0 vote212 views1 answer
Find and replace query in wordpress\
SQL
0 vote224 views1 answer
How to see the query of a view in mysql
SQL
9 votes192 views2 answers
Mysql change value
SQL