GentooForum.de

Quellcode

$ ls -l
total 4
-rw-r--r-- 1 dyle users 295 2009-03-03 10:05 test.sql

Quellcode

$ cat test.sql 
DELETE FROM  Property;
INSERT INTO Property (Name, Value) VALUES ('Test-1', 'Eins');
INSERT INTO Property (Name, Value) VALUES ('Test-2', 'Zwei');
INSERT INTO Property (Name, Value) VALUES ('Test-3', 'Drei');
INSERT INTO Property (Name, Value) VALUES ('Test-4', 'Vier');
SELECT * FROM Property;

Quellcode

$ mysql -u dyle -p -D test < test.sql &> test.out
Enter password: 

Quellcode

$ ls -l    
total 8
-rw-r--r-- 1 dyle users  59 2009-03-03 10:05 test.out
-rw-r--r-- 1 dyle users 295 2009-03-03 10:05 test.sql

Quellcode

$ cat test.out 
Name	Value
Test-1	Eins
Test-2	Zwei
Test-3	Drei
Test-4	Vier