Posts Tagged ‘script’

How to execute script file in Postgresql

In this article we are going to learn about executing the script file in PostgreSQL database. Step1: Create file script file using cat command. cat > loginlist.dat and enter the following

How to execute script file in MySQL

script file contains list of commands saved in with .sql/.txt or other extension. To import or export file in MySQL, use must be granted FILE permission. Steps to execute script file in MySQL: 1. Create a file(.sql extension): We are going to get list of users in MySQL using the file prvr@ubuntu:~$ cat > getlistofusers.sql […]

emp table script SQL Server

Standard emp table script for SQL Server 1) Create table structure 2) Insert data into emp table

How to run script in Sybase

We can create scripts and execute using isql. This is useful when you need to execute the same set of commands. Script execution Syntax: isql -Uuser_name -Ppassword -Sserver_name -iscript_name -oscript_output How to create scripts: Create text file and paste the commands to be executed on SYBASE ASE. root$vi databaseslist.txt select name from sysdatabase go :wq!

ddlgen tool in Sybase

Sybase ddlgen tool used to extract the creation script for any server-level or database level object. This is OS level command. Syntax: ddlgen -Ulogin -Ppassword -S[[ssl:]server | host_name : port_number] [-I interfaces_file] [-Tobject_type] [-Nobject_name] [-Ddbname] [-Xextended_object_type] [-Ooutput_file] [-Eerror_file] [-Lprogress_log_file] [-Jclient_charset] [-LC -N logical_cluster_name -F[ % | SGM | GRP | USR | R | D […]

Powered by k2schools