Jump to content

gassaz

Members
  • Posts

    61
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

gassaz's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Some times when the wizard is executing the configuration (the last step) report a error for the mysql services start, check if the service name don't exist. if exist and you don't use it you can erase it. Another idea is try with a different version of mysql.
  2. I think the problem is because you don't select te option "INCLUDE PATH....." in the config wizard. if you like to put the my.ini on mysql directory Solution 1: Add the path manually (google: winxp path) Solution 2: Run again the config wizard, but if you have data make a backup firts; and select the option to include the path.
  3. Maybe in the logs say something about the error. Check the logs on the data folder.
  4. Check if the data type of the field is datetime
  5. Yes, you need install MyODBC driver. There are two versions: 3.51xxx and 5.xx you can use Either both.
  6. Try this... Select * from Tablename where date_field >= '2009-08-19' and date_field<='2009-09-19'
  7. Try Using ZeroFill... example: `id` int(5) unsigned zerofill NOT NULL auto_increment
  8. Use IF. if(case_open='yes',1,0) This will reurn 1 is yes and 0 when is not.
  9. Let me see... You want to check if a date it's between start_date & end_date.?????
  10. Try This: [*]Enable The Mysql Service [*]On a cmd type: mysql --user=root --password=yourpass
  11. Apparently there is an error using UNION with an exists... Google said: http://bugs.mysql.com/bug.php?id=25734
  12. SELECT visitor_zip, COUNT(visitor_zip) AS cnt FROM zip GROUP BY visitor_zip ORDER BY time_register
  13. http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_single-transaction
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.