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