Either:
SELECT * FROM table \g filename
to just output to the file 'filename', or:
select * from lineshoot \g |cat >> /solsolute/path/filename
to append to the file. Both in psql, or:
echo 'SELECT * FROM table' | psql database >> test.out
from your terminal
Example 10-18 Loading LOB DATA with One LOB per LOBFILE
Control File Contents
LOAD DATA
INFILE 'sample.dat'
INTO TABLE person_table
FIELDS TERMINATED BY ','
(name CHAR(20),
1 ext_fname FILLER CHAR(40),
2 "RESUME" LOBFILE(ext_fname) TERMINATED BY EOF)
Datafile (sample.dat)
Johny Quest,jqresume.txt,
Speed Racer,'/private/sracer/srresume.txt',
Secondary Datafile (jqresume.txt)
Johny Quest
500 Oracle Parkway
...
Secondary Datafile (srresume.txt)
Speed Racer
400 Oracle Parkway
...
http://students.kiv.zcu.cz/doc/oracle/appdev.102/b14259/xdb25loa.htm
Burada da XML yukleme ile ilgili ornek var.
Mevcut Mac de mysql /var/mysql e kurulmus. Ama onemi yok! Yeni kuracagim su sekilde olacak ve kaldirmak gerekirse aklimda bulunsun.
To use SET PASSWORD on Unix, do this:
anonymous account passwd or removalhttp://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html
shell>mysql -u root
mysql>SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd');
mysql>SET PASSWORD FOR ''@'host_name' = PASSWORD('newpwd');
shell>mysql -u root
mysql>DROP USER ''@'localhost';
shell>mysql -u root
mysql>SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql>SET PASSWORD FOR 'root'@'host_name' = PASSWORD('newpwd');
Resetting permission
#Table class: path as primary key
class Filesystem(Base):
__tablename__ = 'filesystem'
path = Column(String, primary_key=True)
name = Column(String)
def __init__(self, path,name):
self.path = path
self.name = name
def __repr__(self):
return "
#psycopg2 is needed for postgres connection, use synaptic pakage manager
#The actual table will not be created until you run code to create a table,
#and you also need to define what database engine SQLAlchemy will use
#
engine = create_engine('postgres://tulay:tulay@localhost:5432/testdb',echo=True)
Base.metadata.create_all(engine)
#Base.metadata.drop_all(engine)
#At this point, we know enough to create a SQLAlchemy project and control the database from the SQLAlchemy API.
#The only other major item to tackle before getting into a real-life example is the concept of a session.
#The SQLAlchemy "official" documentation describes the session as the handle to the database.
#In practical use, it allows for distinct, transaction-based, connections to occur from a pool of connections
#that SQLAlchemy has waiting. Inside of a session it is typical to add data to the database, perform queries, or delete data.
#
#In order to create a session, perform these sequential steps:
#establish Session type, only need to be done once for all sessions
Session = sessionmaker(bind=engine)
#create record object
create_record = Filesystem("/tmp/foo.txt", "foo.txt")
#make a unique session
session = Session()
#do atomic in session. We are inserting a record here
session.add(create_record)
#commit the transaction
session.commit()
#$pysql testdb
#select * from filesystem;
# path | name
psql: FATAL: IDENT authentication failed for user "gateadmin"
Su dosyayi degistir:local all trust
host all 127.0.0.1 255.255.255.255 trust
db2stop: Stop database
db2start: Start database
db2text: start text services
db2jstrt: start java listener
db2level: Komut satirindan DB2 surumunu ogrenmek icin
DB2 Log Files
db2 force application all : disconnect all users from database
db2 list applications for db dbname: Information for each application that is connected to the specified database is to be displayed.
The following example shows how to describe a table:
db2 describe table user1.department To reset a registry variable for an instance back to the default found in the Global Profile Registry, use:
db2set -r registry_variable_name
To delete a variable's value at a specified level, you can use the same command syntax to set the variable but specify nothing for the variable value. For example, to delete the variable's setting at the node level, enter:
db2set registry_variable_name= -i instance_name node_number