Skript pro Telnet
Milan Roubal
roubm9am na barbora.ms.mff.cuni.cz
Sobota Květen 26 00:38:15 CEST 2001
sice jsem tu nenarazil na zadny dotaz, ale mam pocit ze se chcete zeptat na
to
proc se misto tabelatoru preda znak t - dela to shell, musite tam
dat znak \ dvakrat, tedy radek bude vypadat
output "LOAD DATA INFILE '/tmp/1.txt' INTO TABLE recept FIELDS TERMINATED BY
'\\t' ;^M"
Zdravi
Milan Roubal
roubm9am na barbora.ms.mff.cuni.cz
----- Original Message -----
From: "I am browe" <browe na volny.cz>
To: <databases na linux.cz>
Sent: Saturday, May 26, 2001 12:06 AM
Subject: Skript pro Telnet
expect 60 "login:"
output "seno^M"
expect 60 "Password:"
output "notone^M"
# Pripojeni k Mysql
output "mysql -h www.server.cz -u seno -p seno^M"
expect 60 "Password:"
output "chacha^M"
expect 60 "mysql>"
output "LOAD DATA INFILE '/tmp/1.txt' INTO TABLE recept FIELDS TERMINATED BY
'\t' ;^M"
output "LOAD DATA INFILE '/tmp/2.txt' INTO TABLE recept FIELDS TERMINATED BY
'\t' ;^M"
output "LOAD DATA INFILE '/tmp/3.txt' INTO TABLE recept FIELDS TERMINATED BY
'\t' ;^M"
output "LOAD DATA INFILE '/tmp/4.txt' INTO TABLE recept FIELDS TERMINATED BY
'\t' ;^M"
atd
Souboru je asi 80.
----------------------------------------------------------------------------
----
Vitejte na serveru xxx
login: seno
Password:
Last login: Thu May 24 20:58:30 from xxx
mysql -h www.server.cz -u seno -p slama
www:~$ mysql -h www.server.cz -u seno -p slama
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is --- to server version: 3.22.27
Type 'help' for help.
;ysql> LOAD DATA INFILE '/tmp/1.txt' INTO TABLE recept FIELDS TERMINATED BY
't'
Query OK, 1 row affected (0.00 sec)
Records: 1 Deleted: 0 Skipped: 0 Warnings: 3
mysql> select * from recept;
+----+-------------------------------------------+-------------------+------
---+
| id | nazev_koreni | text_up |
nazev_po|
+----+-------------------------------------------+-------------------+------
---+
| 1 | erá dává pokrmům říz i vůni po mexickém s | ylu. Obsahuje mle | ou
sladk|
+----+-------------------------------------------+-------------------+------
---+
1 row in set (0.00 sec)
mysql> delete from recept;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
www:~$ exit
logout
Další informace o konferenci Test