Quellcode |
|
1 2 3 |
$ ls -l total 4 -rw-r--r-- 1 dyle users 295 2009-03-03 10:05 test.sql |
Quellcode |
|
1 2 3 4 5 6 7 |
$ 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 |
|
1 2 |
$ mysql -u dyle -p -D test < test.sql &> test.out Enter password: |
Quellcode |
|
1 2 3 4 |
$ 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 |
|
1 2 3 4 5 6 |
$ cat test.out Name Value Test-1 Eins Test-2 Zwei Test-3 Drei Test-4 Vier |