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

1 vote287 views1 answer
Postgres reset auto increment
SQL
0 vote356 views2 answers
Add new column after in sql
SQL
2 votes344 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote333 views1 answer
How to check xampp mysql password
SQL
0 vote321 views1 answer
On update current_timestamp jpa
SQL
1 vote361 views1 answer
Update from table tsql
SQL
0 vote333 views1 answer
Oracle create package specification
SQL
0 vote339 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
1 vote332 views1 answer
Get rows affected mysql python
SQL
0 vote348 views1 answer
Alter rename command in mysql
SQL