How to copy an statement in Mysql console

--00151750e5fe80eb050469e7dfaf
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hello,

I'm pretty new in MySql. I would like to know how you can copy a statement
like
mysql> INSERT INTO customers ( firstname, surname, title, phone) values (
'Jhon', 'Campbell', 'Mr', 345 987 5500)
in the MySql console in order to avoid typing it each time you want to fill
a new record.
I tried to right click my mouse,it doesn't select what I need to highlight.

Please,any advice is welcome.

JC

--00151750e5fe80eb050469e7dfaf--

Re: How to copy an statement in Mysql console

On Thu, May 14, 2009 at 7:41 PM, jean claude babin wrote:
> Hello,
>
> I'm pretty new in MySql. I would like to know how you can copy a statement
> like
> mysql> INSERT INTO customers ( firstname, surname, title, phone) values (
> 'Jhon', 'Campbell', 'Mr', 345 987 5500)
> in the MySql console in order to avoid typing it each time you want to fill
> a new record.
> I tried to right click my mouse,it doesn't select what I need to highlight.
>
> Please,any advice is welcome.

What you have at the console is history. Use your up and down arrows..

- michael dykman
- mdykman@gmail.com

- All models are wrong. Some models are useful.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: How to copy an statement in Mysql console

Blatantly assuming you are using PuTTy because of your question:

click-and-drag the mouse to select text. Then, press Shift+Ctrl+C to
copy to the clipboard. Press Shift+Ins to insert text back into the
console at the current carot-position.

Hope that helps..

Walter Heck




On Thu, May 14, 2009 at 5:41 PM, jean claude babin wrot=
e:
> Hello,
>
> I'm pretty new in MySql. I would like to know how you can copy a statemen=
t
> like
> mysql> INSERT INTO customers  ( firstname, surname, title, phone) va=
lues  (
> 'Jhon', 'Campbell', 'Mr', 345 987 5500)
> in the MySql console in order to avoid typing it each time you want to fi=
ll
> a new record.
> I tried to right click my mouse,it doesn't select what I need to highligh=
t.
>
> Please,any advice is welcome.
>
> JC
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: How to copy an statement in Mysql console

--000e0cd2457a450fed0469eec870
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

History (Arrow Up/Down)
COPY: Select (click + drag) PASTE: right click (or middle click)

2009/5/15 jean claude babin

> Hello,
>
> I'm pretty new in MySql. I would like to know how you can copy a statement
> like
> mysql> INSERT INTO customers ( firstname, surname, title, phone) values (
> 'Jhon', 'Campbell', 'Mr', 345 987 5500)
> in the MySql console in order to avoid typing it each time you want to fill
> a new record.
> I tried to right click my mouse,it doesn't select what I need to highlight.
>
> Please,any advice is welcome.
>
> JC
>

--000e0cd2457a450fed0469eec870--