forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Sqlyog 6.02rc (not This One Filling Out The Fields Default)
- This topic is empty.
-
AuthorPosts
-
-
June 6, 2007 at 9:00 pm #24145
peterlaursen
Participantcould 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
MemberHello 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
Participantwhen 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
MemberThis structure of table!
-
June 8, 2007 at 1:03 pm #24149
peterlaursen
ParticipantFor me defaults display OK here.
What am I missing ?????? :huh:
-
June 8, 2007 at 1:06 pm #24150
peterlaursen
Participantmaybe 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
Memberpeterlaursen 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
MemberHello,
Thanks for reporting.
Issue is confirmed and also fixed in our development tree.
-
June 8, 2007 at 4:08 pm #24154
ShadowRSM
MemberI that I thank friends, for this great tool 🙂
-
-
AuthorPosts
- You must be logged in to reply to this topic.