Forum Replies Created
-
AuthorPosts
-
ShadowMember
If you mean to have a column that is set to the current date when a record is inserted, then yes, this's what timestamp fields are for. If you mean to “log” the insertion date in any other table, then strictly speaking no, as MySql has no support for triggers as of now. Of course, you may still use transactions. You start a transaction, insert a record to a table, insert a current date to a second one, then commit. This method will never be that accurate like a trigger, but close enough.
ShadowMemberNot just better, the only way to accomplish your task is to use a programming language!
ShadowMemberNo need to delete the other libmysql.dlls, just make sure that the one in the installation folder is the only registered. If you have a running winmysqladmin, then stop it before editing registry entries if libmysql.dll! Winmysqladmin may load an older version of libmysql.dll which may crash SQLyog.
ShadowMemberRitesh told me a while ago that this feature is planned for SQLyog MAX. Hope, this info is still correct!
ShadowMemberFirst of all you have to use MySql 5.0 to be able to create views. You should check out MySql manual's corresponding chapter on how to create and use views.
ShadowMemberSometimes it is better to have that option checked…
ShadowMemberTools -> Preferences and uncheck the option “Truncate column headers…” BTW, it scrolls past the text field, just the text field spans to its maximum width.
ShadowMemberRitesh may correct me, but I don't think SQLyog will ever have FTP sync capabilities. It is designed to provide a GUI for managing MySql…
ShadowMemberSQLyog's scheduled synchronization does work – between dbs. However, I don't really understand why you are looking for file synchronization capabilities as SQLyog was designed to work with dbs. Am I missing something?
ShadowMemberI just started downloading it…
ShadowMemberMySql released 4.1.7 yesterday, its fist production version of MySql. Its Windows installer works nicely on my W2K!
ShadowMemberWell, If I were you, I would just write my own file syncing app. It's not that difficult, just lay out the synchronization rules beforehand and stick to them while developing. I wrote a tool from scratch in 3 weeks that syncs users' local work folder with a network based one when logging out, so all of their work can be accessed from any hosts.
ShadowMemberNo company ever charges for a alpha or a beta. The goal of releasing these preliminary versions is to get user feedback on bugs and possible improvements. Actually, alpha is an earlier version of a program than beta, so you question should be reversed.
ShadowMemberBut If you have only one saved connection, then there is no way to get SQLyog retrive the saved parameters. You have to enter them manually!
-
AuthorPosts