3.1.1 Copying and Pasting Text

Notes on copy and paste:

3.1.1 Copying and pasting text

Often in a PuTTY session you will find text on your terminal screen which you want to type in again. Like most other terminal emulators, PuTTY allows you to copy and paste the text rather than having to type it again. Also, copy and paste uses the Windows clipboard, so that you can paste (for example) URLs into a web browser, or paste from a word processor or spreadsheet into your terminal session.

PuTTY's copy and paste works entirely with the mouse. In order to copy text to the clipboard, you just click the left mouse button in the terminal window, and drag to select text. When you let go of the button, the text is automatically copied to the clipboard. You do not need to press Ctrl-C or Ctrl-Ins; in fact, if you do press Ctrl-C, PuTTY will send a Ctrl-C character down your session to the server where it will probably cause a process to be interrupted.

Pasting is done using the right button (or the middle mouse button, if you have a three-button mouse and have set it up; see section 4.11.2). (Pressing Shift-Ins, or selecting ‘Paste’ from the Ctrl+right-click context menu, have the same effect.) When you click the right mouse button, PuTTY will read whatever is in the Windows clipboard and paste it into your session, exactly as if it had been typed at the keyboard. (Therefore, be careful of pasting formatted text into an editor that does automatic indenting; you may find that the spaces pasted from the clipboard plus the spaces added by the editor add up to too many spaces and ruin the formatting. There is nothing PuTTY can do about this.)

If you double-click the left mouse button, PuTTY will select a whole word. If you double-click, hold down the second click, and drag the mouse, PuTTY will select a sequence of whole words. (You can adjust precisely what PuTTY considers to be part of a word; see section 4.11.5.) If you triple-click, or triple-click and drag, then PuTTY will select a whole line or sequence of lines.

If you want to select a rectangular region instead of selecting to the end of each line, you can do this by holding down Alt when you make your selection. (You can also configure rectangular selection to be the default, and then holding down Alt gives the normal behaviour instead. See section 4.11.4 for details.)

If you have a middle mouse button, then you can use it to adjust an existing selection if you selected something slightly wrong. (If you have configured the middle mouse button to paste, then the right mouse button does this instead.) Click the button on the screen, and you can pick up the nearest end of the selection and drag it to somewhere else.

It's possible for the server to ask to handle mouse clicks in the PuTTY window itself. If this happens, the mouse pointer will turn into an arrow, and using the mouse to copy and paste will only work if you hold down Shift. See section 4.6.2 and section 4.11.3 for details of this feature and how to configure it.

*****WARNING*****

This is a private computer system. Only authorized users are allowed

access to this system. Use of this system is subject to the terms of the

Bristol Community College Policy for the Responsible Use of Information

Technology, available at:

http://www.bristolcc.edu/students/its/responsible_use.cfm

*****WARNING*****

*****IMPORTANT*****

The college is not responsible for any user data on this system including

but not limited to student work and assignments. Users of this system

are fully responsible for backing up their data.

*****IMPORTANT*****

's password:

Last login: Thu Feb 18 12:40:40 2010 from pool-71-184-217-222.bstnma.fios.verizon.net

[pgrocer@cisweb ~]$ mysql -u pgrocer -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 8603 to server version: 4.1.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database testS10;

Query OK, 1 row affected (0.05 sec)

NOTE: Your databases have been created so you do not do this creation.

mysql> use testS10;

Database changed

mysql> create table testfirst

-> (idno int(4), name varchar(20), major varchar(2), gpa float(3,2));

Query OK, 0 rows affected (0.00 sec)

mysql> insert into testfirst

-> values (1111,'John Doe','CI',3.2);

Query OK, 1 row affected (0.00 sec)

mysql> insert into testfirst

-> values(1234,'Mary Smith','CI',3.4);

Query OK, 1 row affected (0.00 sec)

mysql> insert into testfirst

-> values(2222,'Linda French','CI',3.6);

Query OK, 1 row affected (0.00 sec)

mysql> insert into testfirst

-> values (2345,'David Costa','CI',3.5);

Query OK, 1 row affected (0.00 sec)

mysql> insert into testfirst

-> values (33333,'Robert Brooks','BU',2.95);

Query OK, 1 row affected (0.00 sec)

mysql> insert into testfirst

-> values (3456,'Amy Richards','CI',2.8);

Query OK, 1 row affected (0.00 sec)

mysql> select * from testfirst;

+-------+---------------+-------+------+

+-------+---------------+-------+------+

| 1111 | John Doe | CI | 3.20 |

| 1234 | Mary Smith | CI | 3.40 |

| 2222 | Linda French | CI | 3.60 |

| 2345 | David Costa | CI | 3.50 |

| 33333 | Robert Brooks | BU | 2.95 |

| 3456 | Amy Richards | CI | 2.80 |

+-------+---------------+-------+------+

6 rows in set (0.00 sec)

mysql> update testfirst

-> set idno = 3333

-> where name = 'Robert Brooks';

