gassaz
Members-
Posts
61 -
Joined
-
Last visited
Never
Everything posted by gassaz
-
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.
-
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.
-
Maybe in the logs say something about the error. Check the logs on the data folder.
-
Check if the data type of the field is datetime
-
Yes, you need install MyODBC driver. There are two versions: 3.51xxx and 5.xx you can use Either both.
-
return entiries only if the value of the field is more than '"2009-08-19"
gassaz replied to jasonc's topic in MySQL Help
Try this... Select * from Tablename where date_field >= '2009-08-19' and date_field<='2009-09-19' -
Try Using ZeroFill... example: `id` int(5) unsigned zerofill NOT NULL auto_increment
-
Use IF. if(case_open='yes',1,0) This will reurn 1 is yes and 0 when is not.
-
Let me see... You want to check if a date it's between start_date & end_date.?????
-
Try This: [*]Enable The Mysql Service [*]On a cmd type: mysql --user=root --password=yourpass
-
Apparently there is an error using UNION with an exists... Google said: http://bugs.mysql.com/bug.php?id=25734
-
Reading the number of duplicate zip codes in a database
gassaz replied to Peggy's topic in MySQL Help
SELECT visitor_zip, COUNT(visitor_zip) AS cnt FROM zip GROUP BY visitor_zip ORDER BY time_register -
[SOLVED] Problems with two tables #1067 Invalid default value for
gassaz replied to interspire09's topic in MySQL Help
Change the default value of INT type to 0. -
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_single-transaction
-
I apologize, but my knowledge of php is not good yet,But there are experts here who can help you.
-
If you want the results on this way, the sql that you made is wrong. You got the idea.. Try this: SELECT blog.title, COUNT(blogcomments.blogtitle) FROM blog INNER JOIN blogcomments ON (blog.title=blogcomments.blogtitle) GROUP BY blogcomments.blogtitle
-
A query like this??? http://www.phpfreaks.com/forums/index.php/topic,262555.0.html
-
Try this.. SELECT player.playerID, player.playerFirstName, player.playerLastName, COUNT(playerstats.playerID) FROM playerstats INNER JOIN player ON (playerstats.playerID=player.playerID) GROUP BY playerstats.playerID;
-
Something like this: DELETE users.*, illustrators.*, comments.* FROM users u INNER JOIN illustrators i ON u.user_id = i.user_id INNER JOIN comments c ON u.user_id = c.user_id WHERE u.user_id = ???
-
[SOLVED] visual representation of my tables relations
gassaz replied to simpli's topic in MySQL Help
Let google help you.... DbVisualizer -
That is because you have a duplicated key... maybe the structure has changes... check the primary keys of the table..
-
Maybe if you give to us more information, we can try to help you..
-
Did you check the syntax for Mysql Insert Statement??
-
Try this... SELECT SUM(IF(gender='male',1,0)) AS 'male', SUM(IF(gender='female',1,0)) AS 'female' FROM nsnag