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

4 votes242 views1 answer
Rename stored procedure in sql server
SQL
0 vote225 views1 answer
Sql count total by foreign key
SQL
11 votes210 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote261 views1 answer
Oracle swap partition
SQL
1 vote198 views1 answer
What is a Database?
SQL
2 votes206 views1 answer
Query any digits record
SQL
0 vote203 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote224 views1 answer
Incorrect string value: mysql
SQL
0 vote212 views1 answer
Mysql select smaller of two values
SQL
0 vote230 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL