MYSQL

NAVIGATION

FW: Error 2003: Cannot connect to mySQL server on localhost <10061>

Bob Melis wrote:- I've checked process running and I cannot get mysql to run usingtheCMD window and typing mysqld or mysqld-n.Please elaborate(or copy/paste from cmd window.)RESPNSE1cmd procedure:cd\mysql\binmysql>mysqldmysql>mysqld-ntto try and get it runningend1- err file in data di...

0 answers | 2498 bytes |

Error 2003: Cannot connect to mySQL server on localhost <10061>

MessageFrom: David Dindorp [mailto:ddi (AT) dubex (DOT) dk]Sent: Tuesday, November 29, 2005 3:56 AMTo: Bob MelisSubject: RE: Error 2003: Cannot connect to mySQL server on localhost<10061>Bob Melis wrote:- I've checked process running and I cannot get mysql to run usingtheCMD window a...

0 answers | 2720 bytes |

Can I weight full-text searches in boolean mode?

Hi, I have a table with consumer products. I have a row "product name" and "brand". If I do a full-text search in boolean mode for a term like "apple ipod" I get results like: Apple iPod (brand: Apple) TuneDock for Apple iPod (brand: Belkin) Since both of these terms match "apple" and "ipod" the...

0 answers | 966 bytes |

What is MYSQL equivalent to Oracle's NVL function?

The subject says it all!...

1 answers | 35 bytes |

bk commit into 5.1 tree (patg:1.1964)

Below is the list of changes that have just been committed into a local5.1 repository of patg. When patg does a push these changes willbe propagated to the main repository and, within 24 hours after thepush, to the public repository.For information on how to access the public repositoryseeChange...

0 answers | 47108 bytes |

bk commit into 5.0 tree (jimw:1.2030)

Below is the list of changes that have just been committed into a local5.0 repository of jimw. When jimw does a push these changes willbe propagated to the main repository and, within 24 hours after thepush, to the public repository.For information on how to access the public repositoryseeChange...

0 answers | 5336 bytes |

SQLquery: delimiter // - #1064 error

HI David,The following error is generated calling the previously defined storedprocedure p0() in phpmyadmin:ErrorSQL query:call p0()MySQL said:#1312 - PRCEDURE tr.p0 can't return a result set in the given contextAny suggestions would be greatly appreciated MessageFrom: Logan, David (SST - A...

0 answers | 1985 bytes |

SQLquery: delimiter // - #1064 error

Hi Dave,The DELIMITER statement is a command to the mysql client not an SQLstatement. This is why phpAdmin is objecting. Here are a listing of themysql client commandsRegardsDavid LoganDatabase AdministratorHP Managed Services148 Frome Street,Adelaide 5000Australia+61 8 8408 4273 - Work+61 417 2...

0 answers | 1423 bytes |

SQLquery: delimiter // - #1064 error

Windows XPphpMyAdmin 2.7.0-rc1MySQL 5.0.16-nt running on localhost as root@localhostThe DELIMITER statement works in the command line, but not in phpmyadmin(see error below)mysqlDELIMITER //mysqluse mysql //Database changedmysql>PHPmyadminDELIMITER //ErrorThere seems to be an error in your SQ...

0 answers | 789 bytes |

cant link tables in Access

I am trying to create tables linked to a Mysql databasein MS Access. I get the widow to select a Data Source.I click on the (system) DSN I created (and tested ok)for my Mysql database, and click ok. The DatabaseSource selection window disappears, but no widowshowing the Mysql tables ever appears...

1 answers | 651 bytes |

Error 2003: Cannot connect to mySQL server on localhost <10061>

I would get the latest versions of both MySQL and MDBC and reinstall,carefully following the instructions in the MySQL manual on Windowsinstallation. It all runs under XP Pro SP2, I am running it.John B. MessageFrom: Bob Melis [mailto:bobmelis (AT) adelphia (DOT) net]Sent: Tuesday, 29 November 2...

0 answers | 1777 bytes |

simple question

I would thing that given: -- the day of week of the start date- the day of week of the finish date- the number of weeks between the start and finish datesYou could create some logic to figure how many, say Tuesdays, occur betweenthe two dates.If there are 10 whole weeks then there would be at le...

0 answers | 1325 bytes |