[Is it nesscary to copy my.ini to C:\windows?]

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.

[Is it nesscary to copy my.ini to C:\windows?]

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.

[Problem Installing MySQL]

Maybe in the logs say something about the error.

 

Check the logs on the data folder.

[[SOLVED] dificulty entering a date]

Check if the data type of the field is datetime

[ODBC help needed?]

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"]

Try this...

 

Select * from Tablename where date_field >= '2009-08-19' and date_field<='2009-09-19'

[[SOLVED] 5-digit auto-increment ID]

Try Using ZeroFill...

 

example:

`id` int(5) unsigned zerofill NOT NULL auto_increment

[need to count yes and no results in rows]

Use IF.

 

if(case_open='yes',1,0)

 

This will reurn 1 is yes and 0 when is not.

[[SOLVED] Mysql - days retrival from two dates]

Let me see...

 

You want to check if a date it's between start_date & end_date.?????

[I have problem logging in to mysql from cmd]

Try This:

 

[*]Enable The Mysql Service

[*]On a cmd type: mysql --user=root --password=yourpass

 

 

[correct syntax for a exists with union?]

Apparently there is an error using UNION with an exists...

 

Google said: http://bugs.mysql.com/bug.php?id=25734

[my.cnf 4GB]

to do??

 

[Reading the number of duplicate zip codes in a database]

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]

Change the default value of INT type to 0.

[mysqldump --skip-lock-tables]

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_single-transaction

[Cannot make correct query]

I apologize, but my knowledge of php is not good yet,But there are experts here who can help you.

 

 

[Cannot make correct query]

 

For example if my tables looked like this

Blogtitle

A

B

C

C

 

Blog

A

B

C

D

 

The output would be:

A  -  1 match(‘s)

B  -  1 match(‘s)

C  -  2 match(‘s)

D  -  0 match(‘s)

 

 

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

[Cannot make correct query]

A query like this???

http://www.phpfreaks.com/forums/index.php/topic,262555.0.html

[[SOLVED] problem printing out count function]

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;

[[SOLVED] Deleting records from multiple tables?]

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]

Let google help you.... DbVisualizer

[ERROR 1062 (23000)]

That is because you have a duplicated key... maybe the structure has changes... check the primary keys of the table..

[ORDER BY.. appear last and random]

Maybe if you give to us more information, we can try to help you..

[[SOLVED] MySQL trigger trouble]

Did you check the syntax for Mysql Insert Statement??

[[SOLVED] Multiple Counts in one query]

Try this...

 

SELECT SUM(IF(gender='male',1,0)) AS 'male', SUM(IF(gender='female',1,0)) AS 'female' FROM nsnag