Sqlyog 6.02rc (not This One Filling Out The Fields Default)

This topic is empty.

Viewing 9 reply threads

Author

Posts
- June 6, 2007 at 9:00 pm #24145
  
  peterlaursen
  Participant
  
  could you explain again, please? I do not understand you very well!
  
  Basically it is not SQLyog, but the MySQL server that fills DEFAULTs into the rows of a table if a value is not specified in an INSERT statement. But if SQLyog inserts NULL or '' (empty string) or 0 (zero) explicitly then of course any other default will not be inserted. also if a default is specified in the table SCHEMA than SQLyog will/should display that value for every new row! I tested it briefly here and it works for me.
  
  Again I must ask for a test case! (a table schema and a description of what you are doing). When you catch that issue then copy the SQL statement sent by SQLyog form the HISTORY tab!
  
  Still MySQL 4.0.20 ? (in 5.0.x the server behaviour with DEFAULTS will vary with different 'sql-modes')
- June 8, 2007 at 11:28 am #24146
  
  ShadowRSM
  Member
  
  Hello friend, am going to explain better.
  
  Formerly the SQLyog was catching the values default of the charts when you were adding a new register.
  
  Now he does not fill out any more the columns according to the value default of that puts, and before he was doing this…
  
  I sincerely find what this function was helping in much in the addition of new registers!
- June 8, 2007 at 12:02 pm #24147
  
  peterlaursen
  Participant
  
  when you are saying 'formerly' what is the version that you compare with?
  
  For us DEFAULTS are displayed OK. I do not understand how that is happening for you! Are you perfectly sure taht there are defaults defined?
  
  Please attach a structure only dump to reproduce with!
- June 8, 2007 at 12:50 pm #24148
  
  ShadowRSM
  Member
  
  This structure of table!
- June 8, 2007 at 1:03 pm #24149
  
  peterlaursen
  Participant
  
  For me defaults display OK here.
  
  What am I missing ?????? :huh:
- June 8, 2007 at 1:06 pm #24150
  
  peterlaursen
  Participant
  
  maybe I understand now!
  
  You are talking about the RESULT tab and not DATA tab? and you click the + icon to insert a new row?
- June 8, 2007 at 1:15 pm #24151
  
  ShadowRSM
  Member
  
  peterlaursen wrote on Jun 8 2007, 10:06 AM:
  
  maybe I understand now!
  
  You are talking about the RESULT tab and not DATA tab? and you click the + icon to insert a new row?
  
  Even friendly this, when I click on the icon for a new register that it does with that this happens!
  
  Forgive for another thing me for my English since I key of Brazil and have to be using translators – online to talk, then sometimes they do not translate appropriately!
  
  Forgive for me therefore!
- June 8, 2007 at 1:32 pm #24152
  
  peterlaursen
  Participant
  
  “when I click on the icon for a new register” .. In English we would say 'row' and not 'register'. No issue .. now I understand.
  
  In the RESULT tab DEFAULTs do not display when you add a new row. Confirmed!
- June 8, 2007 at 2:46 pm #24153
  
  adarsh
  Member
  
  Hello,
  
  Thanks for reporting.
  
  Issue is confirmed and also fixed in our development tree.
- June 8, 2007 at 4:08 pm #24154
  
  ShadowRSM
  Member
  
  I that I thank friends, for this great tool 🙂
Author

Posts