Query OK, 1 row affected (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from testfirst;

+------+---------------+-------+------+

+------+---------------+-------+------+

| 1111 | John Doe | CI | 3.20 |

| 1234 | Mary Smith | CI | 3.40 |

| 2222 | Linda French | CI | 3.60 |

| 2345 | David Costa | CI | 3.50 |

| 3333 | Robert Brooks | BU | 2.95 |

| 3456 | Amy Richards | CI | 2.80 |

+------+---------------+-------+------+

6 rows in set (0.00 sec)

mysql> select idno, name, major, gpa

-> from testfirst

-> where major = 'CI' and gpa > 3.3;

+------+--------------+-------+------+

+------+--------------+-------+------+

| 1234 | Mary Smith | CI | 3.40 |

| 2222 | Linda French | CI | 3.60 |

| 2345 | David Costa | CI | 3.50 |

+------+--------------+-------+------+

3 rows in set (0.00 sec)

mysql> select idno, name, major, gpa

-> from testfirst

-> where major = 'CI' or gpa < 3;

+------+---------------+-------+------+

+------+---------------+-------+------+

| 1111 | John Doe | CI | 3.20 |

| 1234 | Mary Smith | CI | 3.40 |

| 2222 | Linda French | CI | 3.60 |

| 2345 | David Costa | CI | 3.50 |

| 3333 | Robert Brooks | BU | 2.95 |

| 3456 | Amy Richards | CI | 2.80 |

+------+---------------+-------+------+

6 rows in set (0.00 sec)

mysql> select idno, name, major, gpa

-> from testfirst

-> where major = 'CI' and (gpa > 3.5 or gpa < 3);

+------+--------------+-------+------+

+------+--------------+-------+------+

| 2222 | Linda French | CI | 3.60 |

| 3456 | Amy Richards | CI | 2.80 |

+------+--------------+-------+------+

2 rows in set (0.00 sec)

mysql> insert into testfirst

-> values (1999,'to delete','BU',2);

Query OK, 1 row affected (0.00 sec)

mysql> select * from testfirst;

+------+---------------+-------+------+

+------+---------------+-------+------+

| 1111 | John Doe | CI | 3.20 |

| 1234 | Mary Smith | CI | 3.40 |

| 2222 | Linda French | CI | 3.60 |

| 2345 | David Costa | CI | 3.50 |

| 3333 | Robert Brooks | BU | 2.95 |

| 3456 | Amy Richards | CI | 2.80 |

| 1999 | to delete | BU | 2.00 |

+------+---------------+-------+------+

7 rows in set (0.00 sec)

mysql> delete from testfirst

-> where idno = 1999;

Query OK, 1 row affected (0.00 sec)

mysql> select * from testfirst;

+------+---------------+-------+------+

+------+---------------+-------+------+

| 1111 | John Doe | CI | 3.20 |

| 1234 | Mary Smith | CI | 3.40 |

| 2222 | Linda French | CI | 3.60 |

| 2345 | David Costa | CI | 3.50 |

| 3333 | Robert Brooks | BU | 2.95 |

| 3456 | Amy Richards | CI | 2.80 |

+------+---------------+-------+------+

6 rows in set (0.00 sec)

mysql> select distinct major from testfirst;

+-------+

| major |

+-------+

| CI |

| BU |

+-------+

2 rows in set (0.00 sec)

mysql> select idno ID, name NAME, major MAJOR

-> from testfirst;

+------+---------------+-------+

| ID | NAME | MAJOR |

+------+---------------+-------+

| 1111 | John Doe | CI |

| 1234 | Mary Smith | CI |

| 2222 | Linda French | CI |

| 2345 | David Costa | CI |

| 3333 | Robert Brooks | BU |

| 3456 | Amy Richards | CI |

+------+---------------+-------+

6 rows in set (0.00 sec)

mysql> select idno, name

-> from testfirst

-> order by name;

+------+---------------+

| idno | name |

+------+---------------+

| 3456 | Amy Richards |

| 2345 | David Costa |

| 1111 | John Doe |

| 2222 | Linda French |

| 1234 | Mary Smith |

| 3333 | Robert Brooks |

+------+---------------+

6 rows in set (0.00 sec)

mysql> select * from testfirst

-> where major in ('CI','GS','EN');

+------+--------------+-------+------+

+------+--------------+-------+------+

| 1111 | John Doe | CI | 3.20 |

| 1234 | Mary Smith | CI | 3.40 |

| 2222 | Linda French | CI | 3.60 |

| 2345 | David Costa | CI | 3.50 |

| 3456 | Amy Richards | CI | 2.80 |

+------+--------------+-------+------+

5 rows in set (0.01 sec)

mysql> select * from testfirst

-> where gpa between 3.4 and 3.6;

+------+--------------+-------+------+

+------+--------------+-------+------+

| 1234 | Mary Smith | CI | 3.40 |

| 2222 | Linda French | CI | 3.60 |

| 2345 | David Costa | CI | 3.50 |

+------+--------------+-------+------+

3 rows in set (0.00 sec)

mysql> select * from testfirst

-> where name like '_a%';

+------+-------------+-------+------+

+------+-------------+-------+------+

| 1234 | Mary Smith | CI | 3.40 |

| 2345 | David Costa | CI | 3.50 |

+------+-------------+-------+------+

2 rows in set (0.00 sec)