Forum Replies Created
-
AuthorPosts
-
Shadow
MemberIf 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.
Shadow
MemberNot just better, the only way to accomplish your task is to use a programming language!
Shadow
MemberNo 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.
Shadow
MemberRitesh told me a while ago that this feature is planned for SQLyog MAX. Hope, this info is still correct!
Shadow
MemberFirst 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.
Shadow
MemberSometimes it is better to have that option checked…
Shadow
MemberTools -> Preferences and uncheck the option “Truncate column headers…” BTW, it scrolls past the text field, just the text field spans to its maximum width.
Shadow
MemberRitesh 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…
Shadow
MemberSQLyog'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?
Shadow
MemberI just started downloading it…
Shadow
MemberMySql released 4.1.7 yesterday, its fist production version of MySql. Its Windows installer works nicely on my W2K!
Shadow
MemberWell, 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.
Shadow
MemberNo 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.
Shadow
MemberBut 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