answersLogoWhite

Top Answer
User Avatar
Wiki User
Answered 2007-02-03 03:53:47

The basic format is mysql (any mysql options) < sql_script_you_want_to_run.sql for mysql, and psql (any psql options) < sql_script_you_want_to_run.sql for postgresql.

001
๐Ÿ™
0
๐Ÿคจ
0
๐Ÿ˜ฎ
0
๐Ÿ˜‚
0
User Avatar

Your Answer

Loading...

Still Have Questions?

Related Questions

What is shell programming in unix?

A shell script is a file containing a set of commands to be executed (run) by the shell in sequence as it reads the file.


Which command in unix is used to run the script immediately?

As long as the script file is readable and executable, just type the name of the script and it will execute immediately. Otherwise, you can call the shell interpreter and have it run it immediately such as: bash ./thefile where ./thefile is the script you want to run. Or, substitute the shell interpreter you wish to use instead of bash, such as sh, ksh, tcsh, csh, etc.


What is the difference between SQL and SQLPlus?

SQL is the language itself where as SQL*Plus is a program distributed by Oracle used to run SQL Script on databases.


How do you run a Unix program?

By typing its name into the shell


What is the command to execute a shell script?

If the shell script is readable and executable then to execute it just type the name of the shell script file. Otherwise, you can explicity call a shell interpreter to run the file as a shell script, i.e., ksh myfile


Where can you get a Unix shell for Windows?

A Unix shell can be obtained in Cygwin, a Unix compatibility layer used to compile Unix programs and run them on Windows. Microsoft also makes a shell known as "Windows PowerShell" which incorporates more Unix-like features than the standard command prompt.


Can you execute a shell script if you do not have read permission for the file containing the script?

No, the shell needs both execute and read permissions to run the script.


How do you compile and run shell script of factorial?

Shell scripts are not compiled; they are interpreted (and therefore do not need to be compiled). Just type in the name of the shell script and any parameters it needs to execute.


How do you write a shell script to enlist the processes being run?

#!/bin/sh PS -a


What line is necessary at the beginning of a script to tell the OS what to use to run the script?

The special line at the beginning of the script is only necessary if you want the script to be run by a certain command interpreter that is different from your logon shell or because you don't know what environment the user of the shell might be running in. It is a special comment line that looks like: #!/command-name such as: #!/usr/bin/ksh which causes the ksh interpreter to be used for the rest of the shell script.


What are the difference between su and su-aloke in UNIX OS?

su substitute user.. and su is a unix command used to run the shell of another user without logging off..


What are shell scripts in unix?

Shell scripts are interpreted files that contain commands and logic sequences to do things. They are similar to programs in that they contain logic and sequencing, and call other programs to accomplish tasks. You use shell scripts to automate tasks in Unix, run tasks periodically, create repeatable tasks, etc.


What is the three categories of users in a Unix environment?

Unix has the following categories of users: Superuser - root account, can do anything on the system ordinary user - has no special privileges restricted user - is restricted in what they can do in the shell and programs they can run.


What type of hardware does Unix run on?

Unix can be run on a variety of server, mainframe, and workstation devices.


Can you run Unix commands in uppercase?

On the off chance that the name of the binary / script is in uppercase, yes. But "ifconfig", "Ifconfig", and "IFCONFIG" are treated as three separate programs.


On which OS platform c pgm run in unix?

unix.


How do you enter SQL query in Access?

First of all you need to know some SQL and how to write SQL statements. If you create a simple query in the Design View of Access, you can then change the view to SQL View. Once you do that, you can then continue to type the SQL and run the query.First of all you need to know some SQL and how to write SQL statements. If you create a simple query in the Design View of Access, you can then change the view to SQL View. Once you do that, you can then continue to type the SQL and run the query.First of all you need to know some SQL and how to write SQL statements. If you create a simple query in the Design View of Access, you can then change the view to SQL View. Once you do that, you can then continue to type the SQL and run the query.First of all you need to know some SQL and how to write SQL statements. If you create a simple query in the Design View of Access, you can then change the view to SQL View. Once you do that, you can then continue to type the SQL and run the query.First of all you need to know some SQL and how to write SQL statements. If you create a simple query in the Design View of Access, you can then change the view to SQL View. Once you do that, you can then continue to type the SQL and run the query.First of all you need to know some SQL and how to write SQL statements. If you create a simple query in the Design View of Access, you can then change the view to SQL View. Once you do that, you can then continue to type the SQL and run the query.First of all you need to know some SQL and how to write SQL statements. If you create a simple query in the Design View of Access, you can then change the view to SQL View. Once you do that, you can then continue to type the SQL and run the query.First of all you need to know some SQL and how to write SQL statements. If you create a simple query in the Design View of Access, you can then change the view to SQL View. Once you do that, you can then continue to type the SQL and run the query.First of all you need to know some SQL and how to write SQL statements. If you create a simple query in the Design View of Access, you can then change the view to SQL View. Once you do that, you can then continue to type the SQL and run the query.First of all you need to know some SQL and how to write SQL statements. If you create a simple query in the Design View of Access, you can then change the view to SQL View. Once you do that, you can then continue to type the SQL and run the query.First of all you need to know some SQL and how to write SQL statements. If you create a simple query in the Design View of Access, you can then change the view to SQL View. Once you do that, you can then continue to type the SQL and run the query.


What is a shell in Unix?

Unix has two main sets internal implementation and the interface that is seen and used by users. i.e. Kernal and Shell. Kernal takes care of hardware interface and shell communicates with Kernal. Shell works as interpreter of user commands and translates them into action. The shell forms the outer part of the operating system and forms the interface between the user and the kernel. For each user logged in, there is shell in action. When a command is given by the user, it is examined by the shell and communicated to the kernel for execution. The functions used to communicate with the kernel are called system calls and are built into the kernel. The system calls are in all the flavors of UNIX are the same. Hence, software developed on one UNIX system can be easily run on another UNIX system. shell also has some internal commands, e.g. CD. External commands are saved in file system, when you enter such commands shell searches for them and runs them in new sub-process. application developed on unix communicates with shell and not kernal, this engables single application to be executed on various types of computer hardware without being modified


How is a job run periodically in Unix system Explain with an example?

The cron facility of Unix allows periodic tasks to be started. You need to add a scheduler entry to cron (via crontab) in the form: minute hour dom month day-of-week So the entry: 0,15 3-5 * 12 0 /run/some/script would run the file /run/som/script on the hour and 15 minutes past the hour, from 3 - 5 a.m. every day of the month for December if the day is a Sunday.


The script was run or the script was ran which is correct?

In the world of technology, where a script is a snippet or more of computer code, the proper grammar is: The script was run, or the script ran.


Is Unix better than MS-DOS?

Yes and no. If you have the hardware resources to run UNIX/Linux then you should. DOSBox can run any DOS program in UNIX, so there is no need for DOS if you can run UNIX. However, if you have an older computer or an embedded system where UNIX or Linux would have too much overhead, DOS is a better choice.


Why can't Unix be run on microcomputers?

Many versions of Unix can be run on microcomputers. Xenix, Solaris, Mac OS X, and IRIX all run on microcomputers.


What percentage of computers run on Unix?

Unix is not very popular with the general public. A more popular version is Linux. Around twenty percent tend to run on this system. Unix has competition also.


How do you run sql on terminal in linux os?

mysql -u user -p -e 'SQL Query' database


What command should be given to compile a C program from the command prompt?

You need a compiler. Gcc or g++ can be run from a unix shell, or a windows implementation of one like cygwin.