Forum Replies Created
-
AuthorPosts
-
Shadow
MemberIn the sql editor type in SELECT * from my_table LIMIT 1; , and then press F8 (Select for update) and there you are!
MemberMySql doesn't have any built-in front-end no matter how you install it, of course. My intention was to point out that it may be run as a standalone program as well. The rest of your reply was absolutely correct, I'm sorry if you misunderstood me!
I usually revert to start/stop MySql through winmysqladmin (this is the app you talked about which won't start automatically with MySql) and then I have a nice “traffic light” sitting in my tray indicating whether MySql is running or not regardless of the installation type.
MemberSorry CalEvans, I must correct you! When installing MySql on Windows you can choose from two options in case of NT, 2000 and XP: to install it as a service or a standalone server (executable). On Win9x, only the standalone mode is available (there are no services on Win9x).
artane, if I were you, I would first read the MySql's instructions on how to install the db on Win32 platforms. It isn't difficult at all, you can figure it out in about 20 minutes.
MemberJust one more thought: in ODBC text driver you may determine type of the fields. You may want to set “notofication date” to text, but I still suggest you to use date as field type!
MemberThe problem with ODBC is that it tries to figure out the field types and change the values accordingly. Apparently ODBC recognized your “notification date” field – correctly – as date. BTW, you should consider storing that column in a date field because date type corresponds best to that field. In your app you can render the date values as you wish.
MemberBased on the file exerpt you had provided, I performed the file import, and I must say, MySql got it in the right way – the date field was preserved exactly as it was… What import did you use, ODBC or CSV and with what options?
MemberI have encountered the same problem as well, but after minimizing and then restoring the window results in a full repaint.
MemberTher may be several reasons for thismessage:
– MySql is not installed
– MySql is installed, but it is not running
– port number is incorrect.
MemberYou need the exact name of the computer that runs MySql and the port number it listens to, your ISP should provide these information upon request. That “[email protected]” seems to be a user name to me, rather than a computer name. It should be: your_username@your_computername or (if you have a permanent IP address) your_username@your_IPAdress.
MemberSetting lower_case_table_names variable to OFF (default is ON) should solve the problem.
MemberNo, I don't really get what you mean. It works for me exactly the way you described. What version of SQLyog do you use?
MemberWhen do you get this error message? Right after logging in or after executing a few queries?
MemberYour hosting company must have upgraded to MySql 4.0.x, and this version does not show the db's by default. At the 'Connect to MySql host…' dialog specify your Database name. Hopefully, this will solve your problem.
MemberThat's true, either I made a mistake or the test server was shut down for some reason when I got this warning.
MemberType in your query that retrieves the desired records, then press F8 ('select for update') and there you are.
-
AuthorPosts
