Manually Paste Clipboard Data Into Results Window?

[peterlaursen]

Of course it should make no difference how you enter data into a cell.

1)

Are you telling that with 'paste from clipboard' you get another behavior as compared to 'type with keyboard'?

2)

Is this UDATE statement correct (what you did)

Code:

UPDATE `students` SET `tag`='x',`last_name`='Onion',`first_name`='Suzy',`teacher`='Crabtree' WHERE `tag`='x' AND `last_name`='Onion' AND `first_name`='Suzy' AND `teacher`='';

.. changed `teacher` from '' (empty string) to 'Crabtree'?

(I still do not understand why you do not add an auto_increment PK to your tables. You will get lots of issues (example: no protection against duplicate rows) and bad performance!)

[sqldave]

peterlaursen wrote on Jun 30 2009, 11:55 AM:

Of course it should make no difference how you enter data into a cell.

1)

Are you telling that with 'paste from clipboard' you get another behavior as compared to 'type with keyboard'?

2)

Is this UDATE statement correct (what you did)

Code:

UPDATE `students` SET `tag`='x',`last_name`='Onion',`first_name`='Suzy',`teacher`='Crabtree' WHERE `tag`='x' AND `last_name`='Onion' AND `first_name`='Suzy' AND `teacher`='';

.. changed `teacher` from '' (empty string) to 'Crabtree'?

(I still do not understand why you do not add an auto_increment PK to your tables. You will get lots of issues (example: no protection against duplicate rows) and bad performance!)

Thanks for your help.

1. Yes, this seems to be the case in my example.

2. Yes. As you can see, the UPDATE statement did not “capture” my pasted data (using CONTROL-V to paste teacher “Crabtree”).

3. So far, I am the sole user of MySQL for my projects. Because I get most of my data from a big state-wide database (operated by many professional DBAs), I don't have to worry about duplicate data. My biggest table is only about 50,000 rows and my longest MySQL “program” is about 1700 lines and takes only 8 minutes to run, which is fine for me. A nice coffee break.

Thanks!

[peterlaursen]

It did capture as far as I can see. Formatting a little will show.

UPDATE `students`

SET `tag`='x',`last_name`='Onion',`first_name`='Suzy',`teacher`='Crabtree'

WHERE `tag`='x' AND `last_name`='Onion' AND `first_name`='Suzy' AND `teacher`='';

In the SET clause (new data) it reads …`teacher`='Crabtree'

In the WHERE clause (old data) it reads …`teacher`=''

… so the `teacher` column should change from '' (empty string) to 'Crabtree'

What am I missing?

[sqldave]

peterlaursen wrote on Jun 30 2009, 12:43 PM:

It did capture as far as I can see. Formatting a little will show.

UPDATE `students`

SET `tag`='x',`last_name`='Onion',`first_name`='Suzy',`teacher`='Crabtree'

WHERE `tag`='x' AND `last_name`='Onion' AND `first_name`='Suzy' AND `teacher`='';

In the SET clause (new data) it reads …`teacher`='Crabtree'

In the WHERE clause (old data) it reads …`teacher`=''

… so the `teacher` column should change from '' (empty string) to 'Crabtree'

What am I missing?

In my original post, did you follow the steps and attempt to duplicate my activity? If you did, I think you will see what I mean. When I follow those sets, the data is not saved.

I just verified this once again on my computer.

I don't know how I can state the case any more plainly. It should be easy to reproduce the behavior.

Now, either I'm expecting something to happen that isn't meant to happen in SQLyog — OR — there seems to be an issue in the program. I just want to know which.

Thanks!

[navyashree.r]

Hi,

Issue confirmed. Added in our tracker,

http://code.google.com/p/sqlyog/issues/detail?id=1110

Regards,

Navya

[sqldave]

navyashree.r wrote on Jul 1 2009, 01:16 AM:

Hi,

Issue confirmed. Added in our tracker,

http://code.google.com/p/sqlyog/issues/detail?id=1110

Regards,

Navya

Thank you very much for looking into this! I think this is why SQLyog is such a great product.

[navyashree.r]

Hi,

Fixed internally and available in next 8.13 Beta release probably Monday.

Regards,

Navya

[navyashree.r]

Hi,

This issue is fixed and available in 8.13 beta2, publicly available!

Please refer to:

http://www.webyog.com/blog/2009/07/15/sqly…-been-released/

Please let us know the status.

Thank you.

Regards,

Navya

[Author]

Posts