Run sql command line

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 vote119 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
0 vote161 views1 answer
MySQL update with subquery
SQL
6 votes116 views2 answers
Oracle trigger
SQL
0 vote97 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote112 views1 answer
Odd record sql query
SQL
11 votes114 views2 answers
Having clause in sql
SQL
0 vote108 views1 answer
Mysql docker image for macbook m1
SQL
0 vote104 views1 answer
Restart sql server command line linux
SQL
2 votes117 views1 answer
Q operator in sql
SQL
0 vote121 views1 answer
Sql remove first character from string
SQL