Jump to content


Photo

Varchar Field With Value "default" Does Not Save


  • Please log in to reply
3 replies to this topic

#1 ildar

ildar

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 26 January 2012 - 02:44 PM

sqlyog enterprice 6.5 mysql
if I set value to "default" it doesn't save

#2 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,869 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

Posted 26 January 2012 - 07:18 PM

Please read this FAQ: http://webyog.com/faq/8_99_en.html




You can:

1) turn off 'smart keywords' from tools .. preferences .. 'others' tab. Please see image below.

or

2) enclose in backticks (like `default`) when inserting from SQLyog DATA/RESL GRID or FORM view




Attached File  smart.jpg   78.36KB   4 downloads



Computers make your grey hair come off ....

Peter Laursen
Webyog

#3 ildar

ildar

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 26 January 2012 - 08:52 PM

Please read this FAQ: http://webyog.com/faq/8_99_en.html




You can:

1) turn off 'smart keywords' from tools .. preferences .. 'others' tab. Please see image below.

or

2) enclose in backticks (like `default`) when inserting from SQLyog DATA/RESL GRID or FORM view




Attached File  smart.jpg   78.36KB   4 downloads


Thank you. I think that it is a bug, for example if there is already a "default" value in the table and i change other field in the same row the "default" is replaced with "". Its wrong i thing

#4 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,869 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

Posted 27 January 2012 - 12:18 PM

Please read release notes for SQLyog version 8.13 (http://webyog.com/fa...on-history.html)

"When updating from DATA or RESULT grid the UPDATE statement will now only list columns that were changed. That results in more readable statements and may also improve performance with 'wide' tables and tables with large BLOB/TEXT columns."

Additionally this solves this problem (if I understand what you are telling).




And it does not really makes sense to discuss bugs witn an ~5 year old program version. You should upgrade.
Computers make your grey hair come off ....

Peter Laursen
Webyog




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users