Skript pro Telnet
I am browe
browe na volny.cz
Sobota Květen 26 00:06:45 CEST 2001
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.
------------- další část ---------------
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 Databases