Masinasse sisenemine [jaagup@minitorn jaagup]$ telnet greeny.cs.tpu.ee Trying 193.40.238.41... Connected to greeny.cs.tpu.ee. Escape character is '^]'. Red Hat Linux release 9 (Shrike) Kernel 2.4.20-20.9custom on an i586 login: pyrak Password: Last login: Thu Nov 13 19:02:03 from minitorn.tpu.ee [pyrak@greeny pyrak]$ MySQL-i sisenemine [pyrak@greeny pyrak]$ mysql -upyrak -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1115 to server version: 3.23.58 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> Baasi valik mysql> use pyrak Database changed mysql> Tabeli loomine mysql> CREATE TABLE jaagup_inimesed(id INT NOT NULL auto_increment PRIMARY KEY, eesnimi varchar(30), perenimi varchar(30)); Query OK, 0 rows affected (0.01 sec) Tabelisse lisamine mysql> INSERT INTO jaagup_inimesed (eesnimi, perenimi) VALUES ('Juku', 'Juurikas'); Query OK, 1 row affected (0.01 sec) mysql> INSERT INTO jaagup_inimesed (eesnimi, perenimi) VALUES ('Siim', 'Eilane'); Query OK, 1 row affected (0.00 sec) Tabelist pärimine mysql> select * from jaagup_inimesed; +----+---------+----------+ | id | eesnimi | perenimi | +----+---------+----------+ | 1 | Juku | Juurikas | | 2 | Siim | Eilane | +----+---------+----------+ 2 rows in set (0.00 sec) mysql> select * from jaagup_inimesed order by perenimi; +----+---------+----------+ | id | eesnimi | perenimi | +----+---------+----------+ | 2 | Siim | Eilane | | 1 | Juku | Juurikas | +----+---------+----------+ 2 rows in set (0.00 sec) mysql> select * from jaagup_inimesed order by perenimi desc; +----+---------+----------+ | id | eesnimi | perenimi | +----+---------+----------+ | 1 | Juku | Juurikas | | 2 | Siim | Eilane | +----+---------+----------+ 2 rows in set (0.01 sec) _____________ Teine sisenemine veebilehe loomise tarbeks. [jaagup@minitorn jaagup]$ telnet greeny.cs.tpu.ee Trying 193.40.238.41... Connected to greeny.cs.tpu.ee. Escape character is '^]'. Red Hat Linux release 9 (Shrike) Kernel 2.4.20-20.9custom on an i586 login: pyrak Password: Last login: Thu Nov 13 19:16:27 from minitorn.tpu.ee [pyrak@greeny pyrak]$ Kataloogides liikumine [pyrak@greeny pyrak]$ cd public_html [pyrak@greeny public_html]$ mkdir jaagup [pyrak@greeny public_html]$ cd jaagup [pyrak@greeny jaagup]$ pwd /home/pyrak/public_html/jaagup [pyrak@greeny jaagup]$ [pyrak@greeny jaagup]$ pico tervitus.html
Tere tulemast! (Salvestus CTRL+O, väljumine CTRL+X) vaatamine http://greeny.cs.tpu.ee/~pyrak/jaagup/tervitus.html Pealkirjaga veebilehtEesnimi | Perekonnanimi |
---|---|
Juku | Juurikas |
Siim | Eilane